Skip to main content

adc_catalogs

Creates, updates, deletes, gets or lists an adc_catalogs resource.

Overview

Nameadc_catalogs
TypeResource
Idazure.data_catalog.adc_catalogs

Fields

The following fields are returned by SELECT queries:

HTTP 200 (OK) if the operation was successful.

NameDatatypeDescription
idstringResource Id
namestringResource name
etagstringResource etag
locationstringResource location
propertiesobjectAzure Data Catalog properties.
tagsobjectResource tags
typestringResource type

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, catalogNameThe Get Azure Data Catalog Service operation retrieves a json representation of the data catalog.
create_or_updateinsertsubscriptionId, resourceGroupName, catalogNameThe Create Azure Data Catalog service operation creates a new data catalog service with the specified parameters. If the specific service already exists, then any patchable properties will be updated and any immutable properties will remain unchanged.
updateupdatesubscriptionId, resourceGroupName, catalogNameThe Update Azure Data Catalog Service operation can be used to update the existing deployment. The update call only supports the properties listed in the PATCH body.
deletedeletesubscriptionId, resourceGroupName, catalogNameThe Delete Azure Data Catalog Service operation deletes an existing data catalog.

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
catalogNamestringThe name of the data catalog in the specified subscription and resource group.
resourceGroupNamestringThe name of the resource group within the user's subscription. The name is case insensitive.
subscriptionIdstringGets subscription credentials which uniquely identify the Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

The Get Azure Data Catalog Service operation retrieves a json representation of the data catalog.

SELECT
id,
name,
etag,
location,
properties,
tags,
type
FROM azure.data_catalog.adc_catalogs
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND catalogName = '{{ catalogName }}' -- required
;

INSERT examples

The Create Azure Data Catalog service operation creates a new data catalog service with the specified parameters. If the specific service already exists, then any patchable properties will be updated and any immutable properties will remain unchanged.

INSERT INTO azure.data_catalog.adc_catalogs (
data__properties,
data__location,
data__tags,
data__etag,
subscriptionId,
resourceGroupName,
catalogName
)
SELECT
'{{ properties }}',
'{{ location }}',
'{{ tags }}',
'{{ etag }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ catalogName }}'
RETURNING
id,
name,
etag,
location,
properties,
tags,
type
;

UPDATE examples

The Update Azure Data Catalog Service operation can be used to update the existing deployment. The update call only supports the properties listed in the PATCH body.

UPDATE azure.data_catalog.adc_catalogs
SET
data__properties = '{{ properties }}',
data__location = '{{ location }}',
data__tags = '{{ tags }}',
data__etag = '{{ etag }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND catalogName = '{{ catalogName }}' --required
RETURNING
id,
name,
etag,
location,
properties,
tags,
type;

DELETE examples

The Delete Azure Data Catalog Service operation deletes an existing data catalog.

DELETE FROM azure.data_catalog.adc_catalogs
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND catalogName = '{{ catalogName }}' --required
;