catalogs

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

Overview

Name	catalogs
Type	Resource
Id	google.biglake.catalogs

Fields

Name	Datatype	Description
name	string	Output only. The resource name. Format: projects/{project_id_or_number}/locations/{location_id}/catalogs/{catalog_id}
createTime	string	Output only. The creation time of the catalog.
deleteTime	string	Output only. The deletion time of the catalog. Only set after the catalog is deleted.
expireTime	string	Output only. The time when this catalog is considered expired. Only set after the catalog is deleted.
updateTime	string	Output only. The last modification time of the catalog.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	catalogsId, locationsId, projectsId	Gets the catalog specified by the resource name.
list	SELECT	locationsId, projectsId	List all catalogs in a specified project.
create	INSERT	locationsId, projectsId	Creates a new catalog.
delete	DELETE	catalogsId, locationsId, projectsId	Deletes an existing catalog specified by the catalog ID.

SELECT examples

List all catalogs in a specified project.

SELECT
name,
createTime,
deleteTime,
expireTime,
updateTime
FROM google.biglake.catalogs
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'; 

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.biglake.catalogs (
locationsId,
projectsId
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}'
;

Manifest

- name: your_resource_model_name
  props: []

DELETE example

Deletes the specified catalogs resource.

/*+ delete */
DELETE FROM google.biglake.catalogs
WHERE catalogsId = '{{ catalogsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';