data_attribute_bindings

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

Overview

Name	data_attribute_bindings
Type	Resource
Id	google.dataplex.data_attribute_bindings

Fields

Name	Datatype	Description
name	string	Output only. The relative resource name of the Data Attribute Binding, of the form: projects/{project_number}/locations/{location}/dataAttributeBindings/{data_attribute_binding_id}
description	string	Optional. Description of the DataAttributeBinding.
attributes	array	Optional. List of attributes to be associated with the resource, provided in the form: projects/{project}/locations/{location}/dataTaxonomies/{dataTaxonomy}/attributes/{data_attribute_id}
createTime	string	Output only. The time when the DataAttributeBinding was created.
displayName	string	Optional. User friendly display name.
etag	string	This checksum is computed by the server based on the value of other fields, and may be sent on update and delete requests to ensure the client has an up-to-date value before proceeding. Etags must be used when calling the DeleteDataAttributeBinding and the UpdateDataAttributeBinding method.
labels	object	Optional. User-defined labels for the DataAttributeBinding.
paths	array	Optional. The list of paths for items within the associated resource (eg. columns and partitions within a table) along with attribute bindings.
resource	string	Optional. Immutable. The resource name of the resource that is associated to attributes. Presently, only entity resource is supported in the form: projects/{project}/locations/{location}/lakes/{lake}/zones/{zone}/entities/{entity_id} Must belong in the same project and region as the attribute binding, and there can only exist one active binding for a resource.
uid	string	Output only. System generated globally unique ID for the DataAttributeBinding. This ID will be different if the DataAttributeBinding is deleted and re-created with the same name.
updateTime	string	Output only. The time when the DataAttributeBinding was last updated.

Methods

Name	Accessible by	Required Params	Description
projects_locations_data_attribute_bindings_get	SELECT	dataAttributeBindingsId, locationsId, projectsId	Retrieves a DataAttributeBinding resource.
projects_locations_data_attribute_bindings_list	SELECT	locationsId, projectsId	Lists DataAttributeBinding resources in a project and location.
projects_locations_data_attribute_bindings_create	INSERT	locationsId, projectsId	Create a DataAttributeBinding resource.
projects_locations_data_attribute_bindings_delete	DELETE	dataAttributeBindingsId, locationsId, projectsId	Deletes a DataAttributeBinding resource. All attributes within the DataAttributeBinding must be deleted before the DataAttributeBinding can be deleted.
projects_locations_data_attribute_bindings_patch	UPDATE	dataAttributeBindingsId, locationsId, projectsId	Updates a DataAttributeBinding resource.

SELECT examples

Lists DataAttributeBinding resources in a project and location.

SELECT
name,
description,
attributes,
createTime,
displayName,
etag,
labels,
paths,
resource,
uid,
updateTime
FROM google.dataplex.data_attribute_bindings
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.dataplex.data_attribute_bindings (
locationsId,
projectsId,
description,
displayName,
labels,
etag,
resource,
attributes,
paths
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ description }}',
'{{ displayName }}',
'{{ labels }}',
'{{ etag }}',
'{{ resource }}',
'{{ attributes }}',
'{{ paths }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: uid
      value: string
    - name: createTime
      value: string
    - name: updateTime
      value: string
    - name: description
      value: string
    - name: displayName
      value: string
    - name: labels
      value: object
    - name: etag
      value: string
    - name: resource
      value: string
    - name: attributes
      value:
        - string
    - name: paths
      value:
        - - name: name
            value: string
          - name: attributes
            value:
              - string

UPDATE example

Updates a data_attribute_bindings resource.

/*+ update */
UPDATE google.dataplex.data_attribute_bindings
SET 
description = '{{ description }}',
displayName = '{{ displayName }}',
labels = '{{ labels }}',
etag = '{{ etag }}',
resource = '{{ resource }}',
attributes = '{{ attributes }}',
paths = '{{ paths }}'
WHERE 
dataAttributeBindingsId = '{{ dataAttributeBindingsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified data_attribute_bindings resource.

/*+ delete */
DELETE FROM google.dataplex.data_attribute_bindings
WHERE dataAttributeBindingsId = '{{ dataAttributeBindingsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';