data_stores

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

Overview

Name	data_stores
Type	Resource
Id	azure.hybrid_data_manager.data_stores

Fields

vw_data_stores

Name	Datatype	Description
id	text	Id of the object.
name	text	Name of the object.
customer_secrets	text	field from the properties object
dataManagerName	text	field from the properties object
dataStoreName	text	field from the properties object
data_store_type_id	text	field from the properties object
extended_properties	text	field from the properties object
repository_id	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Type of the object.

data_stores

Name	Datatype	Description
id	string	Id of the object.
name	string	Name of the object.
properties	object	Data Store for sources and sinks
type	string	Type of the object.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataManagerName, dataStoreName, resourceGroupName, subscriptionId	This method gets the data store/repository by name.
list_by_data_manager	SELECT	dataManagerName, resourceGroupName, subscriptionId	Gets all the data stores/repositories in the given resource.
create_or_update	INSERT	dataManagerName, dataStoreName, resourceGroupName, subscriptionId, data__properties	Creates or updates the data store/repository in the data manager.
delete	DELETE	dataManagerName, dataStoreName, resourceGroupName, subscriptionId	This method deletes the given data store/repository.

SELECT examples

Gets all the data stores/repositories in the given resource.

vw_data_stores

SELECT
id,
name,
customer_secrets,
dataManagerName,
dataStoreName,
data_store_type_id,
extended_properties,
repository_id,
resourceGroupName,
state,
subscriptionId,
type
FROM azure.hybrid_data_manager.vw_data_stores
WHERE dataManagerName = '{{ dataManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

data_stores

SELECT
id,
name,
properties,
type
FROM azure.hybrid_data_manager.data_stores
WHERE dataManagerName = '{{ dataManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.hybrid_data_manager.data_stores (
dataManagerName,
dataStoreName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ dataManagerName }}',
'{{ dataStoreName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: id
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: repositoryId
          value: string
        - name: state
          value: string
        - name: extendedProperties
          value: object
        - name: dataStoreTypeId
          value: string
        - name: customerSecrets
          value:
            - - name: keyIdentifier
                value: string
              - name: keyValue
                value: string
              - name: algorithm
                value: string

DELETE example

Deletes the specified data_stores resource.

/*+ delete */
DELETE FROM azure.hybrid_data_manager.data_stores
WHERE dataManagerName = '{{ dataManagerName }}'
AND dataStoreName = '{{ dataStoreName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';