---
title: Synapse Workspaces Sql Pool
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Synapse Workspaces Sql Pool
---

# Synapse Workspaces Sql Pool

This table represents the synapse_workspaces_sql_pool resource from Microsoft Azure.

```
azure.synapse_workspaces_sql_pool
```

## Fields

| Title                         | ID   | Type       | Data Type                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Description |
| ----------------------------- | ---- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| _key                          | core | string     |
| collation                     | core | string     | Collation mode                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| create_mode                   | core | string     | Specifies the mode of sql pool creation.Default: regular sql pool creation.PointInTimeRestore: Creates a sql pool by restoring a point in time backup of an existing sql pool. sourceDatabaseId must be specified as the resource ID of the existing sql pool, and restorePointInTime must be specified.Recovery: Creates a sql pool by a geo-replicated backup. sourceDatabaseId must be specified as the recoverableDatabaseId to restore.Restore: Creates a sql pool by restoring a backup of a deleted sql pool. SourceDatabaseId should be the sql pool's original resource ID. SourceDatabaseId and sourceDatabaseDeletionDate must be specified. |
| creation_date                 | core | string     | Date the SQL pool was created                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| id                            | core | string     | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| location                      | core | string     | The geo-location where the resource lives                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| max_size_bytes                | core | int64      | Maximum size in bytes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| name                          | core | string     | The name of the resource                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| provisioning_state            | core | string     | Resource state                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| recoverable_database_id       | core | string     | Backup database to restore from                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| resource_group                | core | string     |
| restore_point_in_time         | core | string     | Snapshot time to restore                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| sku                           | core | json       | SQL pool SKU                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| source_database_deletion_date | core | string     | Specifies the time that the sql pool was deleted                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| source_database_id            | core | string     | Source database to create from                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| status                        | core | string     | Resource status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| storage_account_type          | core | string     | The storage account type used to store backups for this sql pool.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| subscription_id               | core | string     |
| subscription_name             | core | string     |
| tags                          | core | hstore_csv |
| type                          | core | string     | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |