SQL

Discussion List

• 
  Where are SQL queries interpreted for custom recipes?

  Question UserBird 3.5K views 2 comments 0 points Most recent by UserBird August 2017Using Dataiku
• 
  Connecting to a MYSQL DB over a ssh tunnel

  Question UserBird 4.7K views 3 comments 0 points Most recent by Karmah August 2017Using Dataiku
• 
  Same table names across different projects

  Question UserBird 2.9K views 1 comment 0 points Most recent by AdrienL July 2017Using Dataiku
• 
  Trouble connecting using Teradata Aster JDBC driver

  Answered ✓ ankitmahato 6.6K views 4 comments 0 points Most recent by Clément_Stenac July 2017Using Dataiku
• 
  How can you solve in Spark SQL this case when issue?

  Question UserBird 7.3K views 1 comment 0 points Most recent by Clément_Stenac July 2017Using Dataiku
• 
  Case when with multiple cases like

  Question UserBird 9.7K views 1 comment 0 points Most recent by fchataigner2 July 2017Using Dataiku
• 
  Bigquery SIMBA driver is not capable

  Question UserBird 4K views 2 comments 0 points Most recent by arthur_aurienti June 2017Setup & Configuration
• 
  Can we use sub queries in spark sql?

  Question siddhartha_ling 5.2K views 1 comment 0 points Most recent by AdrienL June 2017Using Dataiku
• 
  Type coercion in formulas

  Answered ✓ KjellK 3.9K views 1 comment 0 points Most recent by KjellK May 2017Using Dataiku
• 
  Difference between a formula and an SQL expression.

  Answered ✓ MJLEE 3.8K views 1 comment 0 points Most recent by Clément_Stenac April 2017Using Dataiku
• 
  Linking Dataset from a Database Table in Python

  Question UserBird 2.6K views 0 comments 0 points Most recent by UserBird March 2017Using Dataiku
• 
  What is an easy way to Join Data and capture live graphs and add to dashboard during data exploratio

  Question tgb417 3.6K views 2 comments 0 points Most recent by tgb417 March 2017Using Dataiku
• 
  import Mysql dump file failed

  Question UserBird 4.7K views 2 comments 0 points Most recent by WBHHH March 2017Using Dataiku
• 
  Job fail when run a postgresql code recipe

  Answered ✓ UserBird 3.8K views 1 comment 1 point Most recent by Clément_Stenac February 2017Using Dataiku
• 
  DSS output to build a datawarehouse

  Question UserBird 3.4K views 1 comment 0 points Most recent by Clément_Stenac January 2017Using Dataiku
• 
  Heroku Postgres

  Question UserBird 3.5K views 1 comment 0 points Most recent by AdrienL December 2016Using Dataiku
• 
  SQL Update in Python Recipes

  Question UserBird 2.4K views 0 comments 0 points Most recent by UserBird November 2016Using Dataiku
• 
  A scheduled job that was running normally is now failing because of a string function

  Question UserBird 2.4K views 0 comments 0 points Most recent by UserBird October 2016Using Dataiku
• 
  Keep a column as ARRAY when synchronizing a PostgreSQL table into a dataset

  Question Benoit 4.7K views 2 comments 0 points Most recent by Benoit October 2016Using Dataiku
• 
  Connection to Presto.

  Answered ✓ UserBird 5.8K views 2 comments 1 point Most recent by bzeyben October 2016Using Dataiku
• 
  How to install mysql driver on an AWS image

  Question UserBird 3.2K views 2 comments 0 points Most recent by AdrienL September 2016Setup & Configuration
• 
  Redshift slow to write-out results

  Question UserBird 5.5K views 2 comments 1 point Most recent by gadostal September 2016Using Dataiku
• 
  PostgreSQL SSL Connection on EC2

  Answered ✓ felix 4.8K views 2 comments 0 points Most recent by felix September 2016Setup & Configuration
• 
  Oracle - create and use a "macro" variable

  Question UserBird 3.1K views 1 comment 0 points Most recent by Mattsco August 2016Using Dataiku
• 
  COnnecting to SQL server from a Docker enabled DSS

  Question UserBird 3.6K views 1 comment 0 points Most recent by UserBird July 2016Using Dataiku
• 
  How can I create a materialized view in DSS and use it in the flow ?

  Question UserBird 3.4K views 1 comment 0 points Most recent by kenjil June 2016Using Dataiku
• 
  PostgreSQL: FULL OUTER JOIN with partitioned tables

  Question UserBird 5K views 2 comments 2 points Most recent by jrouquie May 2016Using Dataiku
• 
  Full outer join

  Question Unknown 8.2K views 2 comments 0 points Most recent by Mattsco March 2016Using Dataiku
• 
  FULL OUTER join not available with MySQL datasets

  Question william 7.2K views 4 comments 0 points Most recent by william January 2016Using Dataiku
• 
  Load from HDFS to Oracle

  Question ubethke 4.6K views 3 comments 0 points Most recent by Mattsco December 2015Using Dataiku