stellar-models/models/silver/core/silver__assets.yml
eric-laurello 3b3b95f7d5
AN-5773 standard prices with some customizations (#6)
* standard prices with some customizations

* .

* check

* tests/desc

* added overview file

---------

Co-authored-by: Mike Stepanovic <mike.stepanovic@flipsidecrypto.com>
2025-02-17 13:08:33 -05:00

29 lines
1.0 KiB
YAML

version: 2
models:
- name: silver__assets
columns:
- name: ASSET_TYPE
description: "{{ doc('asset_type') }}"
tests:
- not_null:
where: modified_timestamp > current_date - {{ var('test_days_threshold', 3) }}
- dbt_expectations.expect_column_values_to_be_in_type_list:
column_type_list:
- VARCHAR
- name: ASSET_CODE
description: "{{ doc('asset_code') }}"
tests:
- not_null:
where: modified_timestamp > current_date - {{ var('test_days_threshold', 3) }}
- dbt_expectations.expect_column_values_to_be_in_type_list:
column_type_list:
- VARCHAR
- name: ASSET_ISSUER
description: "{{ doc('asset_issuer') }}"
tests:
- not_null:
where: modified_timestamp > current_date - {{ var('test_days_threshold', 3) }}
- dbt_expectations.expect_column_values_to_be_in_type_list:
column_type_list:
- VARCHAR