List Schemas


Lists all schemas in a certain database in a certain catalog or processing platform.

We map the native hierarchy of any platform or catalog onto the following:

database → schema → table

pace list schemas [flags]


	pace list schemas --catalog COLLIBRA-testdrive --database b6e043a7-88f1-42ee-8e81-0fdc1c96f471 --output table

	ID                                     NAME

	68c97f58-fa4f-4b55-b8c3-95c321f7dae9   Snowflake Protect>DC22_PROTECT_TESTDRIVE>DCC_22_DEMO
	10255be7-c2ac-43ae-be0a-a34d4e7c88b7   Snowflake Protect>DC22_PROTECT_TESTDRIVE>DEMO

Another example:

	pace list schemas --processing-platform bigquery-dev --database stream-machine-development -o table
	ID                           NAME

	batch_job_demo               batch_job_demo
	dlp_demo                     dlp_demo
	dynamic_view_poc             dynamic_view_poc
	dynamic_views                dynamic_views
	jdbc_bigquery_test           jdbc_bigquery_test


  -c, --catalog string               id of catalog
  -d, --database string              database in the catalog
  -h, --help                         help for schemas
  -o, --output string                output formats [yaml, json, json-raw, table, plain] (default "yaml")
  -p, --processing-platform string   id of processing platform

Options inherited from parent commands

      --api-host string                         api host (default "localhost:50051")
  -P, --page-size uint32                        the maximum number of records per page (default 10)
  -T, --page-token string                       next page token. Used by BigQuery
  -S, --skip uint32                             the number of records that need to be skipped
      --telemetry-upload-interval-seconds int   Upload usage statistics every so often. Use -1 to disable (default 3600)


Last updated