Skip to main content

entry_types

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

Overview

Nameentry_types
TypeResource
Idgoogle.dataplex.entry_types

Fields

NameDatatypeDescription
namestringOutput only. The relative resource name of the EntryType, of the form: projects/{project_number}/locations/{location_id}/entryTypes/{entry_type_id}.
descriptionstringOptional. Description of the EntryType.
authorizationobjectAuthorization for an Entry Type.
createTimestringOutput only. The time when the EntryType was created.
displayNamestringOptional. User friendly display name.
etagstringOptional. This checksum is computed by the service, and might be sent on update and delete requests to ensure the client has an up-to-date value before proceeding.
labelsobjectOptional. User-defined labels for the EntryType.
platformstringOptional. The platform that Entries of this type belongs to.
requiredAspectsarrayAspectInfo for the entry type.
systemstringOptional. The system that Entries of this type belongs to. Examples include CloudSQL, MariaDB etc
typeAliasesarrayOptional. Indicates the classes this Entry Type belongs to, for example, TABLE, DATABASE, MODEL.
uidstringOutput only. System generated globally unique ID for the EntryType. This ID will be different if the EntryType is deleted and re-created with the same name.
updateTimestringOutput only. The time when the EntryType was last updated.

Methods

NameAccessible byRequired ParamsDescription
projects_locations_entry_types_getSELECTentryTypesId, locationsId, projectsIdGets an EntryType.
projects_locations_entry_types_listSELECTlocationsId, projectsIdLists EntryType resources in a project and location.
projects_locations_entry_types_createINSERTlocationsId, projectsIdCreates an EntryType.
projects_locations_entry_types_deleteDELETEentryTypesId, locationsId, projectsIdDeletes an EntryType.
projects_locations_entry_types_patchUPDATEentryTypesId, locationsId, projectsIdUpdates an EntryType.

SELECT examples

Lists EntryType resources in a project and location.

SELECT
name,
description,
authorization,
createTime,
displayName,
etag,
labels,
platform,
requiredAspects,
system,
typeAliases,
uid,
updateTime
FROM google.dataplex.entry_types
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

/*+ create */
INSERT INTO google.dataplex.entry_types (
locationsId,
projectsId,
description,
displayName,
labels,
etag,
typeAliases,
platform,
system,
requiredAspects,
authorization
)
SELECT
'{{ locationsId }}',
'{{ projectsId }}',
'{{ description }}',
'{{ displayName }}',
'{{ labels }}',
'{{ etag }}',
'{{ typeAliases }}',
'{{ platform }}',
'{{ system }}',
'{{ requiredAspects }}',
'{{ authorization }}'
;

UPDATE example

Updates a entry_types resource.

/*+ update */
UPDATE google.dataplex.entry_types
SET
description = '{{ description }}',
displayName = '{{ displayName }}',
labels = '{{ labels }}',
etag = '{{ etag }}',
typeAliases = '{{ typeAliases }}',
platform = '{{ platform }}',
system = '{{ system }}',
requiredAspects = '{{ requiredAspects }}',
authorization = '{{ authorization }}'
WHERE
entryTypesId = '{{ entryTypesId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified entry_types resource.

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