mirror of
https://github.com/FlipsideCrypto/flow-models.git
synced 2026-02-06 11:26:53 +00:00
45f72e71d8
* blocks completeness * block tx count external api model * txs completeness model * add col alias * test result agg cte and temp test range * curr range test * revert source change - other pr * xchain silver * nuke api key & move to secrets, create workflow * add scheduled tag * update workflow w cache * add obs tag * rem testing range from txs complete * comment out schedule and del double comman * add default null for key var
18 lines
347 B
SQL
18 lines
347 B
SQL
{{ config (
|
|
materialized = 'view',
|
|
tags = ['scheduled']
|
|
) }}
|
|
|
|
SELECT
|
|
id,
|
|
contract,
|
|
DATA,
|
|
VALUE,
|
|
_inserted_date,
|
|
TO_TIMESTAMP_NTZ(SUBSTR(SPLIT_PART(metadata$filename, '/', 4), 1, 10) :: NUMBER, 0) AS _inserted_timestamp
|
|
FROM
|
|
{{ source(
|
|
'bronze_streamline',
|
|
'moments_minted_metadata_api'
|
|
) }}
|