Skip to main content

vw_big_data_pools

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

Overview​

Namevw_big_data_pools
TypeView
Idazure.synapse.vw_big_data_pools

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.autoScale') as "auto_scale",
JSON_EXTRACT(properties, '$.creationDate') as "creation_date",
JSON_EXTRACT(properties, '$.autoPause') as "auto_pause",
JSON_EXTRACT(properties, '$.isComputeIsolationEnabled') as "is_compute_isolation_enabled",
JSON_EXTRACT(properties, '$.isAutotuneEnabled') as "is_autotune_enabled",
JSON_EXTRACT(properties, '$.sessionLevelPackagesEnabled') as "session_level_packages_enabled",
JSON_EXTRACT(properties, '$.cacheSize') as "cache_size",
JSON_EXTRACT(properties, '$.dynamicExecutorAllocation') as "dynamic_executor_allocation",
JSON_EXTRACT(properties, '$.sparkEventsFolder') as "spark_events_folder",
JSON_EXTRACT(properties, '$.nodeCount') as "node_count",
JSON_EXTRACT(properties, '$.libraryRequirements') as "library_requirements",
JSON_EXTRACT(properties, '$.customLibraries') as "custom_libraries",
JSON_EXTRACT(properties, '$.sparkConfigProperties') as "spark_config_properties",
JSON_EXTRACT(properties, '$.sparkVersion') as "spark_version",
JSON_EXTRACT(properties, '$.defaultSparkLogFolder') as "default_spark_log_folder",
JSON_EXTRACT(properties, '$.nodeSize') as "node_size",
JSON_EXTRACT(properties, '$.nodeSizeFamily') as "node_size_family",
JSON_EXTRACT(properties, '$.lastSucceededTimestamp') as "last_succeeded_timestamp",
subscriptionId,
resourceGroupName,
workspaceName,
bigDataPoolName
FROM azure.synapse.big_data_pools
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';