{
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"name": "<string>",
"slug": "<string>",
"database_id": "<string>",
"s3_path": "<string>",
"catalog": "<string>",
"is_scd_type_2": true,
"primary_keys": [
"<string>"
],
"number_of_rows": 123,
"size_in_bytes": 123,
"created_at": "2023-11-07T05:31:56Z",
"updated_at": "2023-11-07T05:31:56Z",
"folder": "<string>",
"layer": "<string>",
"description": "<string>",
"hidden": true,
"delta_log_retention_duration": -1,
"delta_partitions": [
"<string>"
],
"delta_z_order_columns": [
"<string>"
],
"bigquery_partition_field": "<string>",
"bigquery_allow_partition_rebuild": true
}Table object
^[-a-zA-Z0-9_]+$delta- deltaiceberg- icebergbigquery- bigquery
delta, iceberg, bigquery Athena catalog to query this table through (federated s3tablescatalog/ for iceberg, AwsDataCatalog for delta).
256Folder of the table (Expandable)
Layer of the table (Expandable)
GENERAL- GeneralDIMENSION- DimensionFACT- Fact
GENERAL, DIMENSION, FACT -2147483648 <= x <= 214748364710241024Top-level TIMESTAMP field to partition the BigQuery table on. BigQuery allows exactly one partition column per table — use clustering for additional pruning dimensions.
512Time granularity for the partition field. Ignored when no partition field is set. Pick the coarsest granularity that still prunes well: BigQuery caps a table at 10,000 partitions.
HOUR- HOURDAY- DAYMONTH- MONTHYEAR- YEAR
HOUR, DAY, MONTH, YEAR Allow the loader to rebuild this table when its partitioning does not match the configuration. BigQuery cannot change partitioning in place, so this is a one-time full-table rewrite whose cost scales with table size. It no-ops once the partitioning matches, but stays enabled — a later change to the partition field or granularity will rebuild the table again.
Was this page helpful?