Partitioned datasets with a SQL Server backing store

Options
allan
allan Registered Posts: 13 ✭✭✭✭

Hi

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?

Answers

  • jfyuen
    jfyuen Dataiker, Registered Posts: 12 Dataiker
    Options

    Hi,

    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.

Setup Info
    Tags
      Help me…