UNunitycatalog
Tables

Create a table. Only external table creation is supported. WARNING: This API is experimental and will change in future versions.

Changed on

Creates a new external table instance. WARNING: This API is experimental and will change in future versions.

post/tables

Request

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

Request body

namestring required

Name of table, relative to parent schema.

catalog_namestring required

Name of parent catalog.

schema_namestring required

Name of parent schema relative to its parent catalog.

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

Data source format

storage_locationstring

Storage root URL for external table

commentstring

User-provided free-form text description.

propertiesSecurablePropertiesMap

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

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).

Response

The new external table was successfully created.

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

    • info

      added the new ICEBERG enum value to the request property

  • 492c1b57757dRevision changes
    • warning

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

    • info

      added the new VIEW enum value to the request property