-
SQL Query with Date in where clause from global variable
I am have a SQL query in dataiku set up like so: SELECT * FROM "dbo"."Table" where "Date" BETWEEN CAST(${prior_val_date} as date) AND CAST(${val_date} as date) I am getting this error message: Validation failed: Query failed: Explicit conversion from data type int to date is not allowed. my variables are defined like so: {…
-
Read the contents of a json file into a json object from a managed folder in dataiku
I need to read contents of a jsonfile stored in a dataiku managed folder. Need the code for doing the same with dataikuapi package. TypeError: the JSON object must be str, bytes or bytearray, not 'HTTPResponse' import dataikuapiclient = dataikuapi.DSSClient(host, apiKey)client._session.verify = Falseproject =…
-
Association rules with R recipe
i have a dataset with product_id objectproduct_name objectcategory objectdiscounted_price float64actual_price float64discount_percentage float64rating float64rating_count float64about_product objectuser_id objectuser_name objectreview_id objectreview_title objectreview_content objectimg_link objectproduct_link object i…
-
How to suppress debug.dku.ml.preprocessing in jupyter notebook?
Hi all, How can I suppress/ignore this warning message in jupyter notebook? Operating system used: Windows
-
Coalesce function doesn't work properly in prepare recipe
Hi everyone! I have a question regarding the coalesce recipe in dataiku. I wanted to use the coalesce funtion in dataiku Formula and the preview that I have in the prepare recipe shows that the function works and it shows the value that I want. But after executing the recipe, the resulting column shows a different output…
-
Using Script Scenario
The Webhook URL of a MS Teams channel can be used in the 'Reporter' to send scenario related messages to that Teams channel. However, I would like to know whether or not it possible to send messages to the same MS Teams channel programmatically using Dataiku Scenario API. I simply want to use two separate channels (mail…
-
"Enrich records with files info" in prepare recipes working only on csv files ?
Hi all, Working on a prepare recipe which is just after an initial dataset regrouping several files. I have no problem with the step when all my initial files are .csv. But when my files are .xml, the resulting column is empty. Same empty result when my files are "on data per-line" based. What am i missing here ? (in…
-
Dataset change trigger
When I use dataset change trigger to run a scenario, how can I get the changed path or folder from a python code within the scenario Thanks
-
Launch scenario if dataset is not empty
Hello, I would like to trigger one step of my scenario if one of my dataset is not empty. What I did is: 1- Create Check in my dataset (that I called NUMBER_RECORDS) to verify that record count>1 (img1) . 2- Create "Run Check" step on this dataset. 3- Create step I would like to launch based on condition…
-
Exclude specific dataset build from scenario
Hello, I need to exclude a part of my flow from being built during the execution of a scenario, because this part is to built only once in a while. For now, I have to do it in "Build only these items" mode and list all the datasets I actually want to build. Would it be a way to exclude the few datasets I DON'T want to…
