📰 2024-07-05: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 19 PRs merged from 11 wizards. Great job everyone! 🎉
We had 12 added models 🟢 and 185 modified models 🟠 for 10 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
prices	5	0	9	5
_sector	3	4	12	2
macros	4	0	29	2
models	2	0	41	2
_project	2	0	73	1
beethoven_x	1	4	5	1
seeds	3	3	13	1
airdrop	1	0	2	1
etherfi	1	1	0	1
cow_protocol	1	0	1	1

SECTOR: prices

toggle to see all model updates

MODEL: prices_blast_tokens.sql

🟠 Modified by:

🔧 PR: #6289, feat: add BLAST L2 governance token
🧙 Author: @0xPr0f on 2024-07-03
📝 Summary: The token symbols that were added or removed are: YOLO, BLAST

MODEL: prices_trusted_tokens.sql

🟠 Modified by:

🔧 PR: #6310, add trusted solana prices
🧙 Author: @0xRobin on 2024-07-03
📝 Summary: The tokens that were added are: SOL, mSOL, USDT, USDC.

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #6293, add missing tokens to tokens.erc20 and prices.usd
🧙 Author: @viniabussafi on 2024-07-03
📝 Summary: The tokens that were added are: GHO, rsETH, DOLA, USX

MODEL: prices_gnosis_tokens.sql

🟠 Modified by:

🔧 PR: #6293, add missing tokens to tokens.erc20 and prices.usd
🧙 Author: @viniabussafi on 2024-07-03
📝 Summary: The tokens that were added are: GIV, USDC.e

MODEL: prices_optimism_tokens_curated.sql

🟠 Modified by:

🔧 PR: #6293, add missing tokens to tokens.erc20 and prices.usd
🧙 Author: @viniabussafi on 2024-07-03
📝 Summary: Three tokens were added to the model: 'SONNE', 'rETH', and 'WEETH'.

MODEL: prices_polygon_tokens.sql

🟠 Modified by:

🔧 PR: #6293, add missing tokens to tokens.erc20 and prices.usd
🧙 Author: @viniabussafi on 2024-07-03
📝 Summary: The tokens that were added or removed are: Added: DFX Removed: None

MODEL: prices_zkevm_tokens.sql

🟠 Modified by:

🔧 PR: #6293, add missing tokens to tokens.erc20 and prices.usd
🧙 Author: @viniabussafi on 2024-07-03
📝 Summary: wstETH

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #6305, Add price of wcomai
🧙 Author: @rivusdao on 2024-07-03
📝 Summary: The tokens that were added or removed are: QUARTZ, WCOMAI

MODEL: prices_scroll_tokens.sql

🟠 Modified by:

🔧 PR: #6283, Add new token prices for Scroll
🧙 Author: @Jam516 on 2024-07-02
📝 Summary: dai, stone, sis, rseth, iusd, pxeth, frxeth,solvbtc

SECTOR: _sector

toggle to see all model updates

MODEL: cipher_arbitrum_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added a new column block_date which casts the evt_block_time to date.

MODEL: post_tech_arbitrum_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added a new column 'block_date' which casts the event block time to date.

MODEL: social_arbitrum_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added the column 'block_date' to the base_union CTE.

MODEL: social_avalanche_c_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added the column 'block_date' to the base_union CTE.

MODEL: stars_arena_avalanche_c_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added logic to cast the block_time as a date and included it as block_date in the SELECT statement.

MODEL: friend_tech_base_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added logic to cast the event block time as a date and renamed it as block_date.

MODEL: social_base_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: A new column block_date was added to the SQL model.

MODEL: friend3_bnb_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added logic to cast the event block time as a date and include it in the select statement.

MODEL: social_bnb_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: A new column block_date was added to the SQL model.

MODEL: social_base_trades.sql

🟠 Modified by:

🔧 PR: #6320, Dex trades performance test: Join on block_date
🧙 Author: @aalan3 on 2024-07-05
📝 Summary: Added a new column 'block_date' to the SELECT statement in the dbt SQL model.

MODEL: tokens_blast_base_transfers.sql

🟢 Added by:

🔧 PR: #6302, Create tokens_blast.transfers
🧙 Author: @hildobby on 2024-07-02
📝 Summary: This SQL model creates a base table for transfers data from the 'blast' blockchain, combining information from various sources such as traces, transactions, and ERC20 transfers. It enables data analysts to analyze and track transfer activities within the specified blockchain network efficiently.

MODEL: tokens_blast_transfers.sql

🟢 Added by:

🔧 PR: #6302, Create tokens_blast.transfers
🧙 Author: @hildobby on 2024-07-02
📝 Summary: This model creates an enriched table of transfers by combining data from various sources such as token transfers, ERC20 tokens, USD prices, and EVMs information. It allows data analysts to analyze transfer activities starting from April 22, 2020 in the Blast blockchain environment.

MODEL: tokens_transfers.sql

🟠 Modified by:

🔧 PR: #6303, Create tokens_blast.transfers
🧙 Author: @hildobby on 2024-07-02
📝 Summary: A new value 'blast' was added to a list in the model.

🔧 PR: #6303, Create tokens_mantle.transfers
🧙 Author: @hildobby on 2024-07-02
📝 Summary: The string values 'mantle' was added to the list of strings in a Jinja macro.

MODEL: tokens_mantle_base_transfers.sql

🟢 Added by:

🔧 PR: #6303, Create tokens_mantle.transfers
🧙 Author: @hildobby on 2024-07-02
📝 Summary: This dbt SQL model creates a base table for transfers data from the Mantle blockchain, including traces, transactions, and ERC20 token transfers. It enables data analysts to easily access and analyze transfer information within the specified blockchain environment.

MODEL: tokens_mantle_transfers.sql

🟢 Added by:

🔧 PR: #6303, Create tokens_mantle.transfers
🧙 Author: @hildobby on 2024-07-02
📝 Summary: This model creates an enriched table of transfers by combining base transfer data with ERC20 token information, USD prices, and EVMs info. It enables data analysts to analyze transfers starting from April 22, 2020, within the Mantle blockchain environment.

SECTOR: macros

toggle to see all model updates

MODEL: oneinch_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6286, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_mapped_methods.sql was renamed.

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_mapped_methods.sql was renamed.

MODEL: oneinch_project_orders_cfg_events_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_project_orders_cfg_events_macro.sql was renamed.

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_project_orders_cfg_events_macro.sql was renamed.

MODEL: oneinch_project_orders_cfg_methods_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_project_orders_cfg_methods_macro.sql was renamed.

🔧 PR: #6286, 1inch-U30: fixes & updates
🧙 Author: @max-morrow on 2024-07-04
📝 Summary: [changes too large] The model oneinch_project_orders_cfg_methods_macro.sql was modified.

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_project_orders_cfg_methods_macro.sql was renamed.

MODEL: oneinch_project_orders_raw_logs_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_project_orders_raw_logs_macro.sql was renamed.

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_project_orders_raw_logs_macro.sql was renamed.

MODEL: oneinch_project_orders_raw_traces_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_project_orders_raw_traces_macro.sql was renamed.

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_project_orders_raw_traces_macro.sql was renamed.

MODEL: oneinch_ar_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch-U31: migrate to pre-materialized traces (main lineage optimization)
🧙 Author: @grkhr on 2024-07-04
📝 Summary: [changes too large] The model oneinch_ar_macro.sql was modified.

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_ar_macro.sql was renamed.

MODEL: oneinch_ar_cfg_contracts_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_ar_cfg_contracts_macro.sql was renamed.

MODEL: oneinch_ar_handle_generic.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_ar_handle_generic.sql was renamed.

MODEL: oneinch_ar_handle_unoswap.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_ar_handle_unoswap.sql was renamed.

MODEL: oneinch_ar_raw_traces_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_ar_raw_traces_macro.sql was renamed.

MODEL: oneinch_lop_cfg_contracts_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_lop_cfg_contracts_macro.sql was renamed.

MODEL: oneinch_lop_raw_traces_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_lop_raw_traces_macro.sql was renamed.

MODEL: oneinch_blockchain_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_blockchain_macro.sql was renamed.

MODEL: oneinch_exposed_blockchains_list.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_exposed_blockchains_list.sql was renamed.

MODEL: oneinch_mapped_contracts_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_mapped_contracts_macro.sql was renamed.

MODEL: oneinch_call_transfers_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_call_transfers_macro.sql was renamed.

MODEL: oneinch_calls_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_calls_macro.sql was renamed.

MODEL: oneinch_lop_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_lop_macro.sql was renamed.

MODEL: oneinch_parsed_transfers_from_calls_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_parsed_transfers_from_calls_macro.sql was renamed.

MODEL: oneinch_project_calls_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_project_calls_macro.sql was renamed.

MODEL: oneinch_project_orders_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_project_orders_macro.sql was renamed.

MODEL: oneinch_project_swaps_macro.sql

🟠 Modified by:

🔧 PR: #6286, 1inch: move macros folder to /dex
🧙 Author: @grkhr on 2024-07-02
📝 Summary: [changes too large] The model oneinch_project_swaps_macro.sql was renamed.

SECTOR: models

toggle to see all model updates

MODEL: oneinch_arbitrum_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_arbitrum_mapped_contracts.sql was renamed.

MODEL: oneinch_arbitrum_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_arbitrum_mapped_methods.sql was renamed.

MODEL: oneinch_arbitrum_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_arbitrum_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_arbitrum_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_arbitrum_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_avalanche_c_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_avalanche_c_mapped_contracts.sql was renamed.

MODEL: oneinch_avalanche_c_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_avalanche_c_mapped_methods.sql was renamed.

MODEL: oneinch_avalanche_c_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_avalanche_c_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_avalanche_c_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_base_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_base_mapped_contracts.sql was renamed.

MODEL: oneinch_base_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_base_mapped_methods.sql was renamed.

MODEL: oneinch_base_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_base_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_base_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_base_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_bnb_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_bnb_mapped_contracts.sql was renamed.

MODEL: oneinch_bnb_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_bnb_mapped_methods.sql was renamed.

MODEL: oneinch_bnb_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_bnb_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_bnb_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_bnb_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_ethereum_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_ethereum_mapped_contracts.sql was renamed.

MODEL: oneinch_ethereum_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_ethereum_mapped_methods.sql was renamed.

MODEL: oneinch_ethereum_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_ethereum_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_ethereum_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_ethereum_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_fantom_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_fantom_mapped_contracts.sql was renamed.

MODEL: oneinch_fantom_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_fantom_mapped_methods.sql was renamed.

MODEL: oneinch_fantom_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_fantom_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_fantom_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_fantom_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_gnosis_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_gnosis_mapped_contracts.sql was renamed.

MODEL: oneinch_gnosis_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_gnosis_mapped_methods.sql was renamed.

MODEL: oneinch_gnosis_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_gnosis_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_gnosis_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_gnosis_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_optimism_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_optimism_mapped_contracts.sql was renamed.

MODEL: oneinch_optimism_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_optimism_mapped_methods.sql was renamed.

MODEL: oneinch_optimism_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_optimism_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_optimism_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_optimism_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_polygon_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_polygon_mapped_contracts.sql was renamed.

MODEL: oneinch_polygon_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_polygon_mapped_methods.sql was renamed.

MODEL: oneinch_polygon_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_polygon_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_polygon_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_polygon_project_orders_raw_traces.sql was renamed.

MODEL: oneinch_zksync_mapped_contracts.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_zksync_mapped_contracts.sql was renamed.

MODEL: oneinch_zksync_mapped_methods.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_zksync_mapped_methods.sql was renamed.

MODEL: oneinch_zksync_project_orders_raw_logs.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_zksync_project_orders_raw_logs.sql was renamed.

MODEL: oneinch_zksync_project_orders_raw_traces.sql

🟠 Modified by:

🔧 PR: #6321, 1inch-U32: move project_ lineage to daily_spellbook
🧙 Author: @grkhr on 2024-07-05
📝 Summary: [changes too large] The model oneinch_zksync_project_orders_raw_traces.sql was renamed.

MODEL: _schema.yml

🟠 Modified by:

🔧 PR: #6299, Owner labels daily
🧙 Author: @aalan3 on 2024-07-02
📝 Summary: [changes too large] The model _schema.yml was renamed.

SECTOR: _project

toggle to see all model updates

MODEL: balancer_v2_arbitrum_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Changed the name of a macro from balancer_token_balance_changes_macro to balancer_v2_compatible_token_balance_changes_macro. Added parameters for project decoding, base spells namespace, and pool labels spell source.

MODEL: balancer_v2_arbitrum_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a macro balancer_v2_compatible_token_balance_changes_daily_agg_macro with additional parameters project_decoded_as and base_spells_namespace.

MODEL: balancer_v2_avalanche_c_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Changed the name of a macro from balancer_token_balance_changes_macro to balancer_v2_compatible_token_balance_changes_macro. Added parameters for project decoding, base spells namespace, and pool labels spell source.

MODEL: balancer_v2_avalanche_c_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Changed the name of a dbt macro from balancer_token_balance_changes_daily_agg_macro to balancer_v2_compatible_token_balance_changes_daily_agg_macro. Added parameters for project_decoded_as and base_spells_namespace, with corresponding values.

MODEL: balancer_v2_base_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Changed the macro name from balancer_token_balance_changes_macro to balancer_v2_compatible_token_balance_changes_macro. Added parameters for project decoding, base spells namespace, and pool labels spell source.

MODEL: balancer_v2_base_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a parameter project_decoded_as with value 'balancer_v2' and base_spells_namespace with value 'balancer' to the macro named balancer_v2_compatible_token_balance_changes_daily_agg_macro. The version parameter was also updated to be set as '2'.

MODEL: balancer_v2_ethereum_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Changed the macro name from balancer_token_balance_changes_macro to balancer_v2_compatible_token_balance_changes_macro. Added parameters for project decoding, base spells namespace, and pool labels spell source.

MODEL: balancer_v2_ethereum_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a parameter project_decoded_as with value 'balancer_v2' and base_spells_namespace with value 'balancer' to the macro named balancer_v2_compatible_token_balance_changes_daily_agg_macro. The version parameter was also updated to be set as '2'.

MODEL: balancer_v2_gnosis_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a parameter specifying the project decoded as 'balancer_v2', a base_spells_namespace set to 'balancer', and pool_labels_spell sourced from 'labels' for balancer_v2_compatible_token_balance_changes_macro.

MODEL: balancer_v2_gnosis_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: A macro balancer_v2_compatible_token_balance_changes_daily_agg_macro was added with parameters for blockchain, version, project decoding as 'balancer_v2', and base spells namespace 'balancer'.

MODEL: balancer_v2_optimism_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new macro balancer_v2_compatible_token_balance_changes_macro with additional parameters like project_decoded_as, base_spells_namespace, and pool_labels_spell. The version parameter was updated to '2'.

MODEL: balancer_v2_optimism_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: A macro balancer_v2_compatible_token_balance_changes_daily_agg_macro was added with parameters for blockchain, version, project decoding as 'balancer_v2', and base spells namespace 'balancer'.

MODEL: balancer_v2_polygon_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Changed the name of a macro from balancer_token_balance_changes_macro to balancer_v2_compatible_token_balance_changes_macro. Added parameters for project decoding, base spells namespace, and pool labels spell.

MODEL: balancer_v2_polygon_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Changed the name of a dbt macro from balancer_token_balance_changes_daily_agg_macro to balancer_v2_compatible_token_balance_changes_daily_agg_macro. Added parameters for project_decoded_as and base_spells_namespace, with corresponding values.

MODEL: balancer_v2_zkevm_token_balance_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: The balancer_token_balance_changes_macro was replaced with balancer_v2_compatible_token_balance_changes_macro. Additional parameters were added such as project_decoded_as, base_spells_namespace, and a reference to the pool labels spell.

MODEL: balancer_v2_zkevm_token_balance_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a parameter project_decoded_as with value 'balancer_v2' and base_spells_namespace with value 'balancer' to the model. The name of the macro was also changed from balancer_token_balance_changes_daily_agg_macro to balancer_v2_compatible_token_balance_changes_daily_agg_macro.

MODEL: balancer_v2_arbitrum_bpt_prices.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added parameters project_decoded_as, base_spells_namespace, and pool_labels_spell to the model. The model name was also changed from balancer_bpt_prices_macro to balancer_v2_compatible_bpt_prices_macro.

MODEL: balancer_v2_arbitrum_bpt_supply.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new macro balancer_v2_compatible_bpt_supply_macro with additional parameters like project_decoded_as, base_spells_namespace, and pool_labels_spell.

MODEL: balancer_v2_arbitrum_bpt_supply_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new parameter balancer_v2_compatible_bpt_supply_changes_macro with additional arguments such as project_decoded_as, base_spells_namespace, and pool_labels_spell.

MODEL: balancer_v2_arbitrum_bpt_supply_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: The blockchain variable was changed from 'ethereum' to 'arbitrum'. The model now uses a different macro function called balancer_v2_compatible_bpt_supply_changes_daily_agg_macro with additional parameters: project_decoded_as and base_spells_namespace.

MODEL: balancer_v2_arbitrum_transfers_bpt.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a parameter project_decoded_as with value 'balancer_v2' to the macro balancer_v2_compatible_transfers_bpt_macro. The name of the macro was also changed from balancer_transfers_bpt_macro to balancer_v2_compatible_transfers_bpt_macro, and an additional argument specifying blockchain was included.

MODEL: balancer_v2_avalanche_c_bpt_prices.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added parameters project_decoded_as, base_spells_namespace, and pool_labels_spell to the model. Changed the name of the model from balancer_bpt_prices_macro to balancer_v2_compatible_bpt_prices_macro.

MODEL: balancer_v2_avalanche_c_bpt_supply.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new macro balancer_v2_compatible_bpt_supply_macro with additional parameters like project_decoded_as, base_spells_namespace, and pool_labels_spell. The version parameter was updated to '2'.

MODEL: balancer_v2_avalanche_c_bpt_supply_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new parameter balancer_v2_compatible_bpt_supply_changes_macro with additional arguments such as project_decoded_as, base_spells_namespace, and pool_labels_spell.

MODEL: balancer_v2_avalanche_c_bpt_supply_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new parameter project_decoded_as with value 'balancer_v2' and base_spells_namespace with value 'balancer' to the model. The model name was also changed from bpt_supply_changes_daily_agg_macro to balancer_v2_compatible_bpt_supply_changes_daily_agg_macro.

MODEL: balancer_v2_avalanche_c_transfers_bpt.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new macro balancer_v2_compatible_transfers_bpt_macro with additional parameter project_decoded_as set to 'balancer_v2'.

MODEL: balancer_v2_base_bpt_prices.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added parameters for project_decoded_as, base_spells_namespace, and pool_labels_spell to the model. The model name was also changed from balancer_bpt_prices_macro to balancer_v2_compatible_bpt_prices_macro.

MODEL: balancer_v2_base_bpt_supply.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new parameter balancer_v2_compatible_bpt_supply_macro with additional arguments such as project_decoded_as, base_spells_namespace, and pool_labels_spell.

MODEL: balancer_v2_base_bpt_supply_changes.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new macro balancer_v2_compatible_bpt_supply_changes_macro with additional parameters like project_decoded_as, base_spells_namespace, and pool_labels_spell.

MODEL: balancer_v2_base_bpt_supply_changes_daily.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new parameter project_decoded_as with value 'balancer_v2' and base_spells_namespace with value 'balancer' to the dbt model. The model was also renamed from bpt_supply_changes_daily_agg_macro to balancer_v2_compatible_bpt_supply_changes_daily_agg_macro.

MODEL: balancer_v2_base_transfers_bpt.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new macro balancer_v2_compatible_transfers_bpt_macro with parameters for blockchain, version set to '2', and project_decoded_as set to 'balancer_v2'.

MODEL: balancer_v2_ethereum_bpt_prices.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added parameters for project_decoded_as, base_spells_namespace, and pool_labels_spell to the model. The model name was also updated from 'balancer_bpt_prices_macro' to 'balancer_v2_compatible_bpt_prices_macro'.

MODEL: balancer_v2_ethereum_bpt_supply.sql

🟠 Modified by:

🔧 PR: #6098, make macros balancer_compatible
🧙 Author: @viniabussafi on 2024-07-05
📝 Summary: Added a new macro balancer_v2_compatible_bpt_supply_macro with additional parameters like project_decoded_as, base_spells_namespace, and `pool_labe