-
Using date variables
Hi, I'm wanting to store a date in the project variable list, but can't figure out how to make the variable read as a date in, say, a formula step in a recipe. I've tried to format the date as "yyyy-MM-dd" with and without quotes, as well as "yyyy-MM-ddT00.00.00.000Z" with and without quotes. When I do the simple date…
-
SQL key words
Writing sql query in dataiku, but some key words are not executing dataiku. i would like to understand, the familiar sql tool , is it ssms, workbench etc ? Operating system used: windows Operating system used: windows
-
Can't delete files in managed folder
Hi, I uploaded a file to a managed folder in dataiku. Then I noticed it has to be renamed so I did that. After that there is the new renamed file, but also the old file with wrong name. When I try to delete the old file I get: Deleting items... Errors were encountered Failed to delete S3 file, bucket=s3-prod-01-*****.xlsx,…
-
Renaming recipes via Dataiku API
Hello, I am trying to rename some recipes via the API (as opposed to by hand as we want to rename quite a lot). This is the code I am trying to run: project = client.get_project(project_key) recipe_object = project.get_recipe(recipe_name) recipe_object.rename('the new name') Trying to run this gives the following error…
-
What are the steps to refresh an excel file?
This should be really simple… None of the steps I have found online work.
-
Best Way to integreate GIT with Code Studio for version control
We have in house python package developed and they are used as main building block for DSS Recipes. And recently we start to integrate Code Studio with hope to use it as the main IDE for development work directly on the cloud. We currently has a Code Env which include all the in house python package we develop, and we can…
-
Long Queue Time in Jupter notebook
Recently we start to experience a long queue time when we run multiple block in DataIKU jupyter notebook. The block will show execution queued and it will take a long time until the block get executed and return the result, even when the block only try to calculate simple formulas like 1+1, and the actual exectuion takes 5…
-
The 'exec_recipe_fragment' method of 'SQLExecutor2' class fails to perform
Hello, I was exploring the following code example: https://developer.dataiku.com/latest/tutorials/data-engineering/sql-in-code/index.html#code-recipe-examples But I got an error from the exec_recipe_fragment method (attached below). I tried both options of the overwrite_output_schema parameter but did not succeed. Any help…
-
Best practices for real-time APIs?
Has anyone got any best practices they can recommend for development, testing and deploying real-time API services? At the moment we have considered documenting and testing under load. Does the community know of anything else we can add?
-
Append each refresh into a separate dataset
Hi team, I currently have a dataset that connects to an online sharepoint, with the scenario function it is now autorefreshed weekly. I would like to build a new dataset to append all the versions to compare the changes/ evolution. Could you help with some guidance? many thanks
