-
How to correctly do time conversions
I have a column that has been parsed and is in UTC, when I try to format the date to be in eastern / New York time I get a new column that is -5 hours, but isn't the current the current difference -4 hours? I'm sure this has something to do with daylight savings time vs normal time, but I just want to ensure that my…
-
List users all instances
Hi, I'm have 3 instances running in parallel (PRE, PROD and an Event server). I want to make a dashboard about the users activity across all the instances. I want to list all the users in each instance and when was the last activity of each user. I tried this code: import dataikuclient = dataiku.api_client()dss_users =…
-
Folders
Hi, I want to save a model written in a python recipe in a Folder, however it generates an error that the Folder must be declared as output. How do I declare the Folder to be able to save pkl's there?
-
gpt-4o no multimodality supported with chatbot webapp
Hi, I have these options for a model to use for an LLM powered webapp: And I get this option to upload images: With ChatGPT-4o however there is no "omni" support currently... And my webapp looks like this: Has anyone figured it out?
-
How to use images as an input to Prompt Studio and get the explanation about the image using the LLM
I have few images/diagrams in my managed folder. Now, I want to use those images/diagrams as an input in the prompt studio and want to generate the explanations of the images/diagrams using the LLMs. How can I achieve this in the Dataiku? Thanks for your help! Operating system used: Windows
-
DataIKU visual webapp with Gemini 1.5 pro
If I use Gemini 1.5, the upload option is visible to upload user files as you can see below: But there's an error when using it with or without uploaded files: File "/data/dataiku/dss_data/web_apps/DS1948/V9u5gZh/python-lib/backend/routes/ws/answer_streaming.py", line 173, in process_and_stream_answer for chunk in…
-
Trigger on Dataset Modified for Partitioned Dataset
Hi Team I'm reading the data from SharePoint and the format of the file is Cost Center_06092024.xlsx As the file comes with the date format, I partitioned reading the data as /Cost Center_%M%D%Y.xlsx and in my prepare recipe set the option as Last available by that the flow ONLY get the latest file. I'm trying to create a…
-
Extract elements from Dataiku variable in SQL query
Hello, I declare a variable List_x in Dataiku project as a tuple of 3 elements A, B and C. { "List_x" : "('A', 'B', 'C')"} With SQL query, how could I extract each element of this variable ? The goal is to use "List_x" in a Case when syntax, like this: SELECT *, CASE WHEN X = List_x(0) THEN 1 WHEN X = List_x(1) THEN 2 WHEN…
-
What is the difference between the dataiku and the dataikuapi packages?
From what I could see, both seem to have the same functionality when I used them outside the Dataiku web interface. I see documentation for both the packages but they seem to be conflicting. For example, in this page section, in the illustrative code, we are importing dataiku, but just below it, it is written that a…
-
How to choose between updating and appending an output table
I have an connection / output recipe that is outputting to a table in snowflake, I don't see any option in here to choose between outputting and appending data, where can I set that up? does the option pop up after I press run? or is that something I can set up before hand? Operating system used: windows
