Microsoft Azure

Azure Synapse Analytics: Sql Pool

Azure Synapse Analytics APIs

Data & analytics#openapi

Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.

Overview

Azure Synapse Analytics APIs

Endpoints 75

SqlPools

  • GETGet SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolNameGet SQL pool properties
  • PUTCreate SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolNameCreate a SQL pool
  • DELETEDelete SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolNameDelete a SQL pool
  • PATCHUpdate SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolNameApply a partial update to a SQL pool
  • GETList SQL pools/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPoolsList all SQL pools
  • POSTPause SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/pausePause a SQL pool
  • POSTResume SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/resumeResume a SQL pool

Operations

  • GETGet SQL pool operation status/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/operationResults/:operationIdGet the status of a SQL pool operation

SqlPools, GeoBackupPolicies

  • GETList SQL pool geo backup policies/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/geoBackupPoliciesGet list of SQL pool geo backup policies
  • GETGet a SQL pool geo backup policy/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/geoBackupPolicies/:geoBackupPolicyNameGet the specified SQL pool geo backup policy
  • PUTSqlPoolGeoBackupPolicies_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/geoBackupPolicies/:geoBackupPolicyNameUpdates a SQL Pool geo backup policy.

SqlPools, SqlPoolUserActivities

  • GETGet SQL pool user activities/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/dataWarehouseUserActivities/:dataWarehouseUserActivityNameGets the user activities of a SQL pool which includes running and suspended queries

SqlPools, Backup

  • GETGet SQL pool backup/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/restorePointsGet SQL pool backup information

SqlPools, RestorePoints

  • POSTSqlPoolRestorePoints_Create/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/restorePointsCreates a restore point for a data warehouse.
  • GETSqlPoolRestorePoints_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/restorePoints/:restorePointNameGets a restore point.
  • DELETESqlPoolRestorePoints_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/restorePoints/:restorePointNameDeletes a restore point.

SqlPools, ReplicationLinks

  • GETGet SQL pool replication links/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/replicationLinksLists a Sql pool's replication links.
  • GETGet SQL pool replication link by name/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/replicationLinks/:linkIdGet SQL pool replication link by name.

SqlPools, MaintenanceWindows

  • GETGet a SQL pool's Maintenance Windows./subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/maintenancewindows/current?maintenanceWindowName=stringGet a SQL pool's Maintenance Windows.
  • PUTCreates or updates a Sql pool's maintenance windows settings./subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/maintenancewindows/current?maintenanceWindowName=stringCreates or updates a Sql pool's maintenance windows settings.

SqlPools, MaintenanceWindowOptions

  • GETSQL pool's available maintenance windows./subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/maintenanceWindowOptions/current?maintenanceWindowOptionsName=stringGet list of SQL pool's available maintenance windows.

SqlPools, TransparentDataEncryption

  • GETGet a SQL pool's transparent data encryption configuration/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/transparentDataEncryption/:transparentDataEncryptionNameGet a SQL pool's transparent data encryption configuration.
  • PUTCreates or updates a Sql pool's transparent data encryption configuration/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/transparentDataEncryption/:transparentDataEncryptionNameCreates or updates a Sql pool's transparent data encryption configuration.
  • GETSQL pool's transparent data encryption configurations/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/transparentDataEncryptionGet list of SQL pool's transparent data encryption configurations.

SqlPools, BlobAuditing

  • GETGet a SQL pool's blob auditing policy/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/auditingSettings/:blobAuditingPolicyNameGet a SQL pool's blob auditing policy.
  • PUTCreates or updates a SQL pool's blob auditing policy/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/auditingSettings/:blobAuditingPolicyNameCreates or updates a SQL pool's blob auditing policy.
  • GETExtendedSqlPoolBlobAuditingPolicies_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/extendedAuditingSettings/:blobAuditingPolicyNameGets an extended Sql pool's blob auditing policy.
  • PUTExtendedSqlPoolBlobAuditingPolicies_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/extendedAuditingSettings/:blobAuditingPolicyNameCreates or updates an extended Sql pool's blob auditing policy.
  • GETSqlPoolBlobAuditingPolicies_ListBySqlPool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/auditingSettingsLists auditing settings of a Sql pool.

SqlPools, Operations

  • GETGets a list of operations performed on the SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/operationsGets a list of operations performed on the SQL pool.

SqlPools, Usages

  • GETGets SQL pool usages/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/usagesGets SQL pool usages.

SqlPools, SensitivityLabels

  • GETGets SQL pool sensitivity labels/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/currentSensitivityLabels?$filter=stringGets SQL pool sensitivity labels.
  • PATCHSqlPoolSensitivityLabels_Update/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/currentSensitivityLabelsUpdate sensitivity labels of a given SQL Pool using an operations batch.
  • GETGets sensitivity labels of a given SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/recommendedSensitivityLabels?includeDisabledRecommendations=true&$skipToken=string&$filter=stringGets sensitivity labels of a given SQL pool.
  • PATCHSqlPoolRecommendedSensitivityLabels_Update/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/recommendedSensitivityLabelsUpdate recommended sensitivity labels states of a given SQL Pool using an operations batch.
  • GETSqlPoolSensitivityLabels_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableName/columns/:columnName/sensitivityLabels/:sensitivityLabelSourceGets the sensitivity label of a given column
  • PUTSqlPoolSensitivityLabels_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableName/columns/:columnName/sensitivityLabels/:sensitivityLabelSourceCreates or updates the sensitivity label of a given column in a Sql pool
  • DELETESqlPoolSensitivityLabels_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableName/columns/:columnName/sensitivityLabels/:sensitivityLabelSourceDeletes the sensitivity label of a given column in a Sql pool

SensitivityLabels

  • POSTSqlPoolSensitivityLabels_EnableRecommendation/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableName/columns/:columnName/sensitivityLabels/:sensitivityLabelSource/enableEnables sensitivity recommendations on a given column (recommendations are enabled by default on all columns)
  • POSTSqlPoolSensitivityLabels_DisableRecommendation/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableName/columns/:columnName/sensitivityLabels/:sensitivityLabelSource/disableDisables sensitivity recommendations on a given column

SqlPools, Schemas

  • GETGets schemas of a given SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas?$filter=stringGets schemas of a given SQL pool.
  • GETLists the vulnerability assessment policies associated with a SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessmentsLists the vulnerability assessment policies associated with a SQL pool.
  • GETLists the vulnerability assessment scans of a SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentName/scansLists the vulnerability assessment scans of a SQL pool.

SqlPools, Tables

  • GETGets tables of a given schema in a SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables?$filter=stringGets tables of a given schema in a SQL pool.
  • GETGets columns in a given table in a SQL pool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableName/columns?$filter=stringGets columns in a given table in a SQL pool.

SqlPools, ConnectionPolicies

  • GETGet a Sql pool's connection policy, which is used with table auditing/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/connectionPolicies/:connectionPolicyNameDeprecated. Get a Sql pool's connection policy, which is used with table auditing.

SqlPools, VulnerabilityAssessmentScansExecute

  • POSTSqlPoolVulnerabilityAssessmentScans_InitiateScan/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentName/scans/:scanId/initiateScanExecutes a Vulnerability Assessment database scan.

SqlPools, VulnerabilityAssessmentScansExport

  • POSTSqlPoolVulnerabilityAssessmentScans_Export/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentName/scans/:scanId/exportConvert an existing scan result to a human readable format. If already exists nothing happens

SqlPools, SecurityAlertPolicies

  • GETList Sql pool's security alert policies/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/securityAlertPoliciesGet a list of Sql pool's security alert policies.
  • GETGet a Sql pool's security alert policy/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/securityAlertPolicies/:securityAlertPolicyNameGet a Sql pool's security alert policy.
  • PUTCreate or update a Sql pool's security alert policy/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/securityAlertPolicies/:securityAlertPolicyNameCreate or update a Sql pool's security alert policy.

SqlPools, SqlPoolVulnerabilityAssesmentRuleBaselines

  • GETSqlPoolVulnerabilityAssessmentRuleBaselines_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentName/rules/:ruleId/baselines/:baselineNameGets a SqlPool's vulnerability assessment rule baseline.

SqlPools, DatabaseVulnerabilityAssesmentRuleBaselines

  • PUTSqlPoolVulnerabilityAssessmentRuleBaselines_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentName/rules/:ruleId/baselines/:baselineNameCreates or updates a Sql pool's vulnerability assessment rule baseline.

DatabaseVulnerabilityAssesmentRuleBaselines

  • DELETESqlPoolVulnerabilityAssessmentRuleBaselines_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentName/rules/:ruleId/baselines/:baselineNameRemoves the database's vulnerability assessment rule baseline.

SqlPools, VulnerabilityAssessments

  • GETGets the Sql pool's vulnerability assessment/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentNameGets the Sql pool's vulnerability assessment.
  • PUTCreates or updates the Sql pool vulnerability assessment/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentNameCreates or updates the Sql pool vulnerability assessment.
  • DELETERemoves the database's vulnerability assessment/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentNameRemoves the database's vulnerability assessment.

SqlPools,BlobAuditing

  • GETExtendedSqlPoolBlobAuditingPolicies_ListBySqlPool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/extendedAuditingSettingsLists extended auditing settings of a Sql pool.

SqlPools, DataMaskingPolicies

  • GETDataMaskingPolicies_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/dataMaskingPolicies/:dataMaskingPolicyNameGets a Sql pool data masking policy.
  • PUTDataMaskingPolicies_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/dataMaskingPolicies/:dataMaskingPolicyNameCreates or updates a Sql pool data masking policy

SqlPools, DataMaskingRules

  • GETDataMaskingRules_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/dataMaskingPolicies/:dataMaskingPolicyName/rules/:dataMaskingRuleNameGets the specific Sql pool data masking rule.
  • PUTDataMaskingRules_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/dataMaskingPolicies/:dataMaskingPolicyName/rules/:dataMaskingRuleNameCreates or updates a Sql pool data masking rule.
  • GETDataMaskingRules_ListBySqlPool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/dataMaskingPolicies/:dataMaskingPolicyName/rulesGets a list of Sql pool data masking rules.

SqlPools, SqlPoolSchemas

  • GETSqlPoolSchemas_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaNameGet Sql Pool schema

SqlPools, SqlPoolTables

  • GETSqlPoolTables_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableNameGet Sql pool table

SqlPools, SqlPoolColumns

  • GETSqlPoolColumns_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/schemas/:schemaName/tables/:tableName/columns/:columnNameGet Sql pool column

SqlPools,SqlPoolVulnerabilityAssessmentScans

  • GETSqlPoolVulnerabilityAssessmentScans_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/vulnerabilityAssessments/:vulnerabilityAssessmentName/scans/:scanIdGets a vulnerability assessment scan record of a Sql pool.

SqlPools, WorkloadGroups

  • GETSql pool's workload group/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroups/:workloadGroupNameGet a Sql pool's workload group.
  • PUTCreate Or Update workload group/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroups/:workloadGroupNameCreate Or Update a Sql pool's workload group.
  • DELETERemove workload group/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroups/:workloadGroupNameRemove Sql pool's workload group.
  • GETSql pool's workload groups/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroupsGet list of Sql pool's workload groups.

SqlPools, WorkloadClassifiers

  • GETGet workload classifier/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroups/:workloadGroupName/workloadClassifiers/:workloadClassifierNameGet a workload classifier of Sql pool's workload group.
  • PUTCreate Or Update workload classifier/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroups/:workloadGroupName/workloadClassifiers/:workloadClassifierNameCreate Or Update workload classifier for a Sql pool's workload group.
  • DELETERemove workload classifier/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroups/:workloadGroupName/workloadClassifiers/:workloadClassifierNameRemove workload classifier of a Sql pool's workload group.
  • GETSql pool's workload classifier/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName/workloadGroups/:workloadGroupName/workloadClassifiersGet list of Sql pool's workload classifier for workload groups.

API details

Base URL
https://management.azure.com
Authentication
OAuth 2.0 (implicit flow) with 1 scope
Operations
75 operations on 50 pathsGET 44PUT 14POST 7DELETE 7PATCH 3
1 marked deprecated
Main resources
SqlPools 7SqlPools, SensitivityLabels 7SqlPools, BlobAuditing 5SqlPools, WorkloadClassifiers 4SqlPools, WorkloadGroups 4SqlPools, DataMaskingRules 3SqlPools, GeoBackupPolicies 3SqlPools, RestorePoints 3SqlPools, Schemas 3SqlPools, SecurityAlertPolicies 3
Description format
Swagger 2.0, API version 2021-06-01

How to test the Azure Synapse Analytics: Sql Pool in Swastik Codes

  1. Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
  2. Fork it into your workspaceChoose a workspace. You get your own copy of the Azure Synapse Analytics: Sql Pool collection, without the publisher's secrets.
  3. Add your credentialsThis API uses OAuth 2.0 (implicit flow) with 1 scope. Add yours in the collection's variables or an environment; the requests already reference it.
  4. Send a requestPick an endpoint, for example “Get SQL pool” (GET /subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Synapse/workspaces/:workspaceName/sqlPools/:sqlPoolName), and press Send. Check the response, add tests and run the whole collection with the runner.

Frequently asked questions

What is the Azure Synapse Analytics: Sql Pool?

Azure Synapse Analytics APIs It is listed under Data & analytics and has 75 endpoints.

Who publishes the Azure Synapse Analytics: Sql Pool?

It is listed from Microsoft Azure's public API description (an OpenAPI document), not published by Microsoft Azure on Swastik Codes. Anyone who controls azure.com can claim the profile by adding a DNS TXT record.

What is the base URL of the Azure Synapse Analytics: Sql Pool?

Requests go to https://management.azure.com. Endpoint paths are added to this base URL.

How do I authenticate with the Azure Synapse Analytics: Sql Pool?

With OAuth 2.0 (implicit flow) with 1 scope.

How many endpoints does the Azure Synapse Analytics: Sql Pool have?

75 operations on 50 paths (44 GET, 14 PUT, 7 POST, 7 DELETE, 3 PATCH). The largest groups are SqlPools, SqlPools, SensitivityLabels, SqlPools, BlobAuditing, SqlPools, WorkloadClassifiers.

Is forking the Azure Synapse Analytics: Sql Pool free?

Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.

Suggest an API

Tell us which public API is missing. We check it, then add it here with its endpoints when it has an OpenAPI (Swagger) description.