vw_namespaces_authorization_rules

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

Overview

Name	vw_namespaces_authorization_rules
Type	View
Id	azure.notification_hubs.vw_namespaces_authorization_rules

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.rights') as "rights",
JSON_EXTRACT(properties, '$.primaryKey') as "primary_key",
JSON_EXTRACT(properties, '$.secondaryKey') as "secondary_key",
JSON_EXTRACT(properties, '$.keyName') as "key_name",
JSON_EXTRACT(properties, '$.modifiedTime') as "modified_time",
JSON_EXTRACT(properties, '$.createdTime') as "created_time",
JSON_EXTRACT(properties, '$.claimType') as "claim_type",
JSON_EXTRACT(properties, '$.claimValue') as "claim_value",
JSON_EXTRACT(properties, '$.revision') as "revision",
subscriptionId,
resourceGroupName,
namespaceName,
authorizationRuleName
FROM azure.notification_hubs.namespaces_authorization_rules
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND namespaceName = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
json_extract_path_text(properties, '$.rights') as "rights",
json_extract_path_text(properties, '$.primaryKey') as "primary_key",
json_extract_path_text(properties, '$.secondaryKey') as "secondary_key",
json_extract_path_text(properties, '$.keyName') as "key_name",
json_extract_path_text(properties, '$.modifiedTime') as "modified_time",
json_extract_path_text(properties, '$.createdTime') as "created_time",
json_extract_path_text(properties, '$.claimType') as "claim_type",
json_extract_path_text(properties, '$.claimValue') as "claim_value",
json_extract_path_text(properties, '$.revision') as "revision",
subscriptionId,
resourceGroupName,
namespaceName,
authorizationRuleName
FROM azure.notification_hubs.namespaces_authorization_rules
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND namespaceName = 'replace-me';