-
Full outer join
Is there a way to do a full outer join between to datasets stored in the DSS memory (so basically made by recipes or analyses) ?
-
Handling double query execution and compute costs with Databricks SQL
Hi everyone, Our team relies heavily on Dataiku integrated with Databricks SQL, and we’ve recently been investigating our compute costs. We noticed a specific behavior with standard SQL Query Recipes that we'd love to get the community's thoughts on. The Observation When building a new dataset using a SQL Query Recipe…
-
SQL autocomplete in Dataiku's Notebook
Hi, I'm unable to get SQL autocomplete to work in Dataiku's SQL Notebook when connected to BigQuery.
-
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…