📰 2024-07-12: Weekly Prophet!

[andrewhong5297]

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

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
prices	5	0	5	4
aave	1	0	11	1
compound	1	0	2	1
moola	1	0	3	1
_sector	6	17	11	2
aragon	1	2	1	1
dao	1	2	3	1
models	2	0	4	2
lido	1	0	1	1
macros	1	0	2	1
cow_protocol	1	0	1	1

SECTOR: prices

toggle to see all model updates

MODEL: prices_ethereum_tokens.sql

🟠 Modified by:

🔧 PR: #6349, Added wbeth
🧙 Author: @IrishLatte19 on 2024-07-11
📝 Summary: WBETH

MODEL: prices_arbitrum_tokens.sql

🟠 Modified by:

🔧 PR: #6341, Add SX ZRO token prices
🧙 Author: @MustafaBrandon on 2024-07-11
📝 Summary: OLAS, SX, ZRO

🔧 PR: #6341, add missing tokens on prices.usd and tokens.erc20
🧙 Author: @viniabussafi on 2024-07-08
📝 Summary: The token symbols that were added or removed are: OLAS

MODEL: prices_scroll_tokens.sql

🟠 Modified by:

🔧 PR: #6350, Raho1 scroll prices update 1
🧙 Author: @raho1 on 2024-07-11
📝 Summary: The token symbols that were added are: weETH

MODEL: prices_base_tokens.sql

🟠 Modified by:

🔧 PR: #6241, add aura on base to prices.usd
🧙 Author: @viniabussafi on 2024-07-08
📝 Summary: The tokens that were added or removed are: BET, AURA

SECTOR: aave

toggle to see all model updates

MODEL: aave_arbitrum_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a reference to the amount_usd column and removed an alias for it.

MODEL: aave_avalanche_c_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a reference to the amount_usd column and removed an alias for it.

MODEL: aave_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a reference to the amount_usd column and renamed it as amount_usd.

MODEL: aave_ethereum_borrow.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a column named amount_usd and removed a column named usd_amount.

MODEL: aave_ethereum_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: The diff shows that the alias 'amount_usd' was removed and instead, the column 'amount_usd' is now directly selected. No other changes were made in this SQL model.

MODEL: aave_ethereum_supply.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a column 'amount_usd' and removed a column 'usd_amount' from the SQL model.

MODEL: aave_fantom_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: The diff shows that the alias 'amount_usd' was removed from the column 'usd_amount' and added to the column 'amount_usd'. No other significant changes were made.

MODEL: aave_optimism_borrow.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a column named 'amount_usd' and removed a column named 'usd_amount'.

MODEL: aave_optimism_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: The diff shows that the alias 'amount_usd' was removed and instead, the column 'amount_usd' is directly selected. No other significant changes were made in this SQL model.

MODEL: aave_optimism_supply.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a column 'amount_usd' and removed a column 'usd_amount' from the SQL model.

MODEL: aave_polygon_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: The diff shows that the alias 'amount_usd' was removed and replaced with just 'amount_usd'.

SECTOR: compound

toggle to see all model updates

MODEL: compound_ethereum_borrow.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a column 'amount_usd' and removed a column 'usd_amount' from the SQL model.

MODEL: compound_ethereum_supply.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a column named amount_usd and removed a column named usd_amount.

SECTOR: moola

toggle to see all model updates

MODEL: moola_celo_borrow.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: Added a column named amount_usd and removed a column named usd_amount.

MODEL: moola_celo_flashloans.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: The diff shows that the alias 'amount_usd' was removed and instead, the column 'amount_usd' is now directly selected.

MODEL: moola_celo_supply.sql

🟠 Modified by:

🔧 PR: #6364, fix downstream amount_usd for lending
🧙 Author: @jeff-dude on 2024-07-12
📝 Summary: A column named usd_amount was removed and a new column named amount_usd was added to the SQL model.

SECTOR: _sector

toggle to see all model updates

MODEL: lending_arbitrum_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: One model reference was removed ('granary_arbitrum_base_flashloans') and two model references were added ('granary_arbitrum_base_flashloans' and 'balancer_v2_arbitrum_base_flashloans').

MODEL: balancer_v2_arbitrum_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that tracks flash loan events on the Balancer v2 project in the Arbitrum blockchain. It includes details such as recipient, amount, fee, token address, project contract address, block time and number, transaction hash and index. This enables data analysts to analyze flash loan activities within Balancer v2 on the Arbitrum blockchain at a monthly level.

MODEL: lending_avalanche_c_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: A reference to a model named 'balancer_v2_avalanche_c_base_flashloans' was added to the list of models.

MODEL: balancer_v2_avalanche_c_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that tracks flash loan events on the Avalanche blockchain for the Balancer v2 project. It includes details such as recipient, amount, fee, token address, project contract address, block time and number, transaction hash and index. This data enables analysts to analyze flash loan activities within the Balancer protocol on Avalanche over time.

MODEL: lending_base_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: One model reference was removed ('granary_base_base_flashloans') and two model references were added ('granary_base_base_flashloans' and 'balancer_v2_base_base_flashloans').

MODEL: balancer_v2_base_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This SQL model creates a dataset that tracks flash loan events in the Balancer V2 project on the blockchain. It includes details such as recipient, amount, fee, token address, project contract address, block month and time, transaction hash and index. This model enables data analysts to analyze and monitor flash loan activities within the Balancer V2 project for insights and reporting purposes.

MODEL: lending_ethereum_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6359, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: A reference to a new model called 'balancer_v2_ethereum_base_flashloans' was added alongside existing references in the dbt SQL model.

🔧 PR: #6359, add morpho flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: A new reference to 'morpho_ethereum_base_flashloans' was added, while the reference to 'granary_ethereum_base_flashloans' was removed.

MODEL: balancer_v2_ethereum_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that tracks flash loan events on the Balancer v2 project in the Ethereum blockchain. It includes details such as recipient, amount, fee, token address, project contract address, block time and number, transaction hash and index. This enables data analysts to analyze and monitor flash loan activities within the Balancer v2 ecosystem on Ethereum at a monthly level.

MODEL: lending_gnosis_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: A reference to 'balancer_v2_gnosis_base_flashloans' was added, and a reference to 'realt_rmm_v2_gnosis_base_flashloans' was removed from the list of models being referenced.

MODEL: balancer_v2_gnosis_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that tracks flash loan events on the Balancer V2 project using Gnosis blockchain. It includes details such as recipient, amount, fee, token address, project contract address, block time and number, transaction hash and index. This enables data analysts to analyze and monitor flash loan activities within the Balancer V2 ecosystem on the Gnosis blockchain at a monthly level.

MODEL: lending_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: Added a reference to 'lending_zkevm_base_flashloans' and removed a reference to 'lending_scroll_base_flashloans'.

MODEL: lending_optimism_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: A reference to a model named 'balancer_v2_optimism_base_flashloans' was added, while a reference to a model named 'granary_optimism_base_flashloans' was removed from the list of models.

MODEL: balancer_v2_optimism_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This SQL model creates a dataset that tracks flash loan events on the Balancer v2 project deployed on the Optimism blockchain. It includes details such as recipient, amount, fee, token address, project contract address, block time and number, transaction hash and index. This model enables data analysts to analyze flash loan activities specifically within the Balancer v2 project on the Optimism blockchain at a monthly level.

MODEL: lending_polygon_base_flashloans.sql

🟠 Modified by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: A reference to a model named 'balancer_v2_polygon_base_flashloans' was added, while a reference to a model named 'aave_v3_polygon_base_flashloans' was removed.

MODEL: balancer_v2_polygon_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that tracks flash loan events on the Balancer v2 protocol on the Polygon blockchain. It includes details such as recipient, amount, fee, token address, project contract address, block time and number, transaction hash and index. This enables data analysts to analyze and monitor flash loan activities specifically within the Balancer v2 project on Polygon for various insights or reporting purposes.

MODEL: lending_zkevm_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This SQL model creates a unified view of data related to flashloans in the balancer_v2_zkevm_base_flashloans table. It enables data analysts to easily access and analyze information such as blockchain, project, version, recipient, amount, fee, token address, project contract address, block details (month/time/number), transaction hash (tx_hash), and event index (evt_index) for further analysis or reporting.

MODEL: balancer_v2_zkevm_base_flashloans.sql

🟢 Added by:

🔧 PR: #6331, Add balancer v2 to lending.flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This SQL model creates a dataset that includes information about flash loans in the Balancer v2 project on the ZK-EVM blockchain. It provides details such as recipient, amount, fee, token address, project contract address, block month and time, block number, transaction hash (tx_hash), and event index. This model enables data analysts to analyze and track flash loan activities within the specified parameters on this specific blockchain platform.

MODEL: morpho_ethereum_base_flashloans.sql

🟢 Added by:

🔧 PR: #6359, add morpho flashloans
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that tracks Ethereum blockchain transactions related to the Morpho project, specifically focusing on flash loans. It includes information such as recipient, amount of assets involved, fees, token addresses, contract addresses, block timestamps and numbers, transaction hashes and indexes. This data enables analysts to analyze flash loan activities within the Morpho project on the Ethereum blockchain at a monthly level.

MODEL: lending_ethereum_base_supply.sql

🟠 Modified by:

🔧 PR: #6360, add morpho supply
🧙 Author: @hildobby on 2024-07-12
📝 Summary: A reference to a model named 'granary_ethereum_base_supply' was removed, and references to models named 'granary_ethereum_base_supply' and 'morpho_ethereum_base_supply' were added.

MODEL: morpho_ethereum_base_supply.sql

🟢 Added by:

🔧 PR: #6360, add morpho supply
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that enables data analysts to track deposit, withdrawal, and liquidation transactions on the Ethereum blockchain for a specific project. It includes information such as token addresses, transaction types, amounts deposited or withdrawn, block timestamps and numbers, contract addresses involved in the transactions. The model also links these transactions to market parameters like loan tokens and collateral tokens through joins with another table called 'markets.'

MODEL: lending_ethereum_base_borrow.sql

🟠 Modified by:

🔧 PR: #6358, add morpho blue to lending sector
🧙 Author: @hildobby on 2024-07-12
📝 Summary: One reference to a model named 'granary_ethereum_base_borrow' was removed, and two references were added: 'granary_ethereum_base_borrow' and 'morpho_ethereum_base_borrow'.

MODEL: morpho_ethereum_base_borrow.sql

🟢 Added by:

🔧 PR: #6358, add morpho blue to lending sector
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a dataset that tracks borrowing, repaying, and liquidation transactions in the Ethereum blockchain for a specific project. It includes details such as transaction type, loan type, token addresses involved, borrower information, amounts transacted, timestamps of blocks processed by month and time of block creation. This enables data analysts to analyze lending activities within the project on Ethereum blockchain at a granular level.

MODEL: lending_info.sql

🟢 Added by:

🔧 PR: #6333, Create lending.info
🧙 Author: @hildobby on 2024-07-12
📝 Summary: This model creates a table with information about various projects in the crypto space, including their names, whether they have flash loans enabled, and their corresponding usernames. This enables data analysts to easily access and analyze data related to these projects for further insights or reporting purposes.

MODEL: tokens_linea_balances.sql

🟢 Added by:

🔧 PR: #6357, Linea balances tables
🧙 Author: @couralex6 on 2024-07-12
📝 Summary: This SQL model creates a new table that enriches raw balance data from the 'tokens_linea' source, enabling data analysts to work with enhanced balance information for further analysis.

MODEL: tokens_linea_balances_daily.sql

🟢 Added by:

🔧 PR: #6357, Linea balances tables
🧙 Author: @couralex6 on 2024-07-12
📝 Summary: This SQL model creates a table called balances_daily that aggregates daily token balances starting from July 1, 2023, specifically for the native token ETH. This enables data analysts to easily access and analyze aggregated daily balance information for ETH tokens.

MODEL: tokens_linea_balances_daily_agg.sql

🟢 Added by:

🔧 PR: #6357, Linea balances tables
🧙 Author: @couralex6 on 2024-07-12
📝 Summary: This model creates an enriched version of daily token balances by aggregating and transforming raw balance data. It enables data analysts to easily access and analyze more comprehensive information about token balances on a daily basis.

MODEL: tokens_linea_balances_daily_agg_base.sql

🟢 Added by:

🔧 PR: #6357, Linea balances tables
🧙 Author: @couralex6 on 2024-07-12
📝 Summary: This SQL model creates a new table that aggregates daily balances data. It enables data analysts to easily access and analyze summarized balance information on a daily basis, providing valuable insights into the financial status over time.

SECTOR: aragon

toggle to see all model updates

MODEL: aragon_dao_addresses.sql

🟠 Modified by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: A reference to a new dbt SQL model called 'aragon_zksync_dao_addresses' was added.

MODEL: aragon_zksync_app_dao_addresses.sql

🟢 Added by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: This model creates a dataset that includes information about DAOs created using the Aragon platform on the zkSync blockchain. It captures details such as DAO name, wallet address, creation date, and related product information. The model allows data analysts to track and analyze the creation of DAOs on zkSync starting from a specified project start date.

MODEL: aragon_zksync_dao_addresses.sql

🟢 Added by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: This model creates a unified view of DAO addresses and related information from different sources. It enables data analysts to easily analyze and compare data across multiple DAOs, including blockchain details, creation dates, and associated products.

SECTOR: dao

toggle to see all model updates

MODEL: dao_addresses.sql

🟠 Modified by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: A reference to a new dbt SQL model called 'dao_addresses_zksync' was added.

MODEL: dao_addresses_zksync.sql

🟢 Added by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: This SQL model combines data from different DAO address models into a single dataset. It allows data analysts to easily access and analyze information such as blockchain, DAO creator tool, wallet addresses, creation dates, and more across multiple DAOs. This consolidation simplifies querying and reporting on various aspects of decentralized autonomous organizations for deeper insights.

MODEL: dao_balances.sql

🟠 Modified by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: The change involves adding 'zksync' to the list of blockchain values in a filter condition.

MODEL: dao_transactions.sql

🟠 Modified by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: A reference to a new model dao_transactions_zksync_erc20 was added in the SQL query.

MODEL: dao_transactions_zksync_erc20.sql

🟢 Added by:

🔧 PR: #6300, Add Aragon Zksync to DAO Spells - Ready for review
🧙 Author: @henrystats on 2024-07-12
📝 Summary: This model creates a dataset that combines information about transactions involving DAO wallets with token details and pricing data. It enables data analysts to analyze transaction values in both the native token and USD, track interactions between addresses, and understand the value of assets transferred within a specified time frame.

SECTOR: models

toggle to see all model updates

MODEL: jupiter_solana_aggregator_swaps.sql

🟠 Modified by:

🔧 PR: #6297, move jupiter out of dex directory
🧙 Author: @0xRobin on 2024-07-12
📝 Summary: [changes too large] The model jupiter_solana_aggregator_swaps.sql was renamed.

MODEL: jupiter_solana_perp_events.sql

🟠 Modified by:

🔧 PR: #6297, move jupiter out of dex directory
🧙 Author: @0xRobin on 2024-07-12
📝 Summary: [changes too large] The model jupiter_solana_perp_events.sql was renamed.

MODEL: jupiter_solana_schema.yml

🟠 Modified by:

🔧 PR: #6297, move jupiter out of dex directory
🧙 Author: @0xRobin on 2024-07-12
📝 Summary: [changes too large] The model jupiter_solana_schema.yml was renamed.

MODEL: chainlink_ethereum_price_feeds_oracle_addresses.sql

🟠 Modified by:

🔧 PR: #6326, Additional chainlink ethereum price feeds oracle addresses
🧙 Author: @dylanuma on 2024-07-11
📝 Summary: [changes too large] The model chainlink_ethereum_price_feeds_oracle_addresses.sql was modified.

SECTOR: lido

toggle to see all model updates

MODEL: lido_accounting_ethereum_other_expenses.sql

🟠 Modified by:

🔧 PR: #6346, Lido accounting stonks update
🧙 Author: @ppclunghe on 2024-07-12
📝 Summary: [changes too large] The model lido_accounting_ethereum_other_expenses.sql was modified.

SECTOR: macros

toggle to see all model updates

MODEL: erc4337_account_deployed.sql

🟠 Modified by:

🔧 PR: #6356, move account abstraction macros, add distinct fix on userops basics spells
🧙 Author: @jeff-dude on 2024-07-11
📝 Summary: [changes too large] The model erc4337_account_deployed.sql was renamed.

MODEL: erc4337_userops_enrichments.sql

🟠 Modified by:

🔧 PR: #6356, move account abstraction macros, add distinct fix on userops basics spells
🧙 Author: @jeff-dude on 2024-07-11
📝 Summary: [changes too large] The model erc4337_userops_enrichments.sql was renamed.

SECTOR: cow_protocol

toggle to see all model updates

MODEL: cow_protocol_gnosis_solvers.sql

🟠 Modified by:

🔧 PR: #6322, [CoW Protocol] Add Fractal Solver on Gnosis Chain
🧙 Author: @harisang on 2024-07-11
📝 Summary: Two new entries were added to the known_solver_metadata model for addresses associated with 'FractalSolver' in different environments ('barn' and 'prod').