Skip to main content

file_workspaces

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

Overview

Namefile_workspaces
TypeResource
Idazure.support.file_workspaces

Fields

NameDatatypeDescription
created_ontextfield from the properties object
expiration_timetextfield from the properties object
fileWorkspaceNametextfield from the properties object
subscriptionIdtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTfileWorkspaceName, subscriptionIdGets details for a specific file workspace in an Azure subscription.
createINSERTfileWorkspaceName, subscriptionIdCreates a new file workspace for the specified subscription.

SELECT examples

Gets details for a specific file workspace in an Azure subscription.

SELECT
created_on,
expiration_time,
fileWorkspaceName,
subscriptionId
FROM azure.support.vw_file_workspaces
WHERE fileWorkspaceName = '{{ fileWorkspaceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.support.file_workspaces (
fileWorkspaceName,
subscriptionId
)
SELECT
'{{ fileWorkspaceName }}',
'{{ subscriptionId }}'
;