Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

DDL statements when connecting to a SQL database

Level 2
DDL statements when connecting to a SQL database

Hi team - Is it possible to write DDL/DML statements like CREATE table when I am connecting to a database like Teradata/Snowflake? For e.g. let's say I connect to a Snowflake database on DSS and instead of writing a select query I write Create table XYZ as (select * from ABC). Will this work? Or would I have to explicitly write to the database using a SQL code recipe or Sync recipe?

0 Kudos
1 Reply

Hi Siddharth1316, 

This use case would indeed probably be best handled through SQL script recipes, which you can read more about in our documentation here:

Alternatively, you could look to execute these queries using a SQL notebook as well if they are one-time actions that you are looking to perform. 



0 Kudos