Using Microsoft Azure Synapse Analytics as a data warehouse
This section describes how to set up Microsoft Azure Synapse Analytics as a data warehouse in a Compose project.
Information note
By default, Compose creates tables in Microsoft Azure Synapse Analytics as a CLUSTERED COLUMNSTORE INDEX, which offers the best overall query performance for large tables. Depending on your environment though, you might want to override the default to create all tables or specific tables as a HEAP, for example, which is optimized for smaller tables. For information on how to accomplish this, see Table creation modifiers tab in the Project Settings section.
It contains the following topics: