capabilities.work

Provision and Resume SQL Pool

A 3-step recipe with Azure Synapse Analytics. We can help you get access.

Recipe · 3 steps

Provision and Resume SQL Pool

with Azure Synapse Analytics

Create a dedicated SQL pool, resume it, and confirm its state.

  1. Provision the dedicated SQL pool within the workspace.
  2. Resume the SQL pool so its compute is brought online and ready for queries.
  3. Read the SQL pool back to capture its final provisioning state.
What you'll need to have ready
  • apiVersion: The ARM API version for SQL pools (e.g. 2021-06-01).
  • subscriptionId: The Azure subscription id.
  • resourceGroupName: The resource group containing the Synapse workspace.
  • workspaceName: The Synapse workspace name.
  • sqlPoolName: The name of the SQL pool to create.
  • sqlPool: The SqlPool resource body (location, sku, properties).
For your developer

Arazzo workflow microsoft-azure-synapse-analytics:provision-and-resume-sql-pool, 3 operations: SqlPools_Create → SqlPools_Resume → SqlPools_Get. Specs on APIs.io.

More recipes with Azure Synapse Analytics

Build Data Integration PipelineDeploy and Run PipelineDeploy and Start TriggerDeploy and Execute Spark Job DefinitionOpen Spark Session and Run StatementProvision Linked Service and DatasetProvision Spark PoolPublish and Verify NotebookPublish and Verify SQL ScriptSubmit and Poll Spark Batch Job