vw_files_no_subscriptions
Creates, updates, deletes, gets or lists a vw_files_no_subscriptions resource.
Overview
| Name | vw_files_no_subscriptions |
| Type | View |
| Id | azure.support.vw_files_no_subscriptions |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
JSON_EXTRACT(properties, '$.createdOn') as "created_on",
JSON_EXTRACT(properties, '$.chunkSize') as "chunk_size",
JSON_EXTRACT(properties, '$.fileSize') as "file_size",
JSON_EXTRACT(properties, '$.numberOfChunks') as "number_of_chunks",
fileWorkspaceName,
fileName
FROM azure.support.files_no_subscriptions
WHERE fileWorkspaceName = 'replace-me';
SELECT
json_extract_path_text(properties, '$.createdOn') as "created_on",
json_extract_path_text(properties, '$.chunkSize') as "chunk_size",
json_extract_path_text(properties, '$.fileSize') as "file_size",
json_extract_path_text(properties, '$.numberOfChunks') as "number_of_chunks",
fileWorkspaceName,
fileName
FROM azure.support.files_no_subscriptions
WHERE fileWorkspaceName = 'replace-me';