mirror of
https://github.com/FlipsideCrypto/osmosis-models.git
synced 2026-02-06 17:26:51 +00:00
20 lines
277 B
SQL
20 lines
277 B
SQL
{{ config(
|
|
materialized = 'view'
|
|
) }}
|
|
|
|
SELECT
|
|
blockchain,
|
|
creator,
|
|
address,
|
|
tag_name as label,
|
|
tag_type as project_name,
|
|
start_date,
|
|
end_date
|
|
FROM
|
|
{{ source(
|
|
'crosschain',
|
|
'address_tags'
|
|
) }}
|
|
WHERE
|
|
tag_type = 'ICNS'
|