Fetch a table.

GET {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tables/:name

Fetch a Table using the describe command output.

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

{"name":"\u003cstring\u003e","kind":"PERMANENT","cluster_by":["\u003cstring\u003e","\u003cstring\u003e"],"enable_schema_evolution":"\u003cboolean\u003e","change_tracking":"\u003cboolean\u003e","data_retention_time_in_days":"\u003cinteger\u003e","max_data_extension_time_in_days":"\u003cinteger\u003e","default_ddl_collation":"\u003cstring\u003e","columns":[{"name":"\u003cstring\u003e","datatype":"\u003cstring\u003e","nullable":true,"collate":"\u003cstring\u003e","default":"\u003cstring\u003e","autoincrement":"\u003cboolean\u003e","autoincrement_start":"\u003cinteger\u003e","autoincrement_increment":"\u003cinteger\u003e","constraints":[{"name":"\u003cstring\u003e","column_names":["\u003cstring\u003e","\u003cstring\u003e"],"constraint_type":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","column_names":["\u003cstring\u003e","\u003cstring\u003e"],"constraint_type":"\u003cstring\u003e"}],"comment":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","datatype":"\u003cstring\u003e","nullable":true,"collate":"\u003cstring\u003e","default":"\u003cstring\u003e","autoincrement":"\u003cboolean\u003e","autoincrement_start":"\u003cinteger\u003e","autoincrement_increment":"\u003cinteger\u003e","constraints":[{"name":"\u003cstring\u003e","column_names":["\u003cstring\u003e","\u003cstring\u003e"],"constraint_type":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","column_names":["\u003cstring\u003e","\u003cstring\u003e"],"constraint_type":"\u003cstring\u003e"}],"comment":"\u003cstring\u003e"}],"constraints":[{"name":"\u003cstring\u003e","column_names":["\u003cstring\u003e","\u003cstring\u003e"],"constraint_type":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","column_names":["\u003cstring\u003e","\u003cstring\u003e"],"constraint_type":"\u003cstring\u003e"}],"comment":"\u003cstring\u003e","created_on":"\u003cdateTime\u003e","database_name":"\u003cstring\u003e","schema_name":"\u003cstring\u003e","rows":"\u003clong\u003e","bytes":"\u003clong\u003e","owner":"\u003cstring\u003e","dropped_on":"\u003cdateTime\u003e","automatic_clustering":"\u003cboolean\u003e","search_optimization":"\u003cboolean\u003e","search_optimization_progress":"\u003clong\u003e","search_optimization_bytes":"\u003clong\u003e","owner_role_type":"\u003cstring\u003e","budget":"\u003cstring\u003e"}