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?
Answers
-
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