Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Partitioned datasets with a SQL Server backing store

Level 3
Partitioned datasets with a SQL Server backing store


We're currently on DSS 8.03 and use SQL Server as our backing store.

We have some flows that would benefit from partitioning, but when I create a partitioned dataset, it appears in DSS as a partitioned table, allows me to run jobs as partitioned and all appears to be fine from the front end. However, the backend SQL Server table appears to be a normal, unpartitioned table. Is there an extra setting that needs to be enabled to create partitioned tables on SQL Server via DSS?

0 Kudos
1 Reply


DSS datasets can only be backed by a single table. There is no way to dispatch across multiple smaller tables via DSS partitioning.

SQL Server may have the ability to have a virtual table over several partitioned table (I think it may be done on the database directly via filegroups), but that would be done outside of DSS.

0 Kudos