vw_sql_pool_operation_results_location_header_results

Creates, updates, deletes, gets or lists a vw_sql_pool_operation_results_location_header_results resource.

Overview

Name	vw_sql_pool_operation_results_location_header_results
Type	View
Id	azure.synapse.vw_sql_pool_operation_results_location_header_results

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
location as location,
tags as tags,
sku as sku,
JSON_EXTRACT(properties, '$.maxSizeBytes') as "max_size_bytes",
JSON_EXTRACT(properties, '$.collation') as "collation",
JSON_EXTRACT(properties, '$.sourceDatabaseId') as "source_database_id",
JSON_EXTRACT(properties, '$.recoverableDatabaseId') as "recoverable_database_id",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.restorePointInTime') as "restore_point_in_time",
JSON_EXTRACT(properties, '$.createMode') as "create_mode",
JSON_EXTRACT(properties, '$.creationDate') as "creation_date",
JSON_EXTRACT(properties, '$.storageAccountType') as "storage_account_type",
JSON_EXTRACT(properties, '$.sourceDatabaseDeletionDate') as "source_database_deletion_date",
subscriptionId,
resourceGroupName,
workspaceName,
sqlPoolName,
operationId
FROM azure.synapse.sql_pool_operation_results_location_header_results
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me' AND sqlPoolName = 'replace-me' AND operationId = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
sku as sku,
json_extract_path_text(properties, '$.maxSizeBytes') as "max_size_bytes",
json_extract_path_text(properties, '$.collation') as "collation",
json_extract_path_text(properties, '$.sourceDatabaseId') as "source_database_id",
json_extract_path_text(properties, '$.recoverableDatabaseId') as "recoverable_database_id",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.status') as "status",
json_extract_path_text(properties, '$.restorePointInTime') as "restore_point_in_time",
json_extract_path_text(properties, '$.createMode') as "create_mode",
json_extract_path_text(properties, '$.creationDate') as "creation_date",
json_extract_path_text(properties, '$.storageAccountType') as "storage_account_type",
json_extract_path_text(properties, '$.sourceDatabaseDeletionDate') as "source_database_deletion_date",
subscriptionId,
resourceGroupName,
workspaceName,
sqlPoolName,
operationId
FROM azure.synapse.sql_pool_operation_results_location_header_results
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me' AND sqlPoolName = 'replace-me' AND operationId = 'replace-me';