Skip to main content

data_managers

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

Overview

Namedata_managers
TypeResource
Idazure.hybrid_data_manager.data_managers

Fields

The following fields are returned by SELECT queries:

Data Manager Resource object.

NameDatatypeDescription
idstringThe Resource Id.
namestringThe Resource Name.
etagstringEtag of the Resource.
locationstringThe location of the resource. This will be one of the supported and registered Azure Geo Regions (e.g. West US, East
US, Southeast Asia, etc.). The geo region of a resource cannot be changed once it is created, but if an identical geo
region is specified on update the request will succeed.
skuobjectThe sku type.
tagsobjectThe list of key value pairs that describe the resource. These tags can be used in viewing and grouping this resource
(across resource groups).
typestringThe Resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, dataManagerNameGets information about the specified data manager resource.
list_by_resource_groupselectsubscriptionId, resourceGroupNameLists all the data manager resources available under the given resource group.
listselectsubscriptionIdLists all the data manager resources available under the subscription.
createinsertsubscriptionId, resourceGroupName, dataManagerNameCreates a new data manager resource with the specified parameters. Existing resources cannot be updated with this API
and should instead be updated with the Update data manager resource API.
updateupdatesubscriptionId, resourceGroupName, dataManagerNameIf-MatchUpdates the properties of an existing data manager resource.
deletedeletesubscriptionId, resourceGroupName, dataManagerNameDeletes a data manager resource in Microsoft Azure.

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
resourceGroupNamestringThe Resource Group Name
subscriptionIdstringThe Subscription Id
If-MatchstringDefines the If-Match condition. The patch will be performed only if the ETag of the data manager resource on the server matches this value.

SELECT examples

Gets information about the specified data manager resource.

SELECT
id,
name,
etag,
location,
sku,
tags,
type
FROM azure.hybrid_data_manager.data_managers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND dataManagerName = '{{ dataManagerName }}' -- required
;

INSERT examples

Creates a new data manager resource with the specified parameters. Existing resources cannot be updated with this API
and should instead be updated with the Update data manager resource API.

INSERT INTO azure.hybrid_data_manager.data_managers (
data__location,
data__tags,
data__sku,
data__etag,
subscriptionId,
resourceGroupName,
dataManagerName
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ sku }}',
'{{ etag }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ dataManagerName }}'
RETURNING
id,
name,
etag,
location,
sku,
tags,
type
;

UPDATE examples

Updates the properties of an existing data manager resource.

UPDATE azure.hybrid_data_manager.data_managers
SET
data__sku = '{{ sku }}',
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND dataManagerName = '{{ dataManagerName }}' --required
AND If-Match = '{{ If-Match}}'
RETURNING
id,
name,
etag,
location,
sku,
tags,
type;

DELETE examples

Deletes a data manager resource in Microsoft Azure.

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