📰 2024-03-15: Weekly Prophet! #5609
andrewhong5297
announced in
Prophet (Weekly Updates)
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
This is your weekly summary of 55 PRs merged from 25 wizards. Great job everyone! 🎉
We had 49 added models 🟢 and 174 modified models 🟠 for 18 Sectors.
SECTOR: dex
toggle to see all model updates
MODEL: dex_info.sql
🟠 Modified by:
🔧 PR: #5476, Remove duped record in dex.info
🧙 Author: @Hosuke on 2024-03-14
📝 Summary: A row with the project name 'SyncSwap' was removed from the temporary table.
🔧 PR: #5476, Add Mute to
dex.tradesfor zkSync Era🧙 Author: @tomfutago on 2024-03-14
📝 Summary: A new row for the project 'mute' with corresponding values for name, marketplace_type, and x_username was added to the temporary table.
🔧 PR: #5476, ADDED BASO FINANCE (BASE) TO DEX.TRADES
🧙 Author: @sophie-analytics on 2024-03-13
📝 Summary: Added new entries for projects 'wombatexchange', 'baso_finance', 'syncswap' and a duplicate entry for project 'SyncSwap'.
MODEL: dex_raw_pool_creations.sql
🟠 Modified by:
🔧 PR: #5503, add back '1inch: updates 17 (#5503)'
🧙 Author: @jeff-dude on 2024-03-14
📝 Summary: Added logic for different types of pools with their corresponding versions, tokens positions, and counts. Implemented the creation of logs for Uniswap and Curve compatible pools. Updated the pool_created_logs query to include data from uniswap_pool_created_logs and curve_base_pool_created_calls tables. Replaced _optimism_ovm1_legacy with _uniswap_optimism_ovm1_legacy in the union all statement within t as subquery.
🔧 PR: #5503, Revert '1inch: updates 17 (#5503)'
🧙 Author: @jeff-dude on 2024-03-13
📝 Summary: Removed hardcoded legacy pools for Optimism blockchain and replaced it with a more general logic. Removed a section related to pool creation logs from different blockchains and combined it with the uniswap pool creation logs.
🔧 PR: #5503, 1inch: updates 17
🧙 Author: @max-morrow on 2024-03-13
📝 Summary: Added logic for different types of curve-compatible pools with their respective versions, tokens positions, and token counts. Implemented a new pool_created_logs CTE to select data from uniswap_pool_created_logs and curve_base_pool_created_calls tables. Renamed _optimism_ovm1_legacy CTE to _uniswap_optimism_ovm1_legacy. Added an array column for tokens in the pool creation logs table along with some additional columns like block_time, block_number, contract_address, and tx_hash.
MODEL: dex_raw_pool_initializations.sql
🟠 Modified by:
🔧 PR: #5503, add back '1inch: updates 17 (#5503)'
🧙 Author: @jeff-dude on 2024-03-14
📝 Summary: Added a condition to restrict re-initialization only for 'uni v2' in the SQL model.
🔧 PR: #5503, Revert '1inch: updates 17 (#5503)'
🧙 Author: @jeff-dude on 2024-03-13
📝 Summary: The logic added restricts re-initialization on v3 for only Uni V2 blockchains, while the previous logic restricted it for all blockchains.
🔧 PR: #5503, 1inch: updates 17
🧙 Author: @max-morrow on 2024-03-13
📝 Summary: Added a condition to restrict re-initialization only for 'uni v2' in the SQL model.
MODEL: dex_raw_pools.sql
🟠 Modified by:
🔧 PR: #5503, add back '1inch: updates 17 (#5503)'
🧙 Author: @jeff-dude on 2024-03-14
📝 Summary: Removed filtering condition based on 'pool' column and added a new filtering condition based on both 'blockchain' and 'pool' columns. The new logic filters out records where the combination of blockchain and pool appears more than once in the referenced model
dex_raw_pool_initializations.🔧 PR: #5503, Revert '1inch: updates 17 (#5503)'
🧙 Author: @jeff-dude on 2024-03-13
📝 Summary: Removed filtering by blockchain in a subquery and changed the condition to filter out pools that have more than one initialization record.
🔧 PR: #5503, 1inch: updates 17
🧙 Author: @max-morrow on 2024-03-13
📝 Summary: Removed filtering condition to exclude pools that were not changed after creation. Added a new filtering condition to exclude pools where the combination of blockchain and pool appears more than once in the initializations table.
SECTOR: prices
toggle to see all model updates
MODEL: prices_usd_daily.sql
🟢 Added by:
🔧 PR: #5490, Add prices daily
🧙 Author: @aalan3 on 2024-03-13
📝 Summary: This model creates a summarized view of cryptocurrency price data by day, including open, high, low, and close prices. It enables data analysts to analyze historical price trends for different cryptocurrencies based on the provided attributes such as blockchain type, contract address, decimals, and symbol. The model filters out the ongoing day's data for accurate analysis up to the previous day.
MODEL: prices_celo_tokens.sql
🟠 Modified by:
🔧 PR: #5577, add tokens to price list - celo
🧙 Author: @RantumBits on 2024-03-13
📝 Summary: The tokens that were added are: WFTM, SUSHI, PACT
MODEL: prices_avalanche_c_tokens.sql
🟠 Modified by:
🔧 PR: #5532, add new tokens to price list - avalanche
🧙 Author: @RantumBits on 2024-03-13
📝 Summary: The token symbols that were added are: 3ULL, HUSKY, XAVA, QI, WOLF
🔧 PR: #5532, add tokens to polygon & avalanche price lists [READY]
🧙 Author: @RantumBits on 2024-03-11
📝 Summary: The token symbols that were added are: COQ, GRT, UNI, MKR, BUSD, COMP
MODEL: prices_base_tokens.sql
🟠 Modified by:
🔧 PR: #5582, add base tokens to price list
🧙 Author: @RantumBits on 2024-03-13
📝 Summary: RATS, GMR, BSWAP
MODEL: prices_ethereum_tokens.sql
🟠 Modified by:
🔧 PR: #5531, Add Garden Finance's $SEED and Ethereans $OS to prices
🧙 Author: @asnogordo on 2024-03-12
📝 Summary: SEED, OS
🔧 PR: #5531, Add ezETH to tokens_arbitrum_erc20 and WEETH to prices.usd
🧙 Author: @viniabussafi on 2024-03-12
📝 Summary: WEETH
🔧 PR: #5531, add tokens to ethereum price list
🧙 Author: @RantumBits on 2024-03-12
📝 Summary: TITANX, DRAGONX, GRAI, PPG, BITCOIN, PAW, PSI/ACC TOPIA NON OX KIZUNA
🔧 PR: #5531, add tokens to ethereum price list [READY]
🧙 Author: @RantumBits on 2024-03-11
📝 Summary: The token symbols that were added are: YUP, JESUS, BONK, BAD, MEME, GALA,
PRIME, POL,PYUSD ,LOOM ,ONDO,WTAO,TBTC
MODEL: prices_bnb_tokens.sql
🟠 Modified by:
🔧 PR: #5538, feat: add missing btt, fdusd, and planet tokens
🧙 Author: @coreyar on 2024-03-12
📝 Summary: The tokens that were added or removed are: Added: FDUSD Removed: None
🔧 PR: #5538, fix: update tusd address
🧙 Author: @coreyar on 2024-03-12
📝 Summary: The token symbols that were added or removed are: TUSD
🔧 PR: #5538, fix: trx has 6 decimals
🧙 Author: @coreyar on 2024-03-12
📝 Summary: The token symbols that were added or removed are: TRX
🔧 PR: #5538, add tokens to bnb prices list
🧙 Author: @RantumBits on 2024-03-12
📝 Summary: MIM, USDP, AXLUSDC, DF, USX, STRAINZ, DISNEY SHIBA INU BTT AITECH RCM TRIAS PZP BABYGROK
🔧 PR: #5538, add new tokens to prices - arb, bnb, ftm, op [READY]
🧙 Author: @RantumBits on 2024-03-11
📝 Summary: BONK, PEPE, WETH, AGEUR, SOL, MIM, USDP, AXLUSDC
MODEL: prices_tokens.sql
🟠 Modified by:
🔧 PR: #5569, Scroll prices and tokens
🧙 Author: @0xRobin on 2024-03-12
📝 Summary: The reference model that was added is 'prices_scroll_tokens'.
MODEL: prices_scroll_tokens.sql
🟢 Added by:
🔧 PR: #5569, Scroll prices and tokens
🧙 Author: @0xRobin on 2024-03-12
📝 Summary: This model creates a temporary table that includes information about token IDs, blockchains, symbols, contract addresses, and decimals. It enables data analysts to work with this data for further analysis and reporting purposes.
MODEL: prices_polygon_tokens.sql
🟠 Modified by:
🔧 PR: #5526, add new polygon tokens to price list [READY]
🧙 Author: @RantumBits on 2024-03-12
📝 Summary: EGX, KEK, SHIB, DG, PGX, KLIMA, BCT, MV,
ROND,XEN ,ELON ,ICE,QI,RBW ,GMEE,FISH,PYR,
GEOD ,NAKA
🔧 PR: #5526, fix prices: add missing commas
🧙 Author: @jeff-dude on 2024-03-11
📝 Summary: The token symbols that were added or removed are: LDO
🔧 PR: #5526, add tokens to polygon & avalanche price lists [READY]
🧙 Author: @RantumBits on 2024-03-11
📝 Summary: BONK, RNDR, UNI, APE, MKR, CBETH, BUSD,
RETH,LUSD,TUSD,BAT,WAVAX,TBTC,LDO
🔧 PR: #5526, Add missing tokens to prices and tokens.erc20
🧙 Author: @viniabussafi on 2024-03-11
📝 Summary: The tokens that were added or removed are: ATA, EGX
MODEL: prices_fantom_tokens.sql
🟠 Modified by:
🔧 PR: #5538, add tokens to Fantom price list
🧙 Author: @RantumBits on 2024-03-12
📝 Summary: AXLUSDC, ORBS, SPA, SPACE, WOO
🔧 PR: #5538, add new tokens to prices - arb, bnb, ftm, op [READY]
🧙 Author: @RantumBits on 2024-03-11
📝 Summary: The token symbols that were added or removed are: MIM, LINK
MODEL: prices_arbitrum_tokens.sql
🟠 Modified by:
🔧 PR: #5526, fix prices: add missing commas
🧙 Author: @jeff-dude on 2024-03-11
📝 Summary: TBTC,Y2K
🔧 PR: #5526, add new tokens to prices - arb, bnb, ftm, op [READY]
🧙 Author: @RantumBits on 2024-03-11
📝 Summary: The tokens that were added are: PEPE, BONK, SWETH, LQTY, AXLUSDC, TBTC
🔧 PR: #5526, Add missing tokens to prices and tokens.erc20
🧙 Author: @viniabussafi on 2024-03-11
📝 Summary: Y2K
MODEL: prices_optimism_tokens_curated.sql
🟠 Modified by:
🔧 PR: #5538, add new tokens to prices - arb, bnb, ftm, op [READY]
🧙 Author: @RantumBits on 2024-03-11
📝 Summary: Three new tokens were added to the model: 'TBTC', 'AXLUSDC', and an updated version of 'USDC' with 6 decimals.
SECTOR: bonkbot
toggle to see all model updates
MODEL: bonkbot_solana_trades.sql
🟢 Added by:
🔧 PR: #5520, feat: add bonkbot trades spellbook
🧙 Author: @whalehunting on 2024-03-15
📝 Summary: This model enables data analysts to analyze fee payments and bot trades on the Solana blockchain. It combines fee payment information with trade details, including token amounts, symbols, addresses, fees in USD and tokens, project details, user IDs, transaction IDs. The model also identifies the last trade in each transaction based on inner instruction index comparison.
MODEL: bonkbot_solana_trades_seed.csv
🟢 Added by:
🔧 PR: #5520, feat: add bonkbot trades spellbook
🧙 Author: @whalehunting on 2024-03-15
📝 Summary: [changes too large] The model bonkbot_solana_trades_seed.csv was added.
SECTOR: _sector
toggle to see all model updates
MODEL: syncswap_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5528, Create syncswap_zkysnc_base_trades and add to
dex.trades🧙 Author: @thetroyharris on 2024-03-11
📝 Summary: This model creates a dataset that tracks swaps happening in SyncSwap pools on the zkSync blockchain. It extracts relevant information such as token amounts, addresses, and transaction details for data analysts to analyze swap activities within these pools. The model enables analysts to understand the volume and frequency of swaps, as well as identify trends or anomalies in trading behavior within SyncSwap pools on zkSync.
🟠 Modified by:
🔧 PR: #5528, [EASY] syncswap update |
dex.trades🧙 Author: @thetroyharris on 2024-03-15
📝 Summary: Added a new base table with conditional filtering based on incremental or start date criteria. Replaced the logs table with a union of two different sources, each following similar conditional filtering logic. Adjusted column references and calculations in the final select query to align with changes made in the base table structure and source data fields.
🔧 PR: #5528, ADDED BASO FINANCE (BASE) TO DEX.TRADES
🧙 Author: @sophie-analytics on 2024-03-13
📝 Summary: Changed the project name from 'SyncSwap' to 'syncswap'.
MODEL: dex_trades_beta.sql
🟠 Modified by:
🔧 PR: #5599, Remove duped record in dex.info
🧙 Author: @Hosuke on 2024-03-14
📝 Summary: A Common Table Expression (CTE) named 'as_is_dexs' was added to be included in a list of CTEs to union with the existing 'curve' CTE.
MODEL: baseswap_basex_base_base_trades.sql
🟢 Added by:
🔧 PR: #5483, Added baseswap(basex) to dex.trades
🧙 Author: @sophie-analytics on 2024-03-14
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v3_tradesthat enables data analysts to analyze Uniswap V3 trades on the blockchain. It sources data from events related to swaps and pool creations in the specified blockchain project, allowing for further analysis of trading activities within the UniswapV3 ecosystem.MODEL: dex_zksync_base_trades.sql
🟠 Modified by:
🔧 PR: #5535, Add Mute to
dex.tradesfor zkSync Era🧙 Author: @tomfutago on 2024-03-14
📝 Summary: A reference to a new model called 'mute_zksync_base_trades' was added to the existing list of models being referenced.
🔧 PR: #5535, Create syncswap_zkysnc_base_trades and add to
dex.trades🧙 Author: @thetroyharris on 2024-03-11
📝 Summary: A new base model,
syncswap_zksync_base_trades, was added to the list of base models.🔧 PR: #5535, Add Pancakeswap V2 for zkSync dex.trades_beta
🧙 Author: @lgingerich on 2024-03-11
📝 Summary: Added a reference to the
pancakeswap_v2_zksync_base_tradesmodel in the list of base models.🔧 PR: #5535, Add uniswapv3 on ZkSync to dex.trades
🧙 Author: @intensodefi on 2024-03-11
📝 Summary: A new base model reference to 'uniswap_v3_zksync_base_trades' was added to the list of base models.
MODEL: mute_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5587, Add Mute to
dex.tradesfor zkSync Era🧙 Author: @tomfutago on 2024-03-14
📝 Summary: This model creates a table called
uniswap_compatible_v2_tradesthat enables data analysts to analyze trade data specific to the 'mute' project on the 'zksync' blockchain. It includes information about swaps and pair creations related to the MuteSwitchPairDynamic_evt_Swap and MuteSwitchFactoryDynamic_evt_PairCreated events.MODEL: baso_finance_base_base_trades.sql
🟢 Added by:
🔧 PR: #5476, ADDED BASO FINANCE (BASE) TO DEX.TRADES
🧙 Author: @sophie-analytics on 2024-03-13
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v2_tradesthat enables data analysts to analyze Uniswap V2 trades for the specified blockchain, project, and version. It sources data from events related to pair swaps and pair creations in the specified sources.MODEL: nft_zksync_base_trades.sql
🟠 Modified by:
🔧 PR: #5475, Add zkMarkets to
nft.tradesfor zkSync Era🧙 Author: @tomfutago on 2024-03-13
📝 Summary: A reference to a model named 'zk_markets_zksync_base_trades' was added, and a reference to a model named 'element_zksync_base_trades' was removed. The loop iterates over nft_models.
MODEL: zk_markets_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5475, Add zkMarkets to
nft.tradesfor zkSync Era🧙 Author: @tomfutago on 2024-03-13
📝 Summary: This model creates a dataset that combines information on trades and royalties in the zkSync blockchain project. It enables data analysts to analyze trade details such as block number, transaction hash, buyer/seller information, trade category/type, price, currency contract used (ETH), royalty fee amounts and addresses. The model also includes functionality to handle NFT transactions until certain additional data fields are available in the base event tables.
MODEL: basepaint_base_rewards.sql
🟢 Added by:
🔧 PR: #5581, Add Basepaint rewards to the referrals.rewards spell
🧙 Author: @datadanne on 2024-03-13
📝 Summary: This model enables data analysts to track and analyze the minting of new NFTs in the BasePaint project. It captures all mints, distinguishing between those with a referrer (rewarded with an ERC20 token) and those without. The model provides information such as block details, transaction hashes, addresses involved, reward amounts, and contract details for further analysis.
MODEL: referral_staging_rewards.sql
🟠 Modified by:
🔧 PR: #5581, Add Basepaint rewards to the referrals.rewards spell
🧙 Author: @datadanne on 2024-03-13
📝 Summary: A reference to a model named 'fabric_zora_rewards' was added, and a reference to a model named 'basepaint_base_rewards' was also added.
MODEL: eas_arbitrum_attestations.sql
🟠 Modified by:
🔧 PR: #5534, Update EAS sources for Base + dupes fix
🧙 Author: @tomfutago on 2024-03-12
📝 Summary: The unique key 'DBT_INTERNAL_DEST.block_time' was removed from the incremental predicates, while the unique key ['schema_uid', 'attestation_uid'] was retained.
MODEL: eas_base_attestations.sql
🟠 Modified by:
🔧 PR: #5534, Update EAS sources for Base + dupes fix
🧙 Author: @tomfutago on 2024-03-12
📝 Summary: In this diff, the incremental predicate 'DBT_INTERNAL_DEST.block_time' was removed from the model. Additionally, the decoded project name was changed from 'base_eas' to 'attestationstation_v1'.
MODEL: eas_base_schemas.sql
🟠 Modified by:
🔧 PR: #5534, Update EAS sources for Base + dupes fix
🧙 Author: @tomfutago on 2024-03-12
📝 Summary: Changed the value of
decoded_project_namefrom 'base_eas' to 'attestationstation_v1'.MODEL: eas_ethereum_attestations.sql
🟠 Modified by:
🔧 PR: #5534, Update EAS sources for Base + dupes fix
🧙 Author: @tomfutago on 2024-03-12
📝 Summary: The unique key 'DBT_INTERNAL_DEST.block_time' was removed from the incremental predicates, while the unique key ['schema_uid', 'attestation_uid'] was retained.
MODEL: eas_polygon_attestations.sql
🟠 Modified by:
🔧 PR: #5534, Update EAS sources for Base + dupes fix
🧙 Author: @tomfutago on 2024-03-12
📝 Summary: The unique key 'DBT_INTERNAL_DEST.block_time' was removed from the incremental predicates, while the unique key ['schema_uid', 'attestation_uid'] was retained.
MODEL: eas_scroll_attestations.sql
🟠 Modified by:
🔧 PR: #5534, Update EAS sources for Base + dupes fix
🧙 Author: @tomfutago on 2024-03-12
📝 Summary: The unique key 'DBT_INTERNAL_DEST.block_time' was removed from the incremental predicates, while the unique key ['schema_uid', 'attestation_uid'] was retained.
MODEL: cex_ethereum_flows.sql
🟢 Added by:
🔧 PR: #5521, Migrate cex_ethereum.flows to a sector spell with macros to easily add new chains
🧙 Author: @hildobby on 2024-03-11
📝 Summary: This dbt SQL model creates a table that calculates the flows of tokens on the Ethereum blockchain from centralized exchanges (CEX). It enables data analysts to analyze and track token movements between CEX addresses and transfers on the Ethereum network.
MODEL: pancakeswap_v2_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5408, Add Pancakeswap V2 for zkSync dex.trades_beta
🧙 Author: @lgingerich on 2024-03-11
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v2_tradesthat enables data analysts to analyze and track trades on the Zksync blockchain for the Pancakeswap project. It specifically focuses on version 2 of Pancakeswap and sources data from events related to pair swaps (Pair_evt_Swap) and pair creations (Factory_evt_PairCreated).MODEL: dex_pools_beta.sql
🟢 Added by:
🔧 PR: #5473, Create
dex.poolsMacros & Move to Sector - Ready for review🧙 Author: @henrystats on 2024-03-11
📝 Summary: This model creates a union of data from the 'dex_ethereum_pools' table, allowing data analysts to access and analyze information related to blockchain pools, including details such as project, pool fees, tokens in the pool, creation block time and number. This enables analysts to perform comprehensive analysis on Ethereum pools across different projects and versions.
MODEL: dex_ethereum_pools.sql
🟢 Added by:
🔧 PR: #5473, Create
dex.poolsMacros & Move to Sector - Ready for review🧙 Author: @henrystats on 2024-03-11
📝 Summary: This model creates a union of data from two base models related to Uniswap V2 and V3 Ethereum pools. It combines information such as blockchain, project, pool details, fees, tokens in the pool, creation block time and number, and contract address. This enables data analysts to analyze a consolidated view of both Uniswap versions' Ethereum pools for further insights and comparisons.
MODEL: uniswap_v2_ethereum_pools.sql
🟢 Added by:
🔧 PR: #5473, Create
dex.poolsMacros & Move to Sector - Ready for review🧙 Author: @henrystats on 2024-03-11
📝 Summary: This model creates a table that identifies Uniswap V2 Ethereum pools with specified parameters. It enables data analysts to easily access and analyze information about Uniswap pools that are compatible with the given criteria, such as blockchain, project, version, event source, and hardcoded fee.
MODEL: uniswap_v3_ethereum_pools.sql
🟢 Added by:
🔧 PR: #5473, Create
dex.poolsMacros & Move to Sector - Ready for review🧙 Author: @henrystats on 2024-03-11
📝 Summary: This model creates a table that identifies Uniswap v3 pools on the Ethereum blockchain. It enables data analysts to easily access and analyze information about these pools, including details such as pool names and fees.
MODEL: lending_arbitrum_base_borrow.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'granary_arbitrum_base_borrow' was added, while a reference to a model named 'lodestar_v1_arbitrum_base_borrow' was removed.
MODEL: granary_arbitrum_base_borrow.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called lending_aave_v2_compatible_borrow that is specific to the 'arbitrum' blockchain and 'granary' project. It enables data analysts to analyze borrowing activities compatible with Aave v2 on Arbitrum for the Granary project version 1, decoded as 'the_granary'.
MODEL: lending_avalanche_c_base_borrow.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two references were added: 'benqi_avalanche_c_base_borrow' and 'granary_avalanche_c_base_borrow'.
MODEL: granary_avalanche_c_base_borrow.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called
lending_aave_v2_compatible_borrowin the database for the project 'granary' on the Avalanche C blockchain. It enables data analysts to analyze and track borrowing activities that are compatible with Aave V2 protocol version 1 within this specific project environment.MODEL: lending_base_base_borrow.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'sonne_finance_base_base_borrow' was removed, and references to models 'sonne_finance_base_base_borrow' and 'granary_base_base_borrow' were added.
MODEL: granary_base_base_borrow.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This new dbt SQL model creates a table called
lending_aave_v2_compatible_borrowin thebaseblockchain schema under the projectgranary. It is versioned as '1' and allows data analysts to analyze borrowing activities that are compatible with Aave V2 within this specific context.MODEL: lending_bnb_base_borrow.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two references were added in this dbt model: 'aave_v3_bnb_base_borrow' and 'granary_bnb_base_borrow'.
MODEL: granary_bnb_base_borrow.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called lending_aave_v2_compatible_borrow that is specific to the blockchain 'bnb' and project 'granary'. It enables data analysts to analyze borrowing data related to Aave V2 compatibility within the specified parameters.
MODEL: lending_ethereum_base_borrow.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'granary_ethereum_base_borrow' was added, while the reference to 'strike_ethereum_base_borrow' was removed.
MODEL: granary_ethereum_base_borrow.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called lending_aave_v2_compatible_borrow that focuses on Aave V2 compatible borrowing data from the Ethereum blockchain for the project 'granary.' It enables data analysts to analyze and understand borrowing activities within the specified context.
MODEL: lending_fantom_base_borrow.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two references were added in the dbt SQL model: 'aave_v3_fantom_base_borrow' and 'granary_fantom_base_borrow'.
MODEL: granary_fantom_base_borrow.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This new dbt SQL model creates a table called
lending_aave_v2_compatible_borrowspecific to the Fantom blockchain and Granary project. It enables data analysts to analyze borrowing activities compatible with Aave v2 within the specified parameters, facilitating insights into lending trends on the Fantom network for further analysis.MODEL: lending_optimism_base_borrow.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'granary_optimism_base_borrow' was added, while a reference to a model named 'sonne_finance_optimism_base_borrow' was removed.
MODEL: granary_optimism_base_borrow.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This new dbt SQL model creates a table called
lending_aave_v2_compatible_borrowthat is specific to the Optimism blockchain and Granary project version 1. It enables data analysts to analyze borrowing activities compatible with Aave v2 within the specified parameters.MODEL: lending_arbitrum_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A new reference to a model named 'granary_arbitrum_base_flashloans' was added in the dbt SQL file.
MODEL: granary_arbitrum_base_flashloans.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table that enables data analysts to analyze lending Aave V2 compatible flashloans specifically for the Arbitrum blockchain within the Granary project version 1.
MODEL: lending_avalanche_c_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model
granary_avalanche_c_base_flashloanswas added in addition to the existing references to modelsaave_v2_avalanche_c_base_flashloansandaave_v3_avalanche_c_base_flashloans.MODEL: granary_avalanche_c_base_flashloans.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This new dbt SQL model creates a table called
lending_aave_v2_compatible_flashloansin the Avalanche blockchain dataset for project Granary. It enables data analysts to analyze and work with flashloan data that is compatible with Aave v2 protocol on Avalanche C chain.MODEL: lending_base_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'granary_base_base_flashloans' was added, while a reference to a model named 'seamlessprotocol_base_base_flashloans' was removed.
MODEL: granary_base_base_flashloans.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This model creates a table named 'lending_aave_v2_compatible_flashloans' in the dbt project. It enables data analysts to analyze flashloan data related to Aave V2 compatibility within the lending domain on the base blockchain for project Granary version 1.
MODEL: lending_bnb_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'aave_v3_bnb_base_flashloans' was removed, and references to models named 'aave_v3_bnb_base_flashloans' and 'granary_bnb_base_flashloans' were added.
MODEL: granary_bnb_base_flashloans.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This SQL model creates a table named
lending_aave_v2_compatible_flashloansthat focuses on flash loans compatible with Aave V2 on the Binance Smart Chain. It enables data analysts to analyze and track flash loan activities specifically related to the Aave V2 protocol within the specified blockchain environment for project 'granary'.MODEL: lending_ethereum_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'granary_ethereum_base_flashloans' was added, while a reference to a model named 'spark_ethereum_base_flashloans' was removed from the list of models being referenced.
MODEL: granary_ethereum_base_flashloans.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called lending_aave_v2_compatible_flashloans, focusing on Ethereum blockchain data for the Granary project. It enables data analysts to analyze and work with flashloan-related information in the context of Aave v2 compatibility within the specified project version.
MODEL: lending_fantom_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two references were added to the list of models: 'granary_fantom_base_flashloans' was added in addition to 'aave_v3_fantom_base_flashloans'.
MODEL: granary_fantom_base_flashloans.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This SQL model creates a table named
lending_aave_v2_compatible_flashloansthat is specific to the Fantom blockchain and Granary project version 1. It enables data analysts to analyze flashloan compatibility within the Aave v2 lending protocol for this particular configuration.MODEL: lending_optimism_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two references were added to the list of models: 'granary_optimism_base_flashloans' was added in addition to 'aave_v3_optimism_base_flashloans'.
MODEL: granary_optimism_base_flashloans.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table named
lending_aave_v2_compatible_flashloansthat focuses on flash loans compatible with Aave V2 on the Optimism blockchain for the project 'granary.' It enables data analysts to analyze and work with data related to these specific flash loans within the specified context.MODEL: lending_arbitrum_base_supply.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'lodestar_v1_arbitrum_base_supply' was removed, and references to models named 'lodestar_v1_arbitrum_base_supply' and 'granary_arbitrum_base_supply' were added.
MODEL: granary_arbitrum_base_supply.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This SQL model creates a table called
lending_aave_v2_compatible_supplythat focuses on Aave V2 compatible supply data from the Arbitrum blockchain for the project 'granary.' It enables data analysts to analyze and track lending activities specific to this project version.MODEL: lending_avalanche_c_base_supply.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two references were added: 'benqi_avalanche_c_base_supply' and 'granary_avalanche_c_base_supply'.
MODEL: granary_avalanche_c_base_supply.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called lending_aave_v2_compatible_supply that is specific to the Avalanche blockchain. It enables data analysts to analyze and track supply data related to Aave V2 compatibility within the Granary project version 1 on Avalanche.
MODEL: lending_base_base_supply.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'sonne_finance_base_base_supply' was removed, and references to models named 'sonne_finance_base_base_supply' and 'granary_base_base_supply' were added.
MODEL: granary_base_base_supply.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called lending_aave_v2_compatible_supply, which is designed for data analysts working with Aave V2 compatible supply data. It enables analysts to query and analyze information related to lending activities within the Aave V2 ecosystem in a structured format.
MODEL: lending_bnb_base_supply.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'granary_bnb_base_supply' was added in the dbt SQL code.
MODEL: granary_bnb_base_supply.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called
lending_aave_v2_compatible_supplythat focuses on Aave V2 compatible supply data for the Granary project on the Binance blockchain. It enables data analysts to analyze and understand lending activities specific to this project and blockchain version.MODEL: lending_ethereum_base_supply.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A reference to a model named 'granary_ethereum_base_supply' was added, while a reference to a model named 'strike_ethereum_base_supply' was removed.
MODEL: granary_ethereum_base_supply.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called
lending_aave_v2_compatible_supplythat focuses on Aave V2 compatible supply data from the Ethereum blockchain. It enables data analysts to analyze and track lending activities within the Aave ecosystem for further insights and reporting in projects related to 'granary'.MODEL: lending_fantom_base_supply.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two dbt models, 'granary_fantom_base_supply' and 'aave_v3_fantom_base_supply', were added to the list of models being referenced in this SQL file.
MODEL: granary_fantom_base_supply.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This new dbt SQL model creates a table called lending_aave_v2_compatible_supply, specific to the Fantom blockchain and Granary project. It enables data analysts to analyze Aave V2 compatible supply data within the specified context.
MODEL: lending_optimism_base_supply.sql
🟠 Modified by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Added a reference to the model 'granary_optimism_base_supply' in the list of models.
MODEL: granary_optimism_base_supply.sql
🟢 Added by:
🔧 PR: #5495, Add Granary to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This model creates a table called
lending_aave_v2_compatible_supplythat enables data analysts to track Aave V2 compatible supply on the Optimism blockchain for the Granary project.MODEL: dex_arbitrum_base_trades.sql
🟠 Modified by:
🔧 PR: #5499, Add Wombat Exchange DEX & Vela Exchange Perp
🧙 Author: @chain-l on 2024-03-11
📝 Summary: A reference to a new table
wombat_exchange_arbitrum_base_tradeswas added in the dbt SQL model.MODEL: lending_gnosis_base_borrow.sql
🟠 Modified by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Three references were added to the SQL model: 'aave_v3_gnosis_base_borrow', 'realt_rmm_v1_gnosis_base_borrow', and 'realt_rmm_v2_gnosis_base_borrow'.
MODEL: realt_rmm_v1_gnosis_base_borrow.sql
🟢 Added by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a table called lending_aave_v2_compatible_borrow that is specific to the 'gnosis' blockchain and 'realt_rmm' project. It enables data analysts to analyze borrowing activities compatible with Aave v2 within this context, version 1 of the project is used and decoded as 'real_rmm_v1'.
MODEL: realt_rmm_v2_gnosis_base_borrow.sql
🟢 Added by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This SQL model creates a table named lending_aave_v3_compatible_borrow that is compatible with Aave v3 lending protocol. It enables data analysts to analyze borrowing activities specific to the 'real_rmm' project on the 'gnosis' blockchain, version 2.
MODEL: lending_gnosis_base_flashloans.sql
🟠 Modified by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Two models were added: 'realt_rmm_v1_gnosis_base_flashloans' and 'realt_rmm_v2_gnosis_base_flashloans'.
MODEL: realt_rmm_v1_gnosis_base_flashloans.sql
🟢 Added by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This model creates a table that enables data analysts to analyze lending Aave V2 compatible flashloans from the Gnosis blockchain for the project 'realt_rmm' version 1, with project decoding as 'real_rmm_v1'.
MODEL: realt_rmm_v2_gnosis_base_flashloans.sql
🟢 Added by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This model creates a table that enables data analysts to analyze lending Aave V3 compatible flashloans specific to the Gnosis blockchain for the RealT RMM project version 2.
MODEL: lending_gnosis_base_supply.sql
🟠 Modified by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Three references were added to the list of models: 'aave_v3_gnosis_base_supply', 'realt_rmm_v1_gnosis_base_supply', and 'realt_rmm_v2_gnosis_base_supply'.
MODEL: realt_rmm_v1_gnosis_base_supply.sql
🟢 Added by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This model creates a table called lending_aave_v2_compatible_supply that enables data analysts to track and analyze supply data related to the Aave v2 protocol within the Gnosis blockchain for the project realt_rmm.
MODEL: realt_rmm_v2_gnosis_base_supply.sql
🟢 Added by:
🔧 PR: #5524, Add RealT RMM to lending
🧙 Author: @tomfutago on 2024-03-11
📝 Summary: This dbt SQL model creates a view called lending_aave_v3_compatible_supply that is specific to the 'gnosis' blockchain and 'realt_rmm' project. It enables data analysts to analyze and work with supply data related to version 2 of the project, decoded as 'real_rmm_v2'.
MODEL: uniswap_v3_zksync_base_trades.sql
🟢 Added by:
🔧 PR: #5535, Add uniswapv3 on ZkSync to dex.trades
🧙 Author: @intensodefi on 2024-03-11
📝 Summary: This dbt SQL model creates a table called
uniswap_compatible_v3_tradesthat enables data analysts to analyze and track trades compatible with Uniswap V3 on the ZkSync blockchain. It includes information about swaps and pool creations sourced from Uniswap V3 events specific to the ZkSync network.MODEL: zonic_base_base_trades.sql
🟠 Modified by:
🔧 PR: #5468, Zonic
nft.tradesfix🧙 Author: @tomfutago on 2024-03-11
📝 Summary: A new column
c_alternative_token_addresswith a specific value was added to thezonic_base_tradesmodel.MODEL: zonic_zksync_base_trades.sql
🟠 Modified by:
🔧 PR: #5468, Zonic
nft.tradesfix🧙 Author: @tomfutago on 2024-03-11
📝 Summary: Added alternative token address and royalty fee receive address to skip for Zonic base trades in the dbt SQL model.
SECTOR: _base_sources
toggle to see all model updates
MODEL: arbitrum_base_sources.yml
🟠 Modified by:
🔧 PR: #5604, clean up
sources/directory and prepare for scale🧙 Author: @jeff-dude on 2024-03-14
📝 Summary: [changes too large] The model arbitrum_base_sources.yml was renamed.
MODEL: avalanche_c_base_sources.yml
🟠 Modified by:
🔧 PR: #5604, clean up
sources/directory and prepare for scale🧙 Author: @jeff-dude on 2024-03-14
**📝 S
Beta Was this translation helpful? Give feedback.
All reactions