Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

From partition table to non partition table

Solved!
scholaschl
Level 1
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
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
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