SQL databases

Disk-based partitioned dataset performance

Question btsmerchandise 687 views 1 comment 0 points Most recent by Alexandru May 2023Using Dataiku
InvocationTargetException while writing dataset into postgreSql DB.

Question srikanth_ch 1.6K views 4 comments 0 points Most recent by srikanth_ch May 2023Using Dataiku
Dataiku Application Test Instance

Question emilieg 1K views 1 comment 0 points Most recent by Zach April 2023Using Dataiku
SqlExecutor2 does not handle Snowflake ARRAY data type * Bug?

Question info-rchitect 2.3K views 4 comments 0 points Most recent by Kanyenewmerch9 April 2023Using Dataiku
Tips for working with SQL Temporal tables?

Question Jason 513 views 0 comments 0 points Most recent by Jason March 2023Using Dataiku
Handling long variables in SQL Query (Teradata)

Question Sv3n-Sk4 813 views 0 comments 0 points Most recent by Sv3n-Sk4 March 2023Using Dataiku
Date format detection, Dataiku versionning

Question Kouegou Kamen 1.6K views 2 comments 0 points Most recent by Kouegou Kamen February 2023Using Dataiku
Database modeling UML

Question Abdelali_MERHOM 909 views 1 comment 0 points Most recent by JordanB December 2022Using Dataiku
Loop join Bigquery

Question User06 1.2K views 1 comment 0 points Most recent by Sarina December 2022Using Dataiku
SQL queries using AWS Athena - why an error when adding comments?

Question Tanguy 5.3K views 7 comments 2 points Most recent by Tanguy November 2022Using Dataiku
Scenario reporter deleting table rows after schema modification

Question BlueRabit 500 views 0 comments 0 points Most recent by BlueRabit November 2022Using Dataiku
My BQ table becomes unavailable when my workflow is running

Question kccruz 1.1K views 1 comment 0 points Most recent by fchataigner2 September 2022Using Dataiku
Can I delete some duplicates with my iPhone?

Question Kmediavietnam 1.5K views 3 comments 0 points Most recent by tgb417 August 2022Using Dataiku
Storing Datasets in Dataiku (with SQL Server and More)

Question ZeevGetner 2.1K views 2 comments 0 points Most recent by ZeevGetner August 2022Using Dataiku
Setting primary key for result table in recipes

Answered ✓ Antal 1.6K views 1 comment 0 points Most recent by Alexandru July 2022Using Dataiku
Best practice for historization SQL Recipe

Question Kyest00 3.6K views 5 comments 0 points Most recent by Turribeach July 2022Using Dataiku
Dynamic Data sources

Question jonesaaron993 1.2K views 1 comment 0 points Most recent by Turribeach July 2022Using Dataiku
Unwanted time zone conversion in join recipe (Redshift)

Answered ✓ Filip_Pejsa 1.2K views 1 comment 1 point Most recent by fchataigner2 June 2022Using Dataiku
SQL recipe psql error

Question Meirkhan 1.7K views 2 comments 0 points Most recent by Meirkhan June 2022Using Dataiku
update an existing column without creating a new dataset in flow recipe.

Question Aray 1.1K views 1 comment 0 points Most recent by Alexandru May 2022Using Dataiku
Casting id to string in join recipe

Answered ✓ jvijayakumar2 6.1K views 3 comments 0 points Most recent by jvijayakumar2 May 2022Using Dataiku
Integration with SQL Databases (Postgres) fails authentication

Answered ✓ Angelo 10.4K views 13 comments 0 points Most recent by CoreyS April 2022Using Dataiku
Sort Recipe is useless

Answered ✓ davidmakovoz 4.8K views 3 comments 0 points Most recent by Ignacio_Toledo April 2022Using Dataiku
Partitioning in Oracle SQL Table

Question pkansal 1.1K views 1 comment 0 points Most recent by fchataigner2 March 2022Using Dataiku
Sync array column to PostgreSQL table

Answered ✓ valentinaprotti 1.6K views 1 comment 0 points Most recent by Alexandru December 2021Using Dataiku
Copy data from a MySQL database to Vertica

Answered ✓ Romain_L 4.5K views 6 comments 0 points Most recent by Marlan November 2021Using Dataiku
'Sync'ing Redshift to S3 causes a syntax error

Question pillsy 2.8K views 3 comments 0 points Most recent by pillsy October 2021Using Dataiku
Update redshift table column with dataiku project variable.

Answered ✓ Ankur30 2.4K views 2 comments 0 points Most recent by Ankur30 October 2021Using Dataiku
Querying multiple db's in same query with SQLExecutor2

Question ckilduff 1.8K views 1 comment 0 points Most recent by Alexandru October 2021Using Dataiku