Synapse Workspaces Sql Pool

This table represents the synapse_workspaces_sql_pool resource from Microsoft Azure.

azure.synapse_workspaces_sql_pool

Fields

TitleIDTypeData TypeDescription
_keycorestring
collationcorestringCollation mode
create_modecorestringSpecifies 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_datecorestringDate the SQL pool was created
idcorestringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
locationcorestringThe geo-location where the resource lives
max_size_bytescoreint64Maximum size in bytes
namecorestringThe name of the resource
provisioning_statecorestringResource state
recoverable_database_idcorestringBackup database to restore from
resource_groupcorestring
restore_point_in_timecorestringSnapshot time to restore
skucorejsonSQL pool SKU
source_database_deletion_datecorestringSpecifies the time that the sql pool was deleted
source_database_idcorestringSource database to create from
statuscorestringResource status
storage_account_typecorestringThe storage account type used to store backups for this sql pool.
subscription_idcorestring
subscription_namecorestring
tagscorehstore_csv
typecorestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"