# Azure Synapse Analytics Databases API **Canonical:** https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-databases-api/ **Provider:** Azure Synapse Analytics — https://apis.io/providers/microsoft-azure-synapse-analytics/ **Base URL:** https://management.azure.com **Documentation:** https://learn.microsoft.com/en-us/rest/api/synapse/ Azure Synapse Analytics Databases API is one of 78 APIs that [Azure Synapse Analytics](https://apis.io/providers/microsoft-azure-synapse-analytics/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. This API exposes 6 JSON Schema definitions. Tagged areas include Database. The published artifact set on APIs.io includes an OpenAPI specification, a JSON-LD context, API documentation, and 6 JSON Schemas. The Databases API from Azure Synapse Analytics — 13 operation(s) for databases. ## Operations (19) | Method | Path | Summary | |---|---|---| | POST | `/databases/ExecuteChange` | Batch execution of DDL Payload | | POST | `/databases/ExecuteChangeWithValidation` | Batch execution of DDL Payload | | GET | `/databases` | Get all databases in a workspace | | GET | `/databases/{databaseName}/{artifactType}s` | List all Artifacts of a type in a database | | GET | `/databases/{databaseName}/schemas/{schemaName}/{artifactType}s` | List all artifacts in schema by type | | GET | `/databases/{databaseName}/tables/{tableName}/partitionInfos` | List all partition information for a table | | GET | `/databases/{databaseName}/views/{viewName}/partitionInfos` | List all partition information for a view | | GET | `/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/partitionInfos` | List all partition information for table in schema | | GET | `/databases/{databaseName}/schemas/{schemaName}/views/{viewName}/partitionInfos` | List all partition information for a view in schema | | GET | `/databases/{databaseName}` | Get details about a database | | PUT | `/databases/{databaseName}` | Put a database | | DELETE | `/databases/{databaseName}` | Delete a database | | GET | `/databases/{databaseName}/{artifactType}s/{artifactName}` | Get an artifact from database | | PUT | `/databases/{databaseName}/{artifactType}s/{artifactName}` | Put an artifact in a Database | | DELETE | `/databases/{databaseName}/{artifactType}s/{artifactName}` | Delete an artifact in a Database | | GET | `/databases/{databaseName}/schemas/{schemaName}/{artifactType}s/{artifactName}` | Get an artifact from schema | | PUT | `/databases/{databaseName}/schemas/{schemaName}/{artifactType}s/{artifactName}` | Create or Update an artifact in a schema | | DELETE | `/databases/{databaseName}/schemas/{schemaName}/{artifactType}s/{artifactName}` | Delete an artifact from Schema | | GET | `/databases/operations/{operationId}` | Get the status of validation by operation Id | ## Machine-readable artifacts (33) - **OpenAPI** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/openapi/microsoft-azure-synapse-analytics-databases-api-openapi.yml - **Swagger** — https://raw.githubusercontent.com/Azure/azure-rest-api-specs/main/specification/synapse/resource-manager/Microsoft.Synapse/stable/2021-06-01/workspace.json - **JSONLD** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/json-ld/azure-synapse-analytics-context.jsonld - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/sqlpools - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/monitoring - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/role-assignments - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/notebook - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/dataset - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/linked-service - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/data-flow - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/sql-script - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/trigger - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/spark-job-definition - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/managed-private-endpoints - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/integration-runtimes - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/library - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/ip-firewall-rules - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/keys - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/private-endpoint-connections - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/private-link-hubs - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/azure-ad-only-authentications - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/spark-configuration - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/data-flow-debug-session - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/credential - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/kql-script - **Documentation** — https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/link-connection - **JSONSchema** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/json-schema/microsoft-azure-synapse-analytics-sy-msapiddlresponse-schema.json - **JSONSchema** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/json-schema/microsoft-azure-synapse-analytics-mdentity-schema.json - **JSONSchema** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/json-schema/microsoft-azure-synapse-analytics-query-artifacts-response-schema.json - **JSONSchema** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/json-schema/microsoft-azure-synapse-analytics-sy-msapiddlresponses-schema.json - **JSONSchema** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/json-schema/microsoft-azure-synapse-analytics-database-entity-schema.json - **JSONSchema** — https://artifacts.apis.io/microsoft-azure-synapse-analytics/json-schema/microsoft-azure-synapse-analytics-ddlbatch-schema.json ## Other Azure Synapse Analytics APIs (12) - [Azure Synapse Analytics BigDataPools API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-bigdatapools-api/) - [Azure Synapse Analytics IpFirewallRules API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-ipfirewallrules-api/) - [Azure Synapse Analytics Keys API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-keys-api/) - [Azure Synapse Analytics PrivateLinkHubs API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-privatelinkhubs-api/) - [Azure Synapse Analytics Workspaces API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-workspaces-api/) - [Azure Synapse Analytics Database Vulnerability Assesment Rule Baselines API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-databasevulnerabilityassesmentrulebaselines-api/) - [Azure Synapse Analytics Integration Runtime API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-integrationruntime-api/) - [Azure Synapse Analytics Libraries API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-libraries-api/) - [Azure Synapse Analytics Operations API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-operations-api/) - [Azure Synapse Analytics Private Link Hub Private Link Resources API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-privatelinkhubprivatelinkresources-api/) - [Azure Synapse Analytics Private Link Resources API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-privatelinkresources-api/) - [Azure Synapse Analytics Recoverable Sql Pools API](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-recoverablesqlpools-api/) ## Tags Database --- Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/microsoft-azure-synapse-analytics/microsoft-azure-synapse-analytics-databases-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/microsoft-azure-synapse-analytics/.