DDL statements when connecting to a SQL database

Siddharth1316

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?

ATsao

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