mirror of
https://github.com/FlipsideCrypto/external-models.git
synced 2026-02-06 13:37:11 +00:00
25 lines
492 B
SQL
25 lines
492 B
SQL
{{ config(
|
|
materialized = 'view',
|
|
persist_docs ={ "relation": true,
|
|
"columns": true },
|
|
tags = ['farcaster'],
|
|
meta ={ 'database_tags':{ 'table':{ 'PROTOCOL': 'FARCASTER' } } }
|
|
) }}
|
|
|
|
SELECT
|
|
fid,
|
|
fname,
|
|
display_name,
|
|
avatar_url,
|
|
bio,
|
|
verified_addresses,
|
|
updated_at
|
|
FROM
|
|
{{ source(
|
|
'external_bronze',
|
|
'farcaster_profile_with_addresses'
|
|
) }}
|
|
qualify(ROW_NUMBER() over (PARTITION BY fid
|
|
ORDER BY
|
|
updated_at DESC)) = 1
|