vw_file_shares

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

Overview

Name	vw_file_shares
Type	View
Id	azure.storage.vw_file_shares

Fields

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

SQL Definition

Sqlite3

SELECT
etag as etag,
JSON_EXTRACT(properties, '$.lastModifiedTime') as "last_modified_time",
JSON_EXTRACT(properties, '$.metadata') as "metadata",
JSON_EXTRACT(properties, '$.shareQuota') as "share_quota",
JSON_EXTRACT(properties, '$.enabledProtocols') as "enabled_protocols",
JSON_EXTRACT(properties, '$.rootSquash') as "root_squash",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.deleted') as "deleted",
JSON_EXTRACT(properties, '$.deletedTime') as "deleted_time",
JSON_EXTRACT(properties, '$.remainingRetentionDays') as "remaining_retention_days",
JSON_EXTRACT(properties, '$.accessTier') as "access_tier",
JSON_EXTRACT(properties, '$.accessTierChangeTime') as "access_tier_change_time",
JSON_EXTRACT(properties, '$.accessTierStatus') as "access_tier_status",
JSON_EXTRACT(properties, '$.shareUsageBytes') as "share_usage_bytes",
JSON_EXTRACT(properties, '$.leaseStatus') as "lease_status",
JSON_EXTRACT(properties, '$.leaseState') as "lease_state",
JSON_EXTRACT(properties, '$.leaseDuration') as "lease_duration",
JSON_EXTRACT(properties, '$.signedIdentifiers') as "signed_identifiers",
JSON_EXTRACT(properties, '$.snapshotTime') as "snapshot_time",
subscriptionId,
resourceGroupName,
accountName,
shareName
FROM azure.storage.file_shares
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND accountName = 'replace-me';

Postgres

SELECT
etag as etag,
json_extract_path_text(properties, '$.lastModifiedTime') as "last_modified_time",
json_extract_path_text(properties, '$.metadata') as "metadata",
json_extract_path_text(properties, '$.shareQuota') as "share_quota",
json_extract_path_text(properties, '$.enabledProtocols') as "enabled_protocols",
json_extract_path_text(properties, '$.rootSquash') as "root_squash",
json_extract_path_text(properties, '$.version') as "version",
json_extract_path_text(properties, '$.deleted') as "deleted",
json_extract_path_text(properties, '$.deletedTime') as "deleted_time",
json_extract_path_text(properties, '$.remainingRetentionDays') as "remaining_retention_days",
json_extract_path_text(properties, '$.accessTier') as "access_tier",
json_extract_path_text(properties, '$.accessTierChangeTime') as "access_tier_change_time",
json_extract_path_text(properties, '$.accessTierStatus') as "access_tier_status",
json_extract_path_text(properties, '$.shareUsageBytes') as "share_usage_bytes",
json_extract_path_text(properties, '$.leaseStatus') as "lease_status",
json_extract_path_text(properties, '$.leaseState') as "lease_state",
json_extract_path_text(properties, '$.leaseDuration') as "lease_duration",
json_extract_path_text(properties, '$.signedIdentifiers') as "signed_identifiers",
json_extract_path_text(properties, '$.snapshotTime') as "snapshot_time",
subscriptionId,
resourceGroupName,
accountName,
shareName
FROM azure.storage.file_shares
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND accountName = 'replace-me';