Skip to main content

entries

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

Overview

Nameentries
TypeResource
Idgoogle.dataplex.entries

Fields

NameDatatypeDescription
namestringIdentifier. The relative resource name of the entry, in the format projects/{project_id_or_number}/locations/{location_id}/entryGroups/{entry_group_id}/entries/{entry_id}.
aspectsobjectOptional. The aspects that are attached to the entry. Depending on how the aspect is attached to the entry, the format of the aspect key can be one of the following: If the aspect is attached directly to the entry: {project_id_or_number}.{location_id}.{aspect_type_id} If the aspect is attached to an entry's path: {project_id_or_number}.{location_id}.{aspect_type_id}@{path}
createTimestringOutput only. The time when the entry was created in Dataplex.
entrySourceobjectInformation related to the source system of the data resource that is represented by the entry.
entryTypestringRequired. Immutable. The relative resource name of the entry type that was used to create this entry, in the format projects/{project_id_or_number}/locations/{location_id}/entryTypes/{entry_type_id}.
fullyQualifiedNamestringOptional. A name for the entry that can be referenced by an external system. For more information, see Fully qualified names (https://cloud.google.com/data-catalog/docs/fully-qualified-names). The maximum size of the field is 4000 characters.
parentEntrystringOptional. Immutable. The resource name of the parent entry.
updateTimestringOutput only. The time when the entry was last updated in Dataplex.

Methods

NameAccessible byRequired ParamsDescription
projects_locations_entry_groups_entries_getSELECTentriesId, entryGroupsId, locationsId, projectsIdGets an Entry.
projects_locations_entry_groups_entries_listSELECTentryGroupsId, locationsId, projectsIdLists Entries within an EntryGroup.
projects_locations_entry_groups_entries_createINSERTentryGroupsId, locationsId, projectsIdCreates an Entry.
projects_locations_entry_groups_entries_deleteDELETEentriesId, entryGroupsId, locationsId, projectsIdDeletes an Entry.
projects_locations_entry_groups_entries_patchUPDATEentriesId, entryGroupsId, locationsId, projectsIdUpdates an Entry.

SELECT examples

Lists Entries within an EntryGroup.

SELECT
name,
aspects,
createTime,
entrySource,
entryType,
fullyQualifiedName,
parentEntry,
updateTime
FROM google.dataplex.entries
WHERE entryGroupsId = '{{ entryGroupsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

/*+ create */
INSERT INTO google.dataplex.entries (
entryGroupsId,
locationsId,
projectsId,
name,
entryType,
aspects,
parentEntry,
fullyQualifiedName,
entrySource
)
SELECT
'{{ entryGroupsId }}',
'{{ locationsId }}',
'{{ projectsId }}',
'{{ name }}',
'{{ entryType }}',
'{{ aspects }}',
'{{ parentEntry }}',
'{{ fullyQualifiedName }}',
'{{ entrySource }}'
;

UPDATE example

Updates a entries resource.

/*+ update */
UPDATE google.dataplex.entries
SET
name = '{{ name }}',
entryType = '{{ entryType }}',
aspects = '{{ aspects }}',
parentEntry = '{{ parentEntry }}',
fullyQualifiedName = '{{ fullyQualifiedName }}',
entrySource = '{{ entrySource }}'
WHERE
entriesId = '{{ entriesId }}'
AND entryGroupsId = '{{ entryGroupsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified entries resource.

/*+ delete */
DELETE FROM google.dataplex.entries
WHERE entriesId = '{{ entriesId }}'
AND entryGroupsId = '{{ entryGroupsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';