mirror of
https://github.com/FlipsideCrypto/stellar-models.git
synced 2026-02-06 16:46:50 +00:00
4d53ca391f
* add stats and daily schedule * added overview docs --------- Co-authored-by: Mike Stepanovic <mike.stepanovic@flipsidecrypto.com>
25 lines
418 B
SQL
25 lines
418 B
SQL
{{ config(
|
|
materialized = 'view',
|
|
tags = ['scheduled_daily']
|
|
) }}
|
|
|
|
SELECT
|
|
blockchain,
|
|
UPPER(address) AS address,
|
|
creator,
|
|
label_type,
|
|
label_subtype,
|
|
address_name,
|
|
project_name,
|
|
_is_deleted,
|
|
labels_combined_id,
|
|
inserted_timestamp,
|
|
modified_timestamp
|
|
FROM
|
|
{{ source(
|
|
'crosschain_silver',
|
|
'labels_combined'
|
|
) }}
|
|
WHERE
|
|
blockchain = 'stellar'
|