STORAGE.COLUMN_STORE

Target database: Azure SQL Database, Azure Synapse SQL

STORAGE.COLUMN_STORE enables/disables columnstore indexes on Azure SQL Database and on Azure Synapse SQL.

See also:

• Columnstore indexes: Overview (Microsoft documentation)

Usage

STORAGE.COLUMN_STORE: Boolean

Default: false

Notes

Columnstore can be enabled for tables in Azure SQL Database.

With Azure Synapse SQL, leaving this physical option unset results in a columnstore table which is the default. To create a heap table, explicitly set STORAGE.COLUMN_STORE to false (example below). See Azure Synapse documentation for more information on indexing tables.

Examples

Azure SQL Database: Enabling columnstore indexes

Option set to true:

STORAGE.COLUMN_STORE: true

DDL generated by Agile Data Engine:

CREATE TABLE ... (
    ...
    INDEX ... CLUSTERED COLUMNSTORE
);

Azure Synapse SQL: Creating a heap table

Option set to false:

STORAGE.COLUMN_STORE: false

DDL generated by Agile Data Engine:

CREATE TABLE ... (
    ...
)
WITH (HEAP);