📰 2024-02-09: Weekly Prophet!

[andrewhong5297]

This is your weekly summary of 17 PRs merged from 10 wizards. Great job everyone! 🎉
We had 15 added models 🟢 and 27 modified models 🟠 for 9 Sectors.

Sector	🔧 # PRs	🟢 # Added	🟠 # Modified	🧙 # Authors
dex	2	0	2	2
labels	1	0	1	1
prices	1	0	1	1
_sector	11	4	21	7
sonne_finance	1	2	0	1
balancer	1	0	1	1
odos	1	2	1	1
ajna	1	6	0	1
moonwell	1	1	0	1

SECTOR: dex

toggle to see all model updates

MODEL: dex_raw_pool_creations.sql

🟠 Modified by:

🔧 PR: #5308, Fix dex trades
🧙 Author: @aalan3 on 2024-02-07
📝 Summary: The main logic added in this SQL model is the implementation of pools on different blockchains. The list of blockchains includes Ethereum, Polygon, BNB, Avalanche C-Chain, Gnosis, Fantom, Optimism, Arbitrum and Celo. There is also a TODO comment to implement Mento pools on Celo in the future. Additionally, there are some queries and joins related to pool creation logs and traces for incremental updates.

MODEL: dex_info.sql

🟠 Modified by:

🔧 PR: #5282, Added gridex dex to dex.trades
🧙 Author: @ARDev097 on 2024-02-02
📝 Summary: In this SQL model, a new row has been added to the temporary table. The row represents a project named 'gridex' with the corresponding name 'Gridex', marketplace type 'Direct', and x_username as 'GridexProtocol'.

SECTOR: labels

toggle to see all model updates

MODEL: labels_bridges_ethereum.sql

🟠 Modified by:

🔧 PR: #5294, Add OptimismPortal Bridge Label
🧙 Author: @MSilb7 on 2024-02-06
📝 Summary: In this diff, a new row is added to the SQL model. The row includes information about an Ethereum bridge called 'Optimism: OptimismPortal' with its corresponding details such as address, category, contributor, source, created_at date and updated_at timestamp. No rows were removed in this diff.

SECTOR: prices

toggle to see all model updates

MODEL: prices_bnb_tokens.sql

🟠 Modified by:

🔧 PR: #5296, Adding 2 tokens to prices_bnb_tokens.sql and prices_polygon_tokens.sql
🧙 Author: @leopk-code on 2024-02-06
📝 Summary: RB,

SECTOR: _sector

toggle to see all model updates

MODEL: lending_base_base_borrow.sql

🟠 Modified by:

🔧 PR: #5274, Add sonne_finance to lending
🧙 Author: @tomfutago on 2024-02-09
📝 Summary: In this diff, the model is being modified to include a new reference to 'sonne_finance_base_base_borrow' while removing the reference to 'moonwell_base_base_borrow'.

🔧 PR: #5274, Add moonwell to lending
🧙 Author: @tomfutago on 2024-02-02
📝 Summary: In this diff, the model 'seamlessprotocol_base_base_borrow' was removed and two models, 'seamlessprotocol_base_base_borrow' and 'moonwell_base_base_borrow', were added.

MODEL: lending_optimism_base_borrow.sql

🟠 Modified by:

🔧 PR: #5287, Add sonne_finance to lending
🧙 Author: @tomfutago on 2024-02-09
📝 Summary: In this diff, a new reference to the model 'sonne_finance_optimism_base_borrow' was added alongside the existing reference to 'aave_v3_optimism_base_borrow'.

MODEL: lending_base_base_supply.sql

🟠 Modified by:

🔧 PR: #5274, Add sonne_finance to lending
🧙 Author: @tomfutago on 2024-02-09
📝 Summary: In this diff, the model is updated to include a new reference to 'sonne_finance_base_base_supply' while removing the reference to 'moonwell_base_base_supply'.

🔧 PR: #5274, Add moonwell to lending
🧙 Author: @tomfutago on 2024-02-02
📝 Summary: In this diff, a new reference to the model 'moonwell_base_base_supply' was added.

MODEL: lending_optimism_base_supply.sql

🟠 Modified by:

🔧 PR: #5287, Add sonne_finance to lending
🧙 Author: @tomfutago on 2024-02-09
📝 Summary: In this SQL model, a reference to the 'aave_v3_optimism_base_supply' model was added and another reference to the 'sonne_finance_optimism_base_supply' model was also added.

MODEL: tokens_ethereum_balances.sql

🟠 Modified by:

🔧 PR: #5315, Bump etheruem balances to 0004
🧙 Author: @aalan3 on 2024-02-08
📝 Summary: The main logic of the diff is that the source table for balances_base in the balances_enrich model was changed from 'balances_ethereum_0002' to 'balances_ethereum_0004'. This change updates the data source used for calculating balances on Ethereum blockchain.

MODEL: lending_base_borrow.sql

🟠 Modified by:

🔧 PR: #5288, lending_base incremental & moonwell ctokens fix
🧙 Author: @tomfutago on 2024-02-06
📝 Summary: In this SQL model, an incremental predicate was added to the unique key. The models 'lending_gnosis_base_borrow' and 'lending_zksync_base_borrow' were also added as references. Additionally, a conditional statement was included to filter results based on the incremental predicate if it is an incremental run.

MODEL: lending_base_flashloans.sql

🟠 Modified by:

🔧 PR: #5288, lending_base incremental & moonwell ctokens fix
🧙 Author: @tomfutago on 2024-02-06
📝 Summary: In this SQL model, an incremental predicate was added to the unique key. Additionally, a reference to 'lending_zksync_base_flashloans' was added while the reference to 'lending_gnosis_base_flashloans' was removed. If the model is incremental, it will include a filter on block_time in the select statement.

MODEL: lending_base_supply.sql

🟠 Modified by:

🔧 PR: #5288, lending_base incremental & moonwell ctokens fix
🧙 Author: @tomfutago on 2024-02-06
📝 Summary: The main logic added in this diff is the inclusion of an incremental predicate in the SQL model. This predicate filters the data based on a condition involving the 'block_time' column. If the model is being run incrementally, it will add a WHERE clause to filter rows based on this condition.

MODEL: dex_arbitrum_base_trades.sql

🟠 Modified by:

🔧 PR: #5282, Add zigzag_arbitrum_base_trades into dex.trades_beta
🧙 Author: @Hosuke on 2024-02-02
📝 Summary: The line ref('zigzag_arbitrum_base_trades') was added to the SQL model.

🔧 PR: #5282, Added gridex dex to dex.trades
🧙 Author: @ARDev097 on 2024-02-02
📝 Summary: The model added a reference to 'gridex_arbitrum_base_trades' in the list of referenced models.

MODEL: zigzag_arbitrum_base_trades.sql

🟢 Added by:

🔧 PR: #5279, Add zigzag_arbitrum_base_trades into dex.trades_beta
🧙 Author: @Hosuke on 2024-02-02
📝 Summary: This SQL model creates a dataset that provides information about transactions in the Zigzag project on the Arbitrum blockchain. It includes details such as block time, block number, token amounts bought and sold, addresses of tokens involved, user IDs of taker and maker, project contract address, transaction hash, and event index. This dataset enables data analysts to analyze trading activity within the Zigzag project on Arbitrum.

MODEL: contracts_contract_overrides.sql

🟠 Modified by:

🔧 PR: #5204, Fix Circle Typo
🧙 Author: @MSilb7 on 2024-02-06
📝 Summary: In this diff of the SQL model, a line was removed that had the address (0xd9aAEc86B65D86f6A7B5B1b0c42FFA531710b6CA, 'Ciircle', 'USDbC') and it was replaced with a new line containing the address (0xd9aAEc86B65D86f6A7B5B1b0c42FFA531710b6CA, 'Circle', 'USDbC').

🔧 PR: #5204, Contracts Static Updates
🧙 Author: @MSilb7 on 2024-02-02
📝 Summary: A new line was added to the SQL model that includes a contract address (0xd9aAEc86B65D86f6A7B5B1b0c42FFA531710b6CA), along with corresponding labels ('Ciircle' and 'USDbC'). This addition is related to the 'Base' category.

MODEL: dex_avalanche_c_base_trades.sql

🟠 Modified by:

🔧 PR: #5280, Add hashflow_*.base_trades into dex.trades_beta
🧙 Author: @Hosuke on 2024-02-02
📝 Summary: The line ref('hashflow_avalanche_c_base_trades') was added to the SQL model.

MODEL: hashflow_avalanche_c_base_trades.sql

🟢 Added by:

🔧 PR: #5280, Add hashflow_*.base_trades into dex.trades_beta
🧙 Author: @Hosuke on 2024-02-02
📝 Summary: This SQL model creates a table that combines trade data from multiple sources in the hashflow_avalanche_c database. It includes information such as block time, taker and maker addresses, token amounts bought and sold, project contract address, transaction hash, and event index. This model enables data analysts to analyze trade activity on the Avalanche blockchain for the Hashflow project.

MODEL: dex_bnb_base_trades.sql

🟠 Modified by:

🔧 PR: #5280, Add hashflow_*.base_trades into dex.trades_beta
🧙 Author: @Hosuke on 2024-02-02
📝 Summary: In this diff, a reference to the 'hashflow_bnb_base_trades' table was added to the SQL model.

MODEL: hashflow_bnb_base_trades.sql

🟢 Added by:

🔧 PR: #5280, Add hashflow_*.base_trades into dex.trades_beta
🧙 Author: @Hosuke on 2024-02-02
📝 Summary: This SQL model creates a view called 'dexs' that combines data from multiple tables related to trading events in the hashflow_bnb project. It selects specific columns from each table and applies filters based on the start date of the project. The final query then retrieves various attributes related to trades, such as block time, token amounts, addresses, taker/maker information, contract address, transaction hash, and event index.

MODEL: dex_trades_beta.sql

🟠 Modified by:

🔧 PR: #5271, handle unique decimal logic for curve in dex.trades_beta
🧙 Author: @jeff-dude on 2024-02-02
📝 Summary: The main logic that was added in this SQL model is the creation of two CTEs (Common Table Expressions) named 'curve' and 'dexs'. The 'curve' CTE uses the macro enrich_curve_dex_trades to enrich base trades from a specific project called 'curve'. It also joins with other tables like tokens_erc20_model and prices_model. The 'dexs' CTE uses the macro enrich_dex_trades to enrich base trades from projects other than 'curve'. Finally, it selects all columns from both CTEs using UNION ALL.

MODEL: curvefi_ethereum_base_trades.sql

🟠 Modified by:

🔧 PR: #5271, handle unique decimal logic for curve in dex.trades_beta
🧙 Author: @jeff-dude on 2024-02-02
📝 Summary: In this SQL model, a new column called 'swap_type' has been added to the SELECT statement. This column is unique to the 'curve' in dex lineage and will be used downstream in the enrichment phase to calculate amount/amount_usd.

MODEL: curvefi_optimism_base_trades.sql

🟠 Modified by:

🔧 PR: #5271, handle unique decimal logic for curve in dex.trades_beta
🧙 Author: @jeff-dude on 2024-02-02
📝 Summary: In this SQL model, the following changes were made:

• The columns 'blockchain', 'project', 'version' were added with their respective values.
• The function CAST was used to convert the block_time column into date format for block_date and block_month.
• Additional columns pool_type and bought_id were added.

MODEL: contracts_contract_creator_address_list.sql

🟠 Modified by:

🔧 PR: #5275, Contracts Static Updates
🧙 Author: @MSilb7 on 2024-02-02
📝 Summary: The added logic in the SQL model includes inserting new values into the 'curated_list' common table expression. Several addresses and corresponding names were added, including 'Wormhole', 'Circle', 'Cross Inscriptions', 'Chainlink', 'Coinbase Verifications', 'Symmio', 'Socket' and others. Additionally, new entries for TreasureDAO and SmolBrains were inserted with their respective addresses.

🔧 PR: #5275, Adding contract creator addresses on Base
🧙 Author: @chain-l on 2024-02-02
📝 Summary: The diff of the SQL model shows that several new entries were added to the 'curated_list' CTE. These entries include various addresses and corresponding names for different farms, swaps, and finance platforms such as 'Based Farm,' 'Redemption Finance,' 'PlantBaseSwap,' and others. Additionally, a comment was added with a link to an external resource related to MEV (Miner Extractable Value) analysis.

MODEL: gridex_arbitrum_base_trades.sql

🟢 Added by:

🔧 PR: #5282, Added gridex dex to dex.trades
🧙 Author: @ARDev097 on 2024-02-02
📝 Summary: This dbt SQL model creates a table called 'uniswap_compatible_v3_trades' that enables data analysts to analyze and query Uniswap V3 trades on the Arbitrum blockchain for the Gridex project. It combines data from two sources, 'Grid_evt_Swap' and 'GridFactory_evt_GridCreated', using specified column names for taker, maker, and pair information. The optional_columns parameter is not used in this model.

SECTOR: sonne_finance

toggle to see all model updates

MODEL: sonne_finance_base_ctokens.sql

🟢 Added by:

🔧 PR: #5287, Add sonne_finance to lending
🧙 Author: @tomfutago on 2024-02-09
📝 Summary: This SQL model creates a result set that includes the asset symbol, ctoken address, and asset address for various assets such as DAI, USDC, USDbC, WETH, and cbETH. It enables data analysts to easily access this information for further analysis or reporting purposes.

MODEL: sonne_finance_optimism_ctokens.sql

🟢 Added by:

🔧 PR: #5287, Add sonne_finance to lending
🧙 Author: @tomfutago on 2024-02-09
📝 Summary: This SQL model creates a table that includes the asset symbol, ctoken address, and asset address for various assets such as DAI, LUSD, MAI, OP, SNX, USDC, USDT,WBTC,WETH,sUSD,and wstETH. This enables data analysts to easily access and analyze information related to these assets in their queries.

SECTOR: balancer

toggle to see all model updates

MODEL: balancer_v2_arbitrum_bpt_supply.sql

🟠 Modified by:

🔧 PR: #5304, [easy] Balancer schema names fix
🧙 Author: @viniabussafi on 2024-02-06
📝 Summary: The variable blockchain is set to the value 'arbitrum'.

SECTOR: odos

toggle to see all model updates

MODEL: odos_optimism_trades.sql

🟠 Modified by:

🔧 PR: #5267, Added odos_v2 optimism dex
🧙 Author: @ARDev097 on 2024-02-02
📝 Summary: The main logic added in this SQL model is the ability to select data from multiple models using a loop. The loop iterates over the odos_models list and selects data from each model using a UNION ALL statement. The selected columns include blockchain, project, version, block_month, block_date, block_time, token_bought_symbol, token_sold_symbol and more.

MODEL: odos_v1_optimism_trades.sql

🟢 Added by:

🔧 PR: #5267, Added odos_v2 optimism dex
🧙 Author: @ARDev097 on 2024-02-02
📝 Summary: This SQL model creates a table that combines data from multiple sources to analyze transactions on the Odos project in the Optimism blockchain. It includes information such as block date, token symbols, token amounts, USD value, addresses involved in the transaction, and more. The model enables data analysts to perform various analyses and calculations on these transaction records for reporting and insights.

MODEL: odos_v2_optimism_trades.sql

🟢 Added by:

🔧 PR: #5267, Added odos_v2 optimism dex
🧙 Author: @ARDev097 on 2024-02-02
📝 Summary: This SQL model creates a dataset that enables data analysts to analyze swap events on the Odos project in the Optimism blockchain. It includes information such as block number, block time, taker and maker addresses, token bought and sold amounts (both raw and converted), USD value of the transaction, token addresses involved in the swap, project contract address, transaction hash, sender and receiver addresses. The model also joins with other tables to retrieve additional information like token symbols and prices.

SECTOR: ajna

toggle to see all model updates

MODEL: ajna_erc20_pools.sql

🟢 Added by:

🔧 PR: #5249, Ajna ERC20 Pools
🧙 Author: @gunboatsss on 2024-02-02
📝 Summary: This SQL model creates a view that combines data from multiple Ajna ERC20 pool tables. It includes information such as blockchain, version, collateral and quote tokens, pool address, name of the pool, symbols and decimals of the collateral and quote tokens, starting interest rate, transaction hash, block time and number. It also performs left joins with an ERC20 token source table to retrieve additional token information. This model enables data analysts to easily query and analyze aggregated data from different Ajna ERC20 pools across various blockchains.

MODEL: ajna_arbitrum_erc20_pools.sql

🟢 Added by:

🔧 PR: #5249, Ajna ERC20 Pools
🧙 Author: @gunboatsss on 2024-02-02
📝 Summary: This SQL model creates a dataset that includes information about pools created on the Arbitrum blockchain. It retrieves data such as the blockchain name, version, collateral type, quote currency, pool address, starting interest rate (converted to decimal), transaction hash and block details. The model joins two sources of data related to pool creation events and filters based on incremental updates if applicable. This enables data analysts to analyze and track pools created on the Arbitrum blockchain over time.

MODEL: ajna_base_erc20_pools.sql

🟢 Added by:

🔧 PR: #5249, Ajna ERC20 Pools
🧙 Author: @gunboatsss on 2024-02-02
📝 Summary: This SQL model creates a query that retrieves data from the 'ajna_base' database. It selects various columns such as blockchain, version, collateral, quote, pool address, starting interest rate and block information. The query joins two tables based on matching transaction hashes and pool addresses. If the model is run incrementally (i.e., with new data), it applies a filter based on the block time column to only retrieve updated records.

MODEL: ajna_ethereum_erc20_pools.sql

🟢 Added by:

🔧 PR: #5249, Ajna ERC20 Pools
🧙 Author: @gunboatsss on 2024-02-02
📝 Summary: This SQL model creates a dataset that includes information about Ethereum blockchain contracts. It retrieves data such as the blockchain name, contract version, collateral and quote values, pool address, starting interest rate, transaction hash and block details. The model joins two sources of data related to ERC20PoolFactory events and filters the results based on incremental predicates if applicable. This enables data analysts to analyze Ethereum contract activity and track changes over time.

MODEL: ajna_optimism_erc20_pools.sql

🟢 Added by:

🔧 PR: #5249, Ajna ERC20 Pools
🧙 Author: @gunboatsss on 2024-02-02
📝 Summary: This SQL model creates a dataset that includes information about blockchain contracts, versions, collateral, quotes, pool addresses, starting interest rates, transaction hashes and block details. It joins data from two sources and applies an incremental predicate if specified. This model enables data analysts to analyze and track various metrics related to the Optimism blockchain contracts.

MODEL: ajna_polygon_erc20_pools.sql

🟢 Added by:

🔧 PR: #5249, Ajna ERC20 Pools
🧙 Author: @gunboatsss on 2024-02-02
📝 Summary: This SQL model creates a dataset that includes information about blockchain pools. It retrieves data such as the blockchain type, version, collateral and quote currencies, pool address, starting interest rate, transaction hash and block details. The model joins two sources of data related to pool creation events and deploys them into a single table. If the query is run incrementally (i.e., only retrieving new or updated records), it filters based on the block time predicate provided.

SECTOR: moonwell

toggle to see all model updates

MODEL: moonwell_base_ctokens.sql

🟢 Added by:

🔧 PR: #5274, Add moonwell to lending
🧙 Author: @tomfutago on 2024-02-02
📝 Summary: This SQL model creates a table that includes the asset symbol, ctoken address, and asset address for various assets such as WETH, cbETH, USDC, DAI, wstETH, rETH and USDbC. This enables data analysts to easily access this information for analysis purposes.