Discover the winners & finalists of the 2022 Dataiku Frontrunner Awards!READ THEIR USE CASES

From partition table to non partition table

Solved!
scholaschl
Level 2
From partition table to non partition table

Hello,
I would like to switch from a partitioned table to a non partitioned table.
Is it possible? And if yes, how to do it? 

0 Kudos
1 Solution
MiguelangelC
Dataiker

Hello,

The partitioning of SQL tables is logical rather than physical. So, to departition a database table you can simply click on the 'Deactivate Partitioning' button on the table dataset > Settings > Connections.

Take care to fix all inconsistent or outdated partition dependencies in the surrounding recipes.

More information about SQL table partitioning can be found in the help: https://doc.dataiku.com/dss/latest/partitions/sql_datasets.html

 

View solution in original post

1 Reply
MiguelangelC
Dataiker

Hello,

The partitioning of SQL tables is logical rather than physical. So, to departition a database table you can simply click on the 'Deactivate Partitioning' button on the table dataset > Settings > Connections.

Take care to fix all inconsistent or outdated partition dependencies in the surrounding recipes.

More information about SQL table partitioning can be found in the help: https://doc.dataiku.com/dss/latest/partitions/sql_datasets.html