datastores

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

Overview

Name	datastores
Type	Resource
Id	azure.ml_services.datastores

Fields

vw_datastores

Name	Datatype	Description
name	text	field from the properties object
description	text	field from the properties object
credentials	text	field from the properties object
datastore_type	text	field from the properties object
is_default	text	field from the properties object
properties	text	Base definition for datastore contents configuration.
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	field from the properties object
workspaceName	text	field from the properties object

datastores

Name	Datatype	Description
properties	object	Base definition for datastore contents configuration.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name, resourceGroupName, subscriptionId, workspaceName
list	SELECT	resourceGroupName, subscriptionId, workspaceName
create_or_update	INSERT	name, resourceGroupName, subscriptionId, workspaceName, data__properties
delete	DELETE	name, resourceGroupName, subscriptionId, workspaceName

SELECT examples

vw_datastores

SELECT
name,
description,
credentials,
datastore_type,
is_default,
properties,
resourceGroupName,
subscriptionId,
tags,
workspaceName
FROM azure.ml_services.vw_datastores
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

datastores

SELECT
properties
FROM azure.ml_services.datastores
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.ml_services.datastores (
name,
resourceGroupName,
subscriptionId,
workspaceName,
data__properties,
properties
)
SELECT 
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: description
          value: string
        - name: properties
          value: object
        - name: tags
          value: object
        - name: credentials
          value:
            - name: credentialsType
              value: []
        - name: datastoreType
          value: []
        - name: isDefault
          value: boolean

DELETE example

Deletes the specified datastores resource.

/*+ delete */
DELETE FROM azure.ml_services.datastores
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';