Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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?
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