mirror of
https://github.com/FlipsideCrypto/fsc-evm.git
synced 2026-02-06 16:36:49 +00:00
27 lines
549 B
SQL
27 lines
549 B
SQL
{# Log configuration details #}
|
|
{{ log_model_details() }}
|
|
|
|
{{ config(
|
|
materialized = 'view',
|
|
tags = ['silver','admin','variables','phase_1']
|
|
) }}
|
|
|
|
SELECT
|
|
PACKAGE,
|
|
category,
|
|
variable_key AS key,
|
|
default_value,
|
|
default_type,
|
|
_inserted_timestamp,
|
|
{{ dbt_utils.generate_surrogate_key(
|
|
['variable_key']
|
|
) }} AS dim_variables_id
|
|
FROM
|
|
{{ source(
|
|
'fsc_evm_admin',
|
|
'_master_keys'
|
|
) }}
|
|
qualify(ROW_NUMBER() over (PARTITION BY variable_key
|
|
ORDER BY
|
|
_inserted_timestamp DESC)) = 1
|