Skip to main content
​
id
string<uuid>
required
read-only
​
name
string
required
read-only
​
slug
string
required
read-only
Pattern: ^[-a-zA-Z0-9_]+$
​
database_id
string
required
read-only
​
s3_path
string
required
read-only
​
table_format
enum<string>
required
  • delta - delta
  • iceberg - iceberg
  • bigquery - bigquery
Available options:
delta,
iceberg,
bigquery
​
catalog
string
required
read-only

Athena catalog to query this table through (federated s3tablescatalog/ for iceberg, AwsDataCatalog for delta).

​
is_scd_type_2
boolean
required
read-only
​
primary_keys
string[]
required
read-only
Maximum string length: 256
​
number_of_rows
integer | null
required
​
size_in_bytes
integer | null
required
​
created_at
string<date-time>
required
read-only
​
updated_at
string<date-time>
required
read-only
​
folder
string
required
read-only

Folder of the table (Expandable)

​
layer
string
required
read-only

Layer of the table (Expandable)

​
description
string | null
​
type
enum<string>
  • GENERAL - General
  • DIMENSION - Dimension
  • FACT - Fact
Available options:
GENERAL,
DIMENSION,
FACT
​
hidden
boolean
​
delta_log_retention_duration
integer | null
Required range: -2147483648 <= x <= 2147483647
​
delta_partitions
string[] | null
Maximum string length: 1024
​
delta_z_order_columns
string[] | null
Maximum string length: 1024
​
bigquery_partition_field
string | null

Top-level TIMESTAMP field to partition the BigQuery table on. BigQuery allows exactly one partition column per table — use clustering for additional pruning dimensions.

Maximum string length: 512
​
bigquery_partition_granularity
enum<string>

Time 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 - HOUR
  • DAY - DAY
  • MONTH - MONTH
  • YEAR - YEAR
Available options:
HOUR,
DAY,
MONTH,
YEAR
​
bigquery_allow_partition_rebuild
boolean

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.