vw_resources
Creates, updates, deletes, gets or lists a vw_resources resource.
Overview
| Name | vw_resources |
| Type | View |
| Id | azure.iot_hub.vw_resources |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
id as id,
name as name,
location as location,
etag as etag,
sku as sku,
identity as identity,
systemData as system_data,
type as type,
tags as tags,
JSON_EXTRACT(properties, '$.authorizationPolicies') as "authorization_policies",
JSON_EXTRACT(properties, '$.disableLocalAuth') as "disable_local_auth",
JSON_EXTRACT(properties, '$.disableDeviceSAS') as "disable_device_sas",
JSON_EXTRACT(properties, '$.disableModuleSAS') as "disable_module_sas",
JSON_EXTRACT(properties, '$.restrictOutboundNetworkAccess') as "restrict_outbound_network_access",
JSON_EXTRACT(properties, '$.allowedFqdnList') as "allowed_fqdn_list",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.ipFilterRules') as "ip_filter_rules",
JSON_EXTRACT(properties, '$.networkRuleSets') as "network_rule_sets",
JSON_EXTRACT(properties, '$.minTlsVersion') as "min_tls_version",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.hostName') as "host_name",
JSON_EXTRACT(properties, '$.eventHubEndpoints') as "event_hub_endpoints",
JSON_EXTRACT(properties, '$.routing') as "routing",
JSON_EXTRACT(properties, '$.storageEndpoints') as "storage_endpoints",
JSON_EXTRACT(properties, '$.messagingEndpoints') as "messaging_endpoints",
JSON_EXTRACT(properties, '$.enableFileUploadNotifications') as "enable_file_upload_notifications",
JSON_EXTRACT(properties, '$.cloudToDevice') as "cloud_to_device",
JSON_EXTRACT(properties, '$.comments') as "comments",
JSON_EXTRACT(properties, '$.features') as "features",
JSON_EXTRACT(properties, '$.locations') as "locations",
JSON_EXTRACT(properties, '$.enableDataResidency') as "enable_data_residency",
subscriptionId,
resourceGroupName,
resourceName
FROM azure.iot_hub.resources
WHERE subscriptionId = 'replace-me';
SELECT
id as id,
name as name,
location as location,
etag as etag,
sku as sku,
identity as identity,
systemData as system_data,
type as type,
tags as tags,
json_extract_path_text(properties, '$.authorizationPolicies') as "authorization_policies",
json_extract_path_text(properties, '$.disableLocalAuth') as "disable_local_auth",
json_extract_path_text(properties, '$.disableDeviceSAS') as "disable_device_sas",
json_extract_path_text(properties, '$.disableModuleSAS') as "disable_module_sas",
json_extract_path_text(properties, '$.restrictOutboundNetworkAccess') as "restrict_outbound_network_access",
json_extract_path_text(properties, '$.allowedFqdnList') as "allowed_fqdn_list",
json_extract_path_text(properties, '$.publicNetworkAccess') as "public_network_access",
json_extract_path_text(properties, '$.ipFilterRules') as "ip_filter_rules",
json_extract_path_text(properties, '$.networkRuleSets') as "network_rule_sets",
json_extract_path_text(properties, '$.minTlsVersion') as "min_tls_version",
json_extract_path_text(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.state') as "state",
json_extract_path_text(properties, '$.hostName') as "host_name",
json_extract_path_text(properties, '$.eventHubEndpoints') as "event_hub_endpoints",
json_extract_path_text(properties, '$.routing') as "routing",
json_extract_path_text(properties, '$.storageEndpoints') as "storage_endpoints",
json_extract_path_text(properties, '$.messagingEndpoints') as "messaging_endpoints",
json_extract_path_text(properties, '$.enableFileUploadNotifications') as "enable_file_upload_notifications",
json_extract_path_text(properties, '$.cloudToDevice') as "cloud_to_device",
json_extract_path_text(properties, '$.comments') as "comments",
json_extract_path_text(properties, '$.features') as "features",
json_extract_path_text(properties, '$.locations') as "locations",
json_extract_path_text(properties, '$.enableDataResidency') as "enable_data_residency",
subscriptionId,
resourceGroupName,
resourceName
FROM azure.iot_hub.resources
WHERE subscriptionId = 'replace-me';