mirror of
https://github.com/FlipsideCrypto/crosschain-models.git
synced 2026-02-06 14:46:50 +00:00
0634e70350
* coin gecko and cmc prices tables for all blockchains * all_providers prices draft * standardized platform column * asset metadata, priority prices, and core dimensional/fact/ez tables for prices, metadata and contracts * yml changes * resolved issues with compiling * prioritized symbol in prices * unique address on ez prices * updates to asset_metadata for efficiency * asset_metadata updates for blockchain and unique_key * prioritized coingecko symbol and decimals * removed test * removed eth pow and eth classic * SO on priority prices model * moved symbol and decimal joins to view layer * moved dim_contracts join to asset_metadata view * moved asset_metadata contracts join to view layer * priority model for ez_asset_metadata and docs * qualify statements modified
14 lines
262 B
SQL
14 lines
262 B
SQL
{% test token_address_match(
|
|
model,
|
|
column_name
|
|
) %}
|
|
|
|
SELECT DISTINCT {{ column_name }}
|
|
FROM
|
|
{{ model }}
|
|
WHERE
|
|
{{ column_name }} IS NOT NULL
|
|
AND (LEN({{ column_name }}) != 42
|
|
OR {{ column_name }} NOT ILIKE '0x%')
|
|
|
|
{% endtest %} |