request_avro_type |
Method by which this table was created. Possible values are:
- create_table
- create_projection
- create_union
|
request_avro_json |
The JSON representation of request creating this table. The default value is ''. |
protected |
No longer used. Indicated whether the respective table was protected or not. Possible values are:
|
record_bytes |
The number of in-memory bytes per record which is the sum of the byte sizes of all columns with property 'data'. |
total_bytes |
The total size in bytes of all data stored in the table. |
collection_names |
[DEPRECATED--use schema_name instead] This will now contain the name of the schema for the table. There can only be one schema for a table. |
schema_name |
The name of the schema for the table. There can only be one schema for a table. |
table_ttl |
The value of the time-to-live setting. Not present for schemas. |
remaining_table_ttl |
The remaining time-to-live, in minutes, before the respective table expires (-1 if it will never expire). Not present for schemas. |
foreign_keys |
Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primary_key_column)'. Not present for schemas. The default value is ''. |
foreign_shard_key |
Foreign shard key description of the format: <fk_foreign_key> references <pk_column_name> from <pk_table_name>(<pk_primary_key>). Not present for schemas. The default value is ''. |
partition_type |
Partitioning scheme used for this table The default value is NONE.
|
partition_keys |
Comma-separated list of partition keys. The default value is ''. |
partition_definitions |
Comma-separated list of partition definitions, whose format depends on the partition_type. See partitioning documentation for details. The default value is ''. |
is_automatic_partition |
True if partitions will be created for LIST VALUES which don't fall into existing partitions. The default value is ''. |
attribute_indexes |
Semicolon-separated list of indexes. For column (attribute) indexes, only the indexed column name will be listed. For other index types, the index type will be
listed with the colon-delimited indexed column(s) using the form: <index_type>@<column_list>. Not present for schemas. The default value is ''. |
compressed_columns |
No longer supported. The default value is ''. |
column_info |
JSON-encoded string representing a map of column name to information including memory usage if the get_column_info option is true. The default value is ''. |
global_access_mode |
Returns the global access mode (i.e. lock status) for the table.
Possible
Values |
Description |
no_access |
No read/write operations are allowed on this table. |
read_only |
Only read operations are allowed on this table. |
write_only |
Only write operations are allowed on this table. |
read_write |
All read/write operations are allowed on this table. |
|
view_table_name |
For materialized view the name of the view this member table is part of - if same as the table_name then this is the root of the view. The default value is ''. |
is_view_persisted |
True if the view named view_table_name is persisted - reported for each view member. Means method of recreating this member is saved - not the members data. The default value is ''. |
is_dirty |
True if some input table of the materialized view that affects this member table has been modified since the last refresh. The default value is ''. |
refresh_method |
For materialized view current refresh_method - one of manual, periodic, on_change. The default value is ''. |
refresh_start_time |
For materialized view with periodic refresh_method the current intial datetime string that periodic refreshes began. The default value is ''. |
refresh_stop_time |
Time at which the periodic view refresh stops. The default value is ''. |
refresh_period |
For materialized view with periodic refresh_method the current refresh period in seconds. The default value is ''. |
last_refresh_time |
For materialized view the a datatime string indicating the last time the view was refreshed. The default value is ''. |
next_refresh_time |
For materialized view with periodic refresh_method a datetime string indicating the next time the view is to be refreshed. The default value is ''. |
user_chunk_size |
User-specified number of records per chunk, if provided at table creation time. The default value is ''. |
owner_resource_group |
Name of the owner resource group. The default value is ''. |
alternate_shard_keys |
Semicolon-separated list of shard keys that were equated in joins (applicable for join tables). The default value is ''. |
datasource_subscriptions |
Semicolon-separated list of datasource names the table has subscribed to. The default value is ''. |