-
Got the error "API Key not provided" when call to python API endpoint
I have created a python function API endpoint in API designer, when I run the test query, it works well. After that, I created an API key for this API service, but when I call the public API endpoint via Postman (i found the guide here: https://doc.dataiku.com/dss/latest/apinode/first-service-apideployer.html) : URL:…
-
How to fill cells of column with previous non null value
I have a table that is presorted that shows teams and players. What I'm trying to do is create some kind of calculation to fill my blank cells for team, I want the cells to be filled with the last non null value that precedes that row. For example, row 3 is blank, the last non null preceding value is row 1 = green, so I…
-
Number of Rows
Hello, I am using Dataiku Dss for managing for the organization I am working now. The idea is I am collecting above 230000 records (rows) by using Kobo Form. I use API to import the data from Kobo to Dataiku. Currently, I have above 50,000 records on Kobo but am able to get only 30K rows on Dataiku. Is there any way to get…
-
In python Webapp pass global variable of person logged in and interacting with the app
Hi Everyone, I did look through existing discussions and I have not see exactly the answer I'm looking for. Either in a python notebook, and by extension a python Webapp, I would like to grab the DSS user id that is currently logged in and interacting with the webapp in a variable. My use case, is I created a webapp where…
-
Use file from code env resources directory with API Test queries
I've built a python API endpoint that uses a certain code environment. In the resources folder of that code environment is a file. If I run the API code in a notebook using that code env, I'm able to access that file. But when I run Test queries in the API Designer, the file cannot be found. The code used is the same in…
-
issue in loading data in to teradata
I don't understand the issue in loading data in to Teradata , for same I'm able to .csv data set which is successful. might be some characters but its not strange characters , #,-,',(,/ [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch…
-
How to get the value before a specific delimiter
If I have a string value formatted as firstname_middlename_lastname_initials_age_gender and I only need everything before age, is there a formula I can use to give me everything before the fourth instance of my delimiter "_"? I know I can probably use the split function to split them all apart and then concat together the…
-
How to pivot from column to rows
I have data that has a column with the days of the week, source and season. I'm trying to split my days column to rows. I have picture of my current input and expected output. I tried to use the split function but that split the days into different columns not rows. is there a way to get my desired output using dataiku?…
-
How to filter dates less than current day
I have a dataset that has a list of dates and days of the week, is there a way I can filter my dataset for dates that are less than or equal to the current date? I tried the formula date = now() but I don't think that's working, it just filters all my data out. Operating system used: windows
-
Suggestions on deploying an End Point
I have a dataset with content and URLs, I have created embeddings for this content and saved in a new dataset, so it now has the embedded content and the URLs, I want to create an API which can send content and I embed this content and perform a similarity search on the embedded dataset and give the top 3 matched URLs, I…
