Skip to main content

data_stores

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

Overview

Namedata_stores
TypeResource
Idazure.hybrid_data_manager.data_stores

Fields

The following fields are returned by SELECT queries:

The data store/repository which matches the name given.

NameDatatypeDescription
idstringId of the object.
namestringName of the object.
propertiesobjectDataStore properties.
typestringType of the object.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdataStoreName, subscriptionId, resourceGroupName, dataManagerNameThis method gets the data store/repository by name.
list_by_data_managerselectsubscriptionId, resourceGroupName, dataManagerName$filterGets all the data stores/repositories in the given resource.
create_or_updateinsertdataStoreName, subscriptionId, resourceGroupName, dataManagerName, data__propertiesCreates or updates the data store/repository in the data manager.
deletedeletedataStoreName, subscriptionId, resourceGroupName, dataManagerNameThis method deletes the given data store/repository.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
dataManagerNamestringThe name of the DataManager Resource within the specified resource group. DataManager names must be between 3 and 24 characters in length and use any alphanumeric and underscore only
dataStoreNamestringThe data store/repository name to be deleted.
resourceGroupNamestringThe Resource Group Name
subscriptionIdstringThe Subscription Id
$filterstringOData Filter options

SELECT examples

This method gets the data store/repository by name.

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

INSERT examples

Creates or updates the data store/repository in the data manager.

INSERT INTO azure.hybrid_data_manager.data_stores (
data__properties,
dataStoreName,
subscriptionId,
resourceGroupName,
dataManagerName
)
SELECT
'{{ properties }}' /* required */,
'{{ dataStoreName }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ dataManagerName }}'
RETURNING
id,
name,
properties,
type
;

DELETE examples

This method deletes the given data store/repository.

DELETE FROM azure.hybrid_data_manager.data_stores
WHERE dataStoreName = '{{ dataStoreName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND dataManagerName = '{{ dataManagerName }}' --required
;