writing sql

[simonbrightman]

Hi, I am trying to use sql to handle some joins. How best to do so within dataiku?

[tgb417]

@simonbrightman ,

Welcome to the Dataiku Community.

Most of the visual recipes can write SQL under the hood.  The visual recipies use a SQL connection:

• Here is a quick bit about setting up Dataiku Connections.  These can be very helpful in hiding a bunch of details about your database.  https://academy.dataiku.com/integration-with-sql-databases-1 

However, if you would like to do it yourself. There are a number of ways.   

• Here is a link to some further training materials from the Dataiku Academy https://academy.dataiku.com/dataiku-dss-sql-1 
  • This shows both SQL Visual Recipies
  • as well as Doing SQL Code recipes.
• Here is the Documentation https://doc.dataiku.com/dss/latest/code_recipes/sql.html

Hope this helps a bit.  I find using DSS with SQL to be quite easy and flexable.