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

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. | | sku | object | The sku type. | | tags | object | The list of key value pairs that describe the resource. These tags can be used in viewing and grouping this resource (across resource groups). | | type | string | The Resource type. |

Methods

NameAccessible byRequired ParamsDescription
getSELECTdataManagerName, resourceGroupName, subscriptionIdGets information about the specified data manager resource.
listSELECTsubscriptionIdLists all the data manager resources available under the subscription.
list_by_resource_groupSELECTresourceGroupName, subscriptionIdLists all the data manager resources available under the given resource group.
createINSERTdataManagerName, resourceGroupName, subscriptionIdCreates 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.
deleteDELETEdataManagerName, resourceGroupName, subscriptionIdDeletes a data manager resource in Microsoft Azure.
updateUPDATEdataManagerName, resourceGroupName, subscriptionIdUpdates the properties of an existing data manager resource.

SELECT examples

Lists all the data manager resources available under the subscription.

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

INSERT example

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

/*+ create */
INSERT INTO azure.hybrid_data_manager.data_managers (
dataManagerName,
resourceGroupName,
subscriptionId,
location,
tags,
sku,
etag
)
SELECT
'{{ dataManagerName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ tags }}',
'{{ sku }}',
'{{ etag }}'
;

UPDATE example

Updates a data_managers resource.

/*+ update */
UPDATE azure.hybrid_data_manager.data_managers
SET
sku = '{{ sku }}',
tags = '{{ tags }}'
WHERE
dataManagerName = '{{ dataManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified data_managers resource.

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