-
Correlation Matrix
Hello, I was wondering if we can download a correlation matrix visualization from Dataiku ? Thanks in advance for your help.
-
Empty values vs Null values
Hi Everyone, I want to know a way to distinguish between null values and empty values because I used the isNull() function in the prepare recipe but that function didn't recognize that difference. Regards
-
Fill in gaps - incremental load
We have requirement which requires full historical data, however we are using incremental load, is there any recipe for this action?
-
now() function is not returning the correct date
Hi, I am using Dataiku on a virtual machine (Red Hat) In the prepare receipes, the now() function returns the wrong date. I have this problem with every dataset in every project Thanks for your help. Operating system used: Virtual Machine ( Red Hat)
-
Changing Dataiku's timezone for DSS formula's
How do you adjust the timezone that is used for the DSS formula language? For instance, the now() formula is now 2 hours behind (was 1 hour prior to summertime). It's not necessary to make any retroactive changes, we would just like to get our local time from now on. I imagined this would be a global setting somewhere in…
-
starting a project with pyhon script that generate data, is it possible ?
Hello everyone, I'm new to dataiku. I developped a python script that is collecting data from differentes (web scrapping, local files...) sources before generating a pandas dataframe, then I performe my analysis on it. I would like to switch this project into dataiku. BUT, when I start a project, I need a dataset whereas I…
-
Can I call Databases on a Deployed API using Python?
I have several databases that I'd like to access from an API I'm deploying. The databases are stored in the following postgres table: api-node-referenced-data I currently have many different SQL queries that are used to access the tables, but I'd like to change them all to a parameterised query in Python to avoid repeated…
-
Using date in DataIKU
Hi, Despite going through documentation multiple times, I still don't really understand how dates work in DSS. I'm importing dataset from a connection. Without turning on any of the options in Date & Time handling, this is how data looks like: It says that the data type is string, while in the database itself it is, in…
-
Test Capability filter using SQL Expression in Join Recipe
Hi, I got this dataset tx and cards_prepared dataset from your Dataiku Academy https://academy.dataiku.com/path/core-designer/visual-recipes-overview-1/500697 I’m doing it by starting from scratch. I'm using filter in join recipe using SQL Expression using a default one; "purchase_date" LIKE CONCAT('%',…
-
container configuration for streamlit app
Dear Experts, I am having difficulties in starting Streamlit app. In the container configuration, as shown in the attached image, when I select None, it gives error "Unable to start run : No container config to run Code Studio on". However when I select container ai_exec gpu, it always say Pod is still missing. I do not…