external-models/models/blast/blast__fact_leaderboard.sql
Matt Romano bd7e7893ae
AN-4724/remove-exclusions-for-lq-size-limits (#64)
Co-authored-by: drethereum <trevor.wenokur@gmail.com>
2024-05-30 11:24:37 -07:00

24 lines
411 B
SQL

{{ config(
materialized = 'view',
persist_docs ={ "relation": true,
"columns": true },
tags = ['blast'],
meta={
'database_tags':{
'table': {
'PROTOCOL': 'BLAST'
}
}
}
) }}
SELECT
DATE,
leaderboard_type,
RANK,
NAME,
points_amount,
gold_amount,
invited_by
FROM
{{ ref('bronze__blast_leaderboard') }}