Skip to main content

collection

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

Overview

Namecollection
TypeResource
Idazure.purview_catalog.collection

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
create_or_updateinsertcollection, endpointCreates or updates an entity to a collection. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.
create_or_updatereplacecollection, endpointCreates or updates an entity to a collection. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.
create_or_update_bulkexeccollection, endpointCreates or updates entities in bulk to a collection. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.
move_entities_to_collectionexeccollection, endpointMove existing entities to the target collection.

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
collectionstringthe collection unique name.
endpointstringThe service endpoint host (no scheme). (default: )

INSERT examples

Creates or updates an entity to a collection. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.

INSERT INTO azure.purview_catalog.collection (
collection,
endpoint
)
SELECT
'{{ collection }}',
'{{ endpoint }}'
;

REPLACE examples

Creates or updates an entity to a collection. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.

REPLACE azure.purview_catalog.collection
SET
-- No updatable properties
WHERE
collection = '{{ collection }}' --required
AND endpoint = '{{ endpoint }}' --required;

Lifecycle Methods

Creates or updates entities in bulk to a collection. Existing entity is matched using its unique guid if supplied or by its unique attributes eg: qualifiedName. Map and array of collections are not well supported. E.g., array>, array>.

EXEC azure.purview_catalog.collection.create_or_update_bulk 
@collection='{{ collection }}' --required,
@endpoint='{{ endpoint }}' --required
;