Cmdlets for Google Data Catalog

Build 21.0.7930

Schemas

To view the list of schemas

Table Specific Information

Select

The cmdlet will use the Google Data Catalog API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the cmdlet.

  • DataSetName supports the 'CONTAINS' comparison.
  • Type supports the '=' comparison.
  • ProjectId supports the '=' comparison.
  • EntryGroup supports the '=' comparison.
  • CreatedTime supports the '=, <, <=, >, >=' comparisons.
  • UpdatedTime supports the '=, <, <=, >, >=' comparisons.
  • OrganizationId supports the '=' comparison.
  • DisplayName supports the 'CONTAINS' comparison.
  • Description supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Schemas WHERE CONTAINS (DataSetName, 'prop')

SELECT * FROM Schemas WHERE UpdatedTime >= '2018-01-01 01:00:00'

SELECT * FROM Schemas WHERE CreatedTime < '2018-06-01'

SELECT * FROM Schemas WHERE UpdatedTime > '2018-06-01 12:00:00' AND CreatedTime <= '2019-06-01 11:00'

SELECT * FROM Schemas WHERE OrganizationId = '112025358'

SELECT * FROM Schemas WHERE ProjectId = 'bigquery-public-data OR ProjectId = 'level-works-253411''

Additionally LastAccessedTime and UpdatedTime columns can be used in the ORDER BY clause, as following:

SELECT * FROM Schemas ORDER BY LastAccessed ASC

SELECT * FROM Schemas ORDER BY UpdatedTime DESC

Columns

Name Type Description
DatasetName String Dataset Name in the project.
Type String Type of dataset.

The allowed values are dataset, data_stream.

ProjectId String The project which the dataset created in.
Region String Cloud location of the dataset.
EntryGroup String Entry group of data asset.

The allowed values are bigquery, cloud_pubsub, data_catalog.

OrganizationId String The Organization which the dataset created in.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CreatedTime Datetime Filter by Dataset created time.
UpdatedTime Datetime Filter by Dataset updated time.
DisplayName String Display name of dataset.
Description String Description of the dataset.
LastAccessed String To sort the response by last accessed datetime.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930