| name |
string |
Specifies the name for the table, must be unique for the schema in which the table is created |
| kind |
string |
Table type - permanent, transient, or temporary |
| cluster_by |
array |
Specifies one or more columns or column expressions in the table as the clustering key |
| enable_schema_evolution |
boolean |
Table has schema evolution enabled or disabled |
| change_tracking |
boolean |
Change tracking is enabled or disabled |
| data_retention_time_in_days |
integer |
Specifies the retention period for the table so that Time Travel actions SELECT, CLONE, UNDROP can be performed on historical data in the table |
| max_data_extension_time_in_days |
integer |
Specifies the retention period for the table so that Time Travel actions SELECT, CLONE, UNDROP can be performed on historical data in the table |
| default_ddl_collation |
string |
Specifies a default collation specification for the columns in the table, including columns added to the table in the future |
| columns |
array |
|
| constraints |
array |
|
| comment |
string |
Comment for the table |
| created_on |
string |
Date and time when the table was created. |
| database_name |
string |
Database in which the table is stored |
| schema_name |
string |
Schema in which the table is stored |
| rows |
integer |
Number of rows in the table. Returns NULL for external tables. |
| bytes |
integer |
Number of bytes that will be scanned if the entire table is scanned in a query. Note that this number may be different than the number of actual physical bytes stored on-disk for the table |
| owner |
string |
Role that owns the table |
| dropped_on |
string |
Date and time when the table was dropped |
| automatic_clustering |
boolean |
If Automatic Clustering is enabled for your account, specifies whether it is explicitly enabled or disabled for the table. |
| search_optimization |
boolean |
If ON, the table has the search optimization service enabled |
| search_optimization_progress |
integer |
Percentage of the table that has been optimized for search. |
| search_optimization_bytes |
integer |
Number of additional bytes of storage that the search optimization service consumes for this table |
| owner_role_type |
string |
The type of role that owns the object. |
| budget |
string |
Name of the budget if the object is monitored by a budget |
| table_type |
string |
Type of the table |