files_no_subscriptions

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

Overview

Name	files_no_subscriptions
Type	Resource
Id	azure.support.files_no_subscriptions

Fields

vw_files_no_subscriptions

Name	Datatype	Description
chunk_size	text	field from the properties object
created_on	text	field from the properties object
fileName	text	field from the properties object
fileWorkspaceName	text	field from the properties object
file_size	text	field from the properties object
number_of_chunks	text	field from the properties object

files_no_subscriptions

Name	Datatype	Description
properties	object	Describes the properties of a file.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	fileName, fileWorkspaceName	Returns details of a specific file in a work space.
list	SELECT	fileWorkspaceName	Lists all the Files information under a workspace for an Azure subscription.
create	INSERT	fileName, fileWorkspaceName	Creates a new file under a workspace.
upload	EXEC	fileName, fileWorkspaceName	This API allows you to upload content to a file

SELECT examples

Lists all the Files information under a workspace for an Azure subscription.

vw_files_no_subscriptions

SELECT
chunk_size,
created_on,
fileName,
fileWorkspaceName,
file_size,
number_of_chunks
FROM azure.support.vw_files_no_subscriptions
WHERE fileWorkspaceName = '{{ fileWorkspaceName }}';

files_no_subscriptions

SELECT
properties
FROM azure.support.files_no_subscriptions
WHERE fileWorkspaceName = '{{ fileWorkspaceName }}';

INSERT example

Use the following StackQL query and manifest file to create a new files_no_subscriptions resource.

All Properties

/*+ create */
INSERT INTO azure.support.files_no_subscriptions (
fileName,
fileWorkspaceName,
properties
)
SELECT 
'{{ fileName }}',
'{{ fileWorkspaceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: createdOn
          value: string
        - name: chunkSize
          value: integer
        - name: fileSize
          value: integer
        - name: numberOfChunks
          value: integer