.png){kind=logo}
Alter Database
-
DarkLight
Alter Database
-
DarkLight
This article is specific to the following platforms - Synapse.
Alter Database
The Alter Database component empowers users to scale up and scale down the compute resources allocated to an operation to better control performance and cost of operations.
Users can "scale out" for better performance, or "scale back" to save costs. To learn more, read Manage compute in Azure Synapse Analytics data warehouse.
Users must have the following permissions to perform scaling:
Microsoft.Sql/servers/readMicrosoft.Sql/servers/writeMicrosoft.Sql/servers/databases/readMicrosoft.Sql/servers/databases/write
Users must also ensure that they are connected to the database they wish to scale—users can confirm this in the Matillion ETL Edit Environment wizard.
Properties
Synapse Properties | ||
|---|---|---|
| Property | Setting | Description |
| Name | String | A human-readable name for the component. |
| Operation | Select | Select the alteration operation. Currently the only available operation is Scale. |
| Service Objective | Select | Select the desired compute resource allocation to scale up or scale down to. To learn more, read Data Warehouse Units. If the database has a cap allocated to it, Matillion ETL will fail and provide an error message if users try to scale out to an allocation higher than the cap. |