mirror of
https://github.com/FlipsideCrypto/blast-models.git
synced 2026-02-06 12:56:43 +00:00
13ba135a6c
* new columns ymls and docs * new column in silver logs * refs to core fact tables * ymls and new columns * minor updates * columns * docs * updates for native transfer * updates * deprecation notices * native transfers table * core column changes and docs * full_decoded_log changes * merge * misc updates for deprecating columns * tx and trace status * misc updates * remove comments * remove trace_address from native_transfers * timestamps for native * docs * token transfers * missing_decoding macro * l1 fee precise * removed trace address column from silver native transfers * deprecation date * ez decoded_event_logs * standard pred
23 lines
725 B
SQL
23 lines
725 B
SQL
{% macro standard_predicate(
|
|
input_column = 'block_number'
|
|
) -%}
|
|
{%- set database_name = target.database -%}
|
|
{%- set schema_name = generate_schema_name(
|
|
node = model
|
|
) -%}
|
|
{%- set table_name = generate_alias_name(
|
|
node = model
|
|
) -%}
|
|
{%- set tmp_table_name = table_name ~ '__dbt_tmp' -%}
|
|
{%- set full_table_name = database_name ~ '.' ~ schema_name ~ '.' ~ table_name -%}
|
|
{%- set full_tmp_table_name = database_name ~ '.' ~ schema_name ~ '.' ~ tmp_table_name -%}
|
|
{{ full_table_name }}.{{ input_column }} >= (
|
|
SELECT
|
|
MIN(
|
|
{{ input_column }}
|
|
)
|
|
FROM
|
|
{{ full_tmp_table_name }}
|
|
)
|
|
{%- endmacro %}
|