Create a SQL table in POSTGRES SQL database

Solved!
ssuhas76
Level 3
Create a SQL table in POSTGRES SQL database

Hello Everyone,

Can i get help on how to create a table in a exisitng SQL database in Dataiku?

0 Kudos
1 Solution
anino
Dataiker

Hello,

You can create SQL-managed datasets from SQL "query" recipes and DSS automatically creates the underlying database table; if you use an SQL "script" recipe, you should handle table creation/drop within your SQL statement.

In case you don't want to create DSS datasets, you can also run an SQL notebook and interact directly with your Database using SQL statements.

 

Technical Support Engineer

View solution in original post

1 Reply
anino
Dataiker

Hello,

You can create SQL-managed datasets from SQL "query" recipes and DSS automatically creates the underlying database table; if you use an SQL "script" recipe, you should handle table creation/drop within your SQL statement.

In case you don't want to create DSS datasets, you can also run an SQL notebook and interact directly with your Database using SQL statements.

 

Technical Support Engineer

Labels

?
Labels (1)
A banner prompting to get Dataiku