vw_notification_hubs

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

Overview

Name	vw_notification_hubs
Type	View
Id	azure.notification_hubs.vw_notification_hubs

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, '$.name') as "name",
JSON_EXTRACT(properties, '$.registrationTtl') as "registration_ttl",
JSON_EXTRACT(properties, '$.authorizationRules') as "authorization_rules",
JSON_EXTRACT(properties, '$.apnsCredential') as "apns_credential",
JSON_EXTRACT(properties, '$.wnsCredential') as "wns_credential",
JSON_EXTRACT(properties, '$.gcmCredential') as "gcm_credential",
JSON_EXTRACT(properties, '$.mpnsCredential') as "mpns_credential",
JSON_EXTRACT(properties, '$.admCredential') as "adm_credential",
JSON_EXTRACT(properties, '$.baiduCredential') as "baidu_credential",
JSON_EXTRACT(properties, '$.browserCredential') as "browser_credential",
JSON_EXTRACT(properties, '$.xiaomiCredential') as "xiaomi_credential",
JSON_EXTRACT(properties, '$.fcmV1Credential') as "fcm_v1_credential",
JSON_EXTRACT(properties, '$.dailyMaxActiveDevices') as "daily_max_active_devices",
subscriptionId,
resourceGroupName,
namespaceName,
notificationHubName
FROM azure.notification_hubs.notification_hubs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND namespaceName = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
sku as sku,
json_extract_path_text(properties, '$.name') as "name",
json_extract_path_text(properties, '$.registrationTtl') as "registration_ttl",
json_extract_path_text(properties, '$.authorizationRules') as "authorization_rules",
json_extract_path_text(properties, '$.apnsCredential') as "apns_credential",
json_extract_path_text(properties, '$.wnsCredential') as "wns_credential",
json_extract_path_text(properties, '$.gcmCredential') as "gcm_credential",
json_extract_path_text(properties, '$.mpnsCredential') as "mpns_credential",
json_extract_path_text(properties, '$.admCredential') as "adm_credential",
json_extract_path_text(properties, '$.baiduCredential') as "baidu_credential",
json_extract_path_text(properties, '$.browserCredential') as "browser_credential",
json_extract_path_text(properties, '$.xiaomiCredential') as "xiaomi_credential",
json_extract_path_text(properties, '$.fcmV1Credential') as "fcm_v1_credential",
json_extract_path_text(properties, '$.dailyMaxActiveDevices') as "daily_max_active_devices",
subscriptionId,
resourceGroupName,
namespaceName,
notificationHubName
FROM azure.notification_hubs.notification_hubs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND namespaceName = 'replace-me';