writing sql
simonbrightman
Registered Posts: 1 ✭
Hi, I am trying to use sql to handle some joins. How best to do so within dataiku?
Tagged:
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 NeuronWelcome 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.