SQL databases

Discussion List

• 
  Dss failed to read from table (Column "X" does not exist)

  Answered ✓ Romain_L 3.9K views 4 comments 0 points Most recent by Romain_L August 2021Using Dataiku
• 
  Application-as-recipes and SQL scripts reusable for different connections

  Answered ✓ pvannies 3.7K views 2 comments 1 point Most recent by CoreyS April 2021Using Dataiku
• 
  Accessing Partition of Dataset in Python Recipe

  Question DV 5.5K views 2 comments 0 points Most recent by carlhyde April 2021Using Dataiku
• 
  Run a complexe SQL "script" to create tables in Bigquery (GCP)

  Answered ✓ aurelien_b 4.6K views 3 comments 0 points Most recent by aurelien_b March 2021Using Dataiku
• 
  Validation failed: Query failed: ERROR: function pg_catalog.date_part(unknown, text) does not exist

  Answered ✓ Herve 12.3K views 3 comments 0 points Most recent by Herve March 2021Academy Discussions
• 
  Scenario triggered by an external change

  Answered ✓ davidmakovoz 7.9K views 7 comments 0 points Most recent by Jediv February 2021Using Dataiku
• 
  NumberFormatException: Trailing junk on timestamp: ':21' with pgsql

  Answered ✓ jtobelem 8K views 2 comments 0 points Most recent by jtobelem February 2021Using Dataiku
• 
  Writing df on chunks with buillt in Dataiku functionality

  Answered ✓ PapaA 5.8K views 3 comments 0 points Most recent by HenriC January 2021Using Dataiku
• 
  Perform routine cleanup on Kerberos logins cache

  Question MRvLuijpen 2.2K views 1 comment 0 points Most recent by Clément_Stenac December 2020Using Dataiku
• 
  Update SQL table

  Answered ✓ davidmakovoz 6.7K views 4 comments 0 points Most recent by davidmakovoz October 2020Using Dataiku
• 
  FilterOnDateRange to SQL

  Answered ✓ davidmakovoz 3.2K views 3 comments 0 points Most recent by davidmakovoz October 2020Using Dataiku
• 
  Distinct recipe running in-database

  Answered ✓ davidmakovoz 4.2K views 2 comments 0 points Most recent by GCase October 2020Using Dataiku
• 
  Retry (a) failed partition(s)

  Question casper 2.8K views 1 comment 0 points Most recent by Clément_Stenac September 2020Using Dataiku
• 
  Database

  Answered ✓ swapnilnavale63 4.1K views 3 comments 0 points Most recent by swapnilnavale63 July 2020Using Dataiku
• 
  Oracle connection error ORA-12505

  Question Meryem_dss 10.1K views 6 comments 0 points Most recent by Andrey July 2020Using Dataiku
• 
  Variable and Post-Write Statements in PostgreSQL Dataset

  Answered ✓ Ben69 3.2K views 1 comment 0 points Most recent by Andrey June 2020Using Dataiku
• 
  How to capture Dataiku job details and insert in a control table in Redshift

  Question rsingamsetty 4.3K views 3 comments 0 points Most recent by Liev June 2020Using Dataiku
• 
  now() formula in prepare recipe not translatable on SQL engine

  Answered ✓ rsingamsetty 5.5K views 4 comments 1 point Most recent by CoreyS May 2020Using Dataiku
• 
  Reading varbinary from SQL Server into Python

  Answered ✓ Taylor 8.7K views 2 comments 1 point Most recent by Taylor May 2020Using Dataiku
• 
  API works in API node but not in Deployer

  Question Oscar 7.3K views 9 comments 1 point Most recent by Oscar April 2020Using Dataiku
• 
  Setting project variables from SQL output

  Answered ✓ Bader 3.4K views 1 comment 1 point Most recent by Alex_Combessie April 2020Using Dataiku
• 
  Sync Data - Delat load Automation

  Answered ✓ Bader 11.1K views 13 comments 0 points Most recent by Alex_Combessie March 2020Using Dataiku
• 
  How to enable SQL pipelines in the flow

  Dataiku 806 views 0 comments 2 points Most recent by Dataiku March 2020Knowledge Base
• 
  How Dataiku DSS Handles and Displays Date & Time

  AdrienL 1K views 0 comments 4 points Most recent by AdrienL February 2020Knowledge Base
• 
  Mysql left-outer join not working via DSS (but working in MySQL workbench)

  Question stanislas 3K views 1 comment 0 points Most recent by bencoffey February 2020Using Dataiku