SQL databases

Discussion List

• 
  Disk-based partitioned dataset performance

  Question btsmerchandise 691 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 1.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.4K views 4 comments 0 points Most recent by Kanyenewmerch9 April 2023Using Dataiku
• 
  Tips for working with SQL Temporal tables?

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

  Question Sv3n-Sk4 819 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 918 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.4K views 7 comments 2 points Most recent by Tanguy November 2022Using Dataiku
• 
  Scenario reporter deleting table rows after schema modification

  Question BlueRabit 501 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.2K 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.2K 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 Juan Carlos 1.1K views 1 comment 0 points Most recent by Alexandru May 2022Using Dataiku
• 
  Casting id to string in join recipe

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

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

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

  Question PARTEEK 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