DDL statements when connecting to a SQL database

Siddharth1316
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
ATsao
Dataiker

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: 

https://doc.dataiku.com/dss/latest/code_recipes/sql.html#sql-script-recipe

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. 

Thanks,

Andrew

0 Kudos