mirror of
https://github.com/FlipsideCrypto/external-models.git
synced 2026-02-06 16:46:51 +00:00
20a1126d5b
Co-authored-by: San Yong <22216004+SanYongxie@users.noreply.github.com> Co-authored-by: gregoriustanleyy <gstanleytejakusuma@gmail.com>
36 lines
1008 B
YAML
36 lines
1008 B
YAML
version: 2
|
|
models:
|
|
- name: bitquery__tx_count
|
|
description: >
|
|
This model returns the number of transactions for each blockchain and block date.
|
|
tests:
|
|
- dbt_utils.unique_combination_of_columns:
|
|
combination_of_columns:
|
|
- BLOCKCHAIN
|
|
- METRIC
|
|
- BLOCK_DATE
|
|
|
|
columns:
|
|
- name: BLOCKCHAIN
|
|
description: >
|
|
The blockchain where the transactions are from.
|
|
tests:
|
|
- not_null
|
|
- name: METRIC
|
|
description: >
|
|
The metric name - always 'tx_count'.
|
|
tests:
|
|
- not_null
|
|
- name: BLOCK_DATE
|
|
description: >
|
|
The date when the transactions are counted.
|
|
tests:
|
|
- not_null
|
|
- dbt_expectations.expect_row_values_to_have_recent_data:
|
|
datepart: day
|
|
interval: 2
|
|
- name: TX_COUNT
|
|
description: >
|
|
The number of transactions for this date.
|
|
tests:
|
|
- not_null |