-
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…
-
Why Aren't Record Counts Computable by Default?
In my DSS flows, I always activate record counts to check the volume of my datasets. However, it is cumbersome to activate them one by one, and it seems that it is not possible to activate them by default for an entire project. Why doesn't DSS allow this? Operating system used: RHL 8
-
SQL API ENDPOINT (Passing multiple values in test query)
Hi, I am trying to create a SQL API endpoint using a select query to my database. select * from table where state in (?) and city in (?) parameters param1, param2 The query works fine, however problem arises when i try to filter records for multiple values of a parameter. Just wanted to check where am i going wrong with…
-
DSS visual recipes defaulting to max column length with Redshift tables
Hi everyone, When working with Redshift tables in DSS visual recipes we noticed that the table creation settings sometimes defaults to setting certain column lengths to the redshift max (65,000). In many cases this becomes excessive. For example, in the screenshot below the "brand" column has a length of 65k but most of…
