UNunitycatalog
Tables

Get a table

Changed on

Gets a table for a specific catalog and schema.

get/tables/{full_name}

Request

  • Base URL
    http://localhost:8080/api/2.1/unity-catalog
  • Auth
    none declared

Query parameters

read_streaming_table_as_managedboolean

Whether to read Streaming Tables as Managed tables.

read_materialized_view_as_managedboolean

Whether to read Materialized Views as Managed tables.

Response

The table was successfully retrieved.

namestring

Name of table, relative to parent schema.

catalog_namestring

Name of parent catalog.

schema_namestring

Name of parent schema relative to its parent catalog.

table_type'MANAGED' | 'EXTERNAL' | 'STREAMING_TABLE' | 'MATERIALIZED_VIEW' | 'METRIC_VIEW' | 'VIEW'
data_source_format'DELTA' | 'ICEBERG' | 'CSV' | 'JSON' | 'AVRO' | 'PARQUET' | 'ORC' | 'TEXT'

Data source format

storage_locationstring

Storage root URL for table (for MANAGED, EXTERNAL tables)

commentstring

User-provided free-form text description.

propertiesSecurablePropertiesMap

A map of key-value properties attached to the securable.

ownerstring

Username of current owner of table.

created_atinteger

Time at which this table was created, in epoch milliseconds.

created_bystring

Username of table creator.

updated_atinteger

Time at which this table was last modified, in epoch milliseconds.

updated_bystring

Username of user who last modified the table.

table_idstring

Unique identifier for the table.

view_definitionstring

Definition text for view-like table types such as VIEW, MATERIALIZED_VIEW, STREAMING_TABLE, and METRIC_VIEW. The format depends on the table type (SQL for views, YAML for metric views).

Changes

  • 73ada80e1f76Revision changes
    • warning

      added the new ICEBERG enum value to the response property for the response status

  • 492c1b57757dRevision changes
    • warning

      added the new VIEW enum value to the response property for the response status