mirror of
https://github.com/FlipsideCrypto/flow-models.git
synced 2026-02-06 15:51:48 +00:00
a0e441d668
* deprecation and new view * reorg * is_deprecated * deprecated * upd dbt model tag --------- Co-authored-by: forgash_ <jmfxyz@pm.me>
30 lines
467 B
SQL
30 lines
467 B
SQL
{{ config (
|
|
materialized = 'view'
|
|
) }}
|
|
|
|
SELECT
|
|
HOUR,
|
|
asset_id,
|
|
symbol,
|
|
NAME,
|
|
decimals,
|
|
price,
|
|
blockchain,
|
|
is_imputed,
|
|
is_deprecated,
|
|
provider,
|
|
source,
|
|
_inserted_timestamp,
|
|
inserted_timestamp,
|
|
modified_timestamp,
|
|
complete_native_prices_id,
|
|
_invocation_id
|
|
FROM
|
|
{{ source(
|
|
'silver_crosschain',
|
|
'complete_native_prices'
|
|
) }}
|
|
WHERE
|
|
blockchain = 'flow'
|
|
AND symbol = 'FLOW'
|