mirror of
https://github.com/FlipsideCrypto/optimism-models.git
synced 2026-02-06 20:41:45 +00:00
4528d47adf
* created core__ez_dex_swaps view * added synthetix swaps models and adjusted velodrome / sushi models for necessary ez_dex columns * fixed error in velo pools backfill seed causing duplicates * fixed issue with silver prices causing duplicate token_address * added univ3 pools and swaps models for integration into ez_dex_swaps * replaced null event_names with swap * added univ3 to dex_swaps and added not null event name test * updated gitignore for dbt-env * curve pools silver model * added incremental logic to curve pools table * adjusted data type on decimal column * updated curve_pools and added curve_swaps * case when for null event_name * removed dbt-env * snowflake tagging for ez_dex_swaps * added beethoven swaps and pools tables, and joined them to ez_dex_swaps * beethoven pools yml * removed column from synthetix swaps yml * recreated velodrome pools model using the reads udf * change event_name to reference topic * deleted velo_pools_backfill seed and hardcoded function sigs * changed udf_hex_to_int ref to ethereum.public * changed synthetix swaps to reference data instead of event inputs * changed event_input references to data in beethoven models * rounded usd values * modified tx_to logic in curve swaps * modified curve swaps for proper volumes
9 lines
240 B
SQL
9 lines
240 B
SQL
-- {% macro create_udfs() %}
|
|
-- {% if var("UPDATE_UDFS_AND_SPS") %}
|
|
-- {% set sql %}
|
|
-- CREATE schema if NOT EXISTS silver;
|
|
-- {% endset %}
|
|
-- {% do run_query(sql) %}
|
|
-- {% endif %}
|
|
-- {% endmacro %}
|