SQL databases

Discussion List

• 
  Using date in DataIKU

  Answered Niyazi 320 views 1 comment 0 points Most recent by Alexandru July 9Using Dataiku
• 
  Sync Recipe from Redshift to Oracle RDS

  Answered SHughes_BAE 11 views 1 comment 0 points Most recent by Turribeach July 7Using Dataiku
• 
  How to execute a MS-SQL stored procedure in Dataiku

  Question Turribeach 51 views 0 comments 1 point Started by Turribeach April 11 Using Dataiku
• 
  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 247 views 3 comments 0 points Most recent by Turribeach June 2024Using Dataiku
• 
  Create SQL table for Dataset using python API

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

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

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

  Answered ✓ AHerrera101499 506 views 2 comments 0 points Most recent by Turribeach April 2024Using Dataiku
• 
  DSS visual recipes defaulting to max column length with Redshift tables

  Answered ✓ veenacalambur 6.8K 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 1.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 485 views 2 comments 0 points Most recent by Rohit1703 February 2024Using Dataiku
• 
  Use a list as variable in SQL Query

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

  Question TranhieuTX3 389 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 991 views 2 comments 0 points Most recent by Turribeach January 2024Using Dataiku
• 
  Trigger a flow when variables are set

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

  Question anastasiosv 514 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.9K views 2 comments 0 points Most recent by Marlan November 2023Using Dataiku
• 
  Using a transaction in a SQL Script recipe

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

  Answered ✓ ssuhas76 582 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 619 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.5K 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 508 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.6K 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.2K views 4 comments 0 points Most recent by Niyazi September 2023Using Dataiku