SQL databases

Discussion List

• 
  SqlExecutor2 does not handle Snowflake ARRAY data type * Bug?

  Answered info-rchitect 2.5K views 5 comments 0 points Most recent by Tapan December 2024Using Dataiku
• 
  Window recipe not producing expected results when using DSS engine

  Question KKhatib 239 views 3 comments 0 points Most recent by Turribeach June 2024Using Dataiku
• 
  Create SQL table for Dataset using python API

  Question Dima 918 views 10 comments 1 point Most recent by Marlan June 2024Using Dataiku
• 
  remapping connections for API services

  Answered ✓ fjavanderspek 400 views 4 comments 0 points Most recent by fjavanderspek May 2024Using Dataiku
• 
  variable expansion in SQL query endpoint

  Question fjavanderspek 569 views 3 comments 0 points Most recent by Sarina April 2024Using Dataiku
• 
  Load from Oracle to Vertica

  Answered ✓ AHerrera101499 499 views 2 comments 0 points Most recent by Turribeach April 2024Using Dataiku
• 
  Using date in DataIKU

  Question Niyazi 307 views 0 comments 0 points Most recent by Niyazi April 2024Using Dataiku
• 
  DSS visual recipes defaulting to max column length with Redshift tables

  Answered ✓ veenacalambur 6.7K views 5 comments 2 points Most recent by Peter_R_Knight April 2024Using Dataiku
• 
  Monthly Partitioning changes partition column value

  Answered ✓ Gipple 1.1K views 2 comments 0 points Most recent by Gipple February 2024Using Dataiku
• 
  OAUTH authentication possibilities for Python library

  Question info-rchitect 1K views 4 comments 0 points Most recent by info-rchitect February 2024Using Dataiku
• 
  Unable to see connections while creating new snowflake dataset

  Question Rohit1703 468 views 2 comments 0 points Most recent by Rohit1703 February 2024Using Dataiku
• 
  Use a list as variable in SQL Query

  Question Sv3n-Sk4 2.5K views 2 comments 1 point Most recent by Hui Xiang January 2024Using Dataiku
• 
  Recursive query in Dataiku

  Question TranhieuTX3 377 views 1 comment 0 points Most recent by Turribeach January 2024Using Dataiku
• 
  Is there a way to tell dataiku to use TRUNCATE TABLE instead of DROP TABLE for snowflake datasets?

  Answered ✓ ecerulm 918 views 2 comments 0 points Most recent by Turribeach January 2024Using Dataiku
• 
  Trigger a flow when variables are set

  Answered ✓ MJL 2.8K views 6 comments 0 points Most recent by Turribeach December 2023Using Dataiku
• 
  Metrics Dataset using DSS Python API

  Question anastasiosv 502 views 1 comment 0 points Most recent by Turribeach November 2023Using Dataiku
• 
  How can I make an INSERT with an SQL Query recipe?

  Question ligia_tzab 1.7K views 2 comments 0 points Most recent by Marlan November 2023Using Dataiku
• 
  Using a transaction in a SQL Script recipe

  Question MJL 440 views 0 comments 0 points Most recent by MJL October 2023Using Dataiku
• 
  INSERT query from python function endpoint

  Answered ✓ ssuhas76 571 views 1 comment 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  Left join coalesce returns null values when there value

  Question ShrimpMania 2.5K views 4 comments 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  Create a SQL table in POSTGRES SQL database

  Answered ✓ ssuhas76 1.2K views 1 comment 0 points Most recent by Álvaro Andrés September 2023Using Dataiku
• 
  Generating rows and 3 months avg. value

  Answered ✓ ShrimpMania 616 views 1 comment 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  How to create Date variable for MTD, YTD, QTD..etc

  Question duripav1 1.4K views 3 comments 0 points Most recent by me2 September 2023Using Dataiku
• 
  Data transformation

  Question shahas71 1.9K views 7 comments 0 points Most recent by info-rchitect September 2023Using Dataiku
• 
  An alternative way to get around lack of Dataiku support for certain datatypes

  Question info-rchitect 504 views 0 comments 0 points Most recent by info-rchitect September 2023Using Dataiku
• 
  Unable to update Snowflake connection details using recipe variables

  Question Siddharth1316 1.4K views 2 comments 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  Dataiku and BigQuery: Limitations

  Question Turribeach 4.5K views 1 comment 3 points Most recent by alexei-ciobanu September 2023Using Dataiku
• 
  Not Authorized error only when using SQL or Python recipes

  Answered ✓ Niyazi 2.1K views 4 comments 0 points Most recent by Niyazi September 2023Using Dataiku
• 
  Root path of the dataset does not exist

  Answered ✓ jvijayakumar2 3.8K views 4 comments 0 points Most recent by jvijayakumar2 August 2023Using Dataiku
• 
  Automatically reload schema from table

  Question ZMehdi 1.1K views 1 comment 0 points Most recent by JordanB June 2023Using Dataiku