-
DtypeWarning. Columns have mixed types
Hi, I have checked whole flow for the column '0' and is set to 'string' and 'Text' everywhere. Sadly when this data is dump to SQL Table values are converted to "int" Any idea?
-
SQL API Endpoint Error: "No value specified for parameter 1" despite providing test parameters
I am encountering a 500 Internal Server Error when testing a SQL Query endpoint in the API Designer. Even though I have defined the placeholder and provided the test JSON, the system fails to bind the value. Environment Feature: API Designer / SQL Query Endpoint Dataiku Version: 14.2 Backend DB: PostgreSQL Here is a…
-
Perform quick SQL query on SQL dataset from UI
For my workflow it would be very helpful to have the option to perform a quick SQL query on a (SQL) dataset in the Flow from the UI. For example by right clicking. Things like count distinct values of a specific column, etc. Right now, I go to my separate SQL client to perform these quick checks, but that requires tool…
-
The recipe execution is taking long time due to handling a large volume of data in dataiku
We are experiencing long execution times for a recipe in Dataiku due to handing large datasets, while we have implemented partitioning using a filter on a specific column, it still takes 1.5-2 hours to partitioning 30M records. Is there a more efficient way to handle and process this data quickly and effectively because…
-
Influx DB to Dataiku
Hi all! Do anyone have solution to connect Influx DB to Dataiku? Operating system used: Linux
-
Validate at SQL recipe using the public API (python)
How do you validate a SQL recipe using the public API?
-
SQLExecutor2 exec_recipe_fragment multiple statements and
I'm following the tutorial found here https://www.dataiku.com/learn/guide/code/python/use-python-sql.html but had some additional questions. 1. Is it possible to submit multiple statements with SQLExecutor2.exec_recipe_fragment()? The script creates multiple volatile tables before constructing the final table. I want to…
-
How do you use SQL Script in recipe as application
I have a flow where I use SQL scripts to create datasets (see image). I follow the instructions as described here: https://knowledge.dataiku.com/latest/courses/o16n/dataiku-applications/create-app-as-recipe.html The issue is that when the flow is converted to a recipe as an application, while the log reports that the names…
-
Error: Invalid number of columns in query
Hi, After create my connection with sucess to my postgresql database. I've the following error when I import my table in my project : An invalid argument has been encountered : Invalid number of columns in query (2, expected 0) SELECT * FROM "public"."ape_ref" LIMIT 10000. Please check dataset schema Could you explain me…
-
An error occurred ERROR: permission denied for schema dku_tshirt Position: 67
I get the following An error occurred ERROR: permission denied for schema dku_tshirt Position: 67 when trying to run SELECT campaign, AVG(total), SUM(total), COUNT(campaign) FROM "dku_tshirt"."DKU_TUTORIAL_SQL_customers_enriched" WHERE birthdate >= '1980-01-01' AND birthdate < '1990-01-01' GROUP BY campaign in the Dataiku…