Config Settings Snapshot
Table Metadata​
| Property | Configuration |
|---|---|
| Natural Key(s) | config_setting_name, valid_from |
| Partition Field(s) | N/A |
| Clustered Field(s) | N/A |
| Documentation | dbt docs |
This table captures historical snapshots of the Stellar network's configuration settings. It unpivots the individual setting columns from the config_settings table into one row per setting per change, and tracks the validity of each value over time.
Each row represents a specific setting related to transaction limits, ledger constraints, fees, and other network parameters. The valid_from and valid_to timestamps identify when each setting was active.
Column Details​
| Name | Description | Data Type | Domain Values | Required? | Notes |
|---|---|---|---|---|---|
| config_setting_name | The name of the configuration setting (metric) extracted from the source table. Each row represents a different setting tracked over time. | STRING | Yes | Natural Key. Corresponds to a column name on the bronze Config Settings table. | |
| setting_value | The numeric value associated with the configuration setting. This value represents the active limit, fee, or constraint set by the network. | INTEGER | Yes | ||
| valid_from | The timestamp when this snapshot row was first inserted and became effective. This helps in tracking changes over time. | TIMESTAMP | Yes | Natural Key. | |
| valid_to | The timestamp when this row is no longer valid. If null, the setting is currently active. | TIMESTAMP | No | ||
| is_current_setting | Boolean flag indicating if the setting is currently in effect (true if valid_to is null). | BOOLEAN | Yes |