mirror of
https://github.com/FlipsideCrypto/solana-models.git
synced 2026-02-06 13:56:50 +00:00
7892ce4ad2
* model to get current tx count by block in snowflake * compare actual vs expected tx count when available * use existing logic for older blocks or we dont have expected counts
27 lines
979 B
YAML
27 lines
979 B
YAML
version: 2
|
|
models:
|
|
- name: silver_observability__blocks_tx_count
|
|
description: Records of all block transaction counts. This is an intermediate table used for transaction completeness testing
|
|
columns:
|
|
- name: BLOCK_ID
|
|
description: The lowest block id in the test
|
|
tests:
|
|
- not_null
|
|
- unique
|
|
- dbt_expectations.expect_column_values_to_be_in_type_list:
|
|
column_type_list:
|
|
- NUMBER
|
|
- name: TRANSACTION_COUNT
|
|
description: The lowest block id in the test
|
|
tests:
|
|
- not_null
|
|
- dbt_expectations.expect_column_values_to_be_in_type_list:
|
|
column_type_list:
|
|
- NUMBER
|
|
- name: _INSERTED_TIMESTAMP
|
|
description: The lowest block timestamp in the test
|
|
tests:
|
|
- not_null
|
|
- dbt_expectations.expect_column_values_to_be_in_type_list:
|
|
column_type_list:
|
|
- TIMESTAMP_NTZ |