APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
Partitions divide a table into logical parts. Each partition can then be processed (Refreshed) independent of other partitions. Partitions defined for a model during model authoring are duplicated in a deployed model. Once deployed, you can manage those partitions by using the Partitions dialog box in SQL Server Management Studio or by using a script. Tasks provided in this topic describe how to create and manage partitions for a deployed model.
Partitions in Tabular models created at the 1400 compatibility level are defined using an M query statement. To learn more, see M Reference.
To create and manage partitions for a deployed tabular model database, you will use the Partitions dialog box in SQL Server Management Studio. To view the Partitions dialog box, in SQL Server Management Studio, right-click on a table, and then click Partitions.
In the Partitions dialog box, click the New button.
In Partition Name, type a name for the partition. By default, the name of the default partition will be incrementally numbered for each new partition.
In Query Statement, type or paste a SQL or M query statement that defines the columns and any clauses you want to include in the partition into the query window.
To validate the statement, click Check Syntax.
In the Partitions dialog box, in the Partitions list, select the partition you want to copy, and then click the Copy button.
In Partition Name, type a new name for the partition.
In Query Statement, edit the query statement.
- In the Partitions dialog box, in the Partitions list, use Ctrl+click to select the partitions you want to merge, and then click the Merge button.
Merging partitions does not update the partition metadata. You must edit the SQL or M statement for the resulting partition to make sure processing operations process all data in the merged partition.
- In the Partitions dialog box, in the Partitions list, select the partition you want to delete, and then click the Delete button.