📰 2023-10-27: Weekly Prophet! #4701
andrewhong5297
announced in
Prophet (Weekly Updates)
Replies: 1 comment
-
|
lol @hildobby TIL we have a dex info table. plans to expand this into the labels.addresses later? |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
This is your weekly summary of 35 PRs merged from 17 wizards. Great job everyone! 🎉
We had 69 added models 🟢 and 376 modified models 🟠 for 88 Sectors.
SECTOR: dex
toggle to see all model updates
MODEL: dex_aggregator_seed_legacy.csv
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model dex_aggregator_seed_legacy.csv was removed.
MODEL: dex_trades_seed_legacy.csv
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model dex_trades_seed_legacy.csv was removed.
MODEL: dex_solana_trades.sql
🟠 Modified by:
🔧 PR: #4661, Solana raydium v4 and orca twohop
🧙 Author: @andrewhong5297 on 2023-10-24
📝 Summary: In this SQL model, a new reference to the table 'raydium_v4_trades' was added to the list of Solana dexes.
MODEL: dex_info.sql
🟠 Modified by:
🔧 PR: #4589, Fill in
dex.infoentries🧙 Author: @hildobby on 2023-10-23
📝 Summary: The following changes were made to the SQL model: - The marketplace_type for 'dodo' was changed from 'Direct' to 'Direct & Aggregator'.
spiritswap, kyberswap beethoven_x platypus_finance hashflow velodrome quickswap mstable airswap wombat defiswap gmx
clipper woofi maverick thena synthetix fraxswap dfx zigzag integral wigoswapequalizer_exchange zipswapi ziswapsparatcus_exchange swapr rubicon arbsawp verse_dex glacier nomisawp onepunchsawpcamelot saddle oneinch zeroex paraswp cow_protocol openocean lifi yield_yak bebop euler synapse maker fiatdao dydx aave openxswa carbon_defi opx_finance ubeswa mauve xchange.
MODEL: dex_trades.sql
🟠 Modified by:
🔧 PR: #4632, added openocean dex
🧙 Author: @ARDev097 on 2023-10-23
📝 Summary: The reference models that were added or removed in the diff are: openocean_optimism_trades.
SECTOR: nft
toggle to see all model updates
MODEL: nft_ethereum_metadata_art_blocks_collections_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_art_blocks_collections_legacy.sql was removed.
MODEL: nft_ethereum_metadata_chromie_squiggle_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_chromie_squiggle_legacy.sql was removed.
MODEL: nft_ethereum_metadata_cryptodickbutts_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_cryptodickbutts_legacy.sql was removed.
MODEL: nft_ethereum_metadata_fellowship_gallery_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_fellowship_gallery_legacy.sql was removed.
MODEL: nft_ethereum_metadata_proof_grails_i_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_proof_grails_i_legacy.sql was removed.
MODEL: nft_ethereum_metadata_proof_grails_ii_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_proof_grails_ii_legacy.sql was removed.
MODEL: nft_ethereum_metadata_ringers_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_ringers_legacy.sql was removed.
MODEL: nft_ethereum_metadata_terraforms_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model nft_ethereum_metadata_terraforms_legacy.sql was removed.
SECTOR: labels
toggle to see all model updates
MODEL: labels_balancer_v2_pools_arbitrum.sql
🟠 Modified by:
🔧 PR: #4666, Balancer pools labels fix
🧙 Author: @viniabussafi on 2023-10-25
📝 Summary: The main logic added in this SQL model is the use of the 'WITH ORDINALITY' clause when performing CROSS JOIN UNNEST operations on arrays. This allows for retrieving the position (ordinality) of each element in the array, which is then used to ensure that elements from different arrays are matched correctly based on their positions. Additionally, there are some changes made to how certain columns are concatenated and ordered within CASE statements.
MODEL: labels_balancer_v2_pools_avalanche_c.sql
🟠 Modified by:
🔧 PR: #4666, Balancer pools labels fix
🧙 Author: @viniabussafi on 2023-10-25
📝 Summary: In this SQL model, the main logic that was added includes:
MODEL: labels_balancer_v2_pools_base.sql
🟠 Modified by:
🔧 PR: #4666, Balancer pools labels fix
🧙 Author: @viniabussafi on 2023-10-25
📝 Summary: In this SQL model, the main logic that was added includes:
MODEL: labels_balancer_v2_pools_ethereum.sql
🟠 Modified by:
🔧 PR: #4666, Balancer pools labels fix
🧙 Author: @viniabussafi on 2023-10-25
📝 Summary: The main logic added in this SQL model is the use of the 'WITH ORDINALITY' clause when performing CROSS JOIN UNNEST operations on arrays. This allows for retrieving the position (pos) of each element in the array, which is then used to filter and match elements from different arrays. Additionally, there are changes made to how names are generated based on pool_type and token_symbol values.
MODEL: labels_balancer_v2_pools_gnosis.sql
🟠 Modified by:
🔧 PR: #4666, Balancer pools labels fix
🧙 Author: @viniabussafi on 2023-10-25
📝 Summary: In this SQL model, the logic for joining and unnesting arrays has been modified. The 'CROSS JOIN UNNEST' statements now include an additional 'WITH ORDINALITY' clause to assign a position to each element in the array. A new condition has been added in the WHERE clause to filter rows where the positions of tokens and weights match. In addition, there are changes made to how names are generated based on pool types and symbols. The pool_type column is also included in the settings subquery result set.
MODEL: labels_balancer_v2_pools_optimism.sql
🟠 Modified by:
🔧 PR: #4666, Balancer pools labels fix
🧙 Author: @viniabussafi on 2023-10-25
📝 Summary: In this SQL model, the logic for joining and unnesting tables has been modified. The CROSS JOIN UNNEST statements now include the WITH ORDINALITY clause to add a position column. Additionally, a WHERE condition has been added to filter rows where the position of tokens matches the position of weights. Finally, in the settings section, there is an updated CASE statement that includes additional pool types and orders token symbols and normalized weights alphabetically.
MODEL: labels_balancer_v2_pools_polygon.sql
🟠 Modified by:
🔧 PR: #4666, Balancer pools labels fix
🧙 Author: @viniabussafi on 2023-10-25
📝 Summary: The main logic added in this SQL model is the use of the 'WITH ORDINALITY' clause when performing CROSS JOIN UNNEST operations on cc.tokens and cc.weights. This allows for retrieving the position (pos) of each element in these arrays, which is then used to filter out only matching positions. Additionally, there are changes made to how the name column is generated based on pool_type and token_symbol values.
MODEL: labels_hackers_ethereum_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_hackers_ethereum_legacy.sql was removed.
MODEL: labels_bridges_ethereum_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_bridges_ethereum_legacy.sql was removed.
MODEL: labels_dao_multisig_ethereum_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_dao_multisig_ethereum_legacy.sql was removed.
MODEL: labels_trader_kyt_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_trader_kyt_legacy.sql was removed.
MODEL: labels_cex_tokens_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_cex_tokens_legacy.sql was removed.
MODEL: labels_stablecoins_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_stablecoins_legacy.sql was removed.
MODEL: labels_mev_ethereum_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_mev_ethereum_legacy.sql was removed.
MODEL: labels_funds_ethereum_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model labels_funds_ethereum_legacy.sql was removed.
MODEL: labels_aave_v2_annual_liquidations.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows that several changes were made. It appears that a new table was added, along with its columns and constraints. Some existing tables had columns modified or removed, and there were also changes to the primary keys and foreign key relationships between tables. Additionally, some views were created or altered in this pull request. Overall, it seems like a significant update to the database schema was made with various additions and modifications across multiple tables and views.
MODEL: labels_aave_v2_daily_deposit_size.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows that a common table expression (CTE) named 'latest_net_deposits' was added. The CTE is used to calculate the latest net deposits in some way, but without further information it is not possible to determine the exact logic or calculations involved.
MODEL: labels_aztec_v2_contracts_ethereum.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows that there were additions and removals made. However, without the actual content of the additions and removals, it is not possible to summarize the main logic or provide a meaningful summary within 100 words.
MODEL: labels_safe_ethereum.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The SQL model contains a SELECT statement.
MODEL: labels_airdrop_1_receivers_optimism.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows that a SELECT statement was added or modified. The specific changes made within the SELECT statement are not provided in the given information.
MODEL: labels_airdrop_2_receivers_optimism.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows that a SELECT statement was added or modified. The specific changes made within the SELECT statement are not provided in the given information.
MODEL: labels_airdrop_3_receivers_optimism.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows that a SELECT statement was added or modified. The specific changes made within the SELECT statement are not provided in the given information.
MODEL: labels_dao_framework.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The main logic added in this SQL model is the creation of a common table expression (CTE) named 'dao_address_w_name'. This CTE likely combines data from multiple tables to create a new dataset that includes both the address and name information. The specific details of how this combination is done are not provided in the diff.
MODEL: labels_arbitrage_traders_ethereum.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The SQL model contains a 'with' statement, which is used to define one or more common table expressions (CTEs). CTEs are temporary result sets that can be referenced within the main query. The specific logic of the CTEs and their usage cannot be determined without further information.
MODEL: labels_sandwich_attackers_ethereum.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows the addition of a common table expression (CTE) named 'eth_sandwich_attackers'. The specific logic within this CTE is not provided in the diff.
MODEL: labels_validators_ethereum.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The added logic in the SQL model is a SELECT statement that retrieves distinct values for the column 'blockchain' and assigns it as 'ethereum'.
MODEL: labels_validators_solana.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The added logic in the SQL model is a SELECT statement that retrieves distinct values. It selects the string 'solana' as 'blockchain'.
MODEL: labels_cex.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: I'm sorry, but I cannot see or access any specific SQL model. If you can provide the diff of the dbt SQL model, I would be happy to help summarize it for you.
MODEL: labels_funds_ethereum.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: In the given SQL model, several columns are selected from a table. The selected columns include blockchain, address, name, category, contributor, source, created_at,
updated_at,model_name and label_type. No specific logic or conditions were added or removed in this diff.
MODEL: labels_nft_users_platforms.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: A new CTE (Common Table Expression) named 'nft_trades' was added to the SQL model. The specific logic within this CTE is not provided in the diff, so it cannot be summarized.
MODEL: labels_nft_smart_trader_roi_eth.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The diff of the SQL model shows that there were changes made to the 'with' clause. However, without any specific details or context provided in the question, it is not possible to summarize what was added or removed within this clause.
MODEL: labels_nft_traders_transactions.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The main logic added in the SQL model is a common table expression (CTE) named 'nft_trades'. It is created using the WITH statement. The CTE allows for defining a temporary result set that can be referenced multiple times within the query.
MODEL: labels_nft_traders_transactions_current.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: A new CTE (Common Table Expression) named 'nft_trades' was added to the SQL model. The specific logic within this CTE is not provided in the diff, so it cannot be summarized.
MODEL: labels_nft_traders_volume_usd.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The SQL model includes a common table expression (CTE) named 'nft_trades'. The CTE is used to create a temporary table that contains information about NFT trades. The specific logic within the CTE is not provided in the diff, so further details cannot be summarized.
MODEL: labels_nft_traders_volume_usd_current.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The SQL model includes a common table expression (CTE) named 'nft_trades'. The CTE is used to create a temporary table that contains information about NFT trades. The specific logic of what was added or removed within the CTE cannot be determined without further context.
MODEL: labels_three_letter_ens_count.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: A CTE named 'three_letter_ens_count' was added to the SQL model. The purpose or logic of this CTE is not clear from the given diff.
SECTOR: tokens
toggle to see all model updates
MODEL: tokens_celo_erc20.sql
🟠 Modified by:
🔧 PR: #4650, Celo - more erc20 tokens
🧙 Author: @tomfutago on 2023-10-26
📝 Summary: [changes too large] The model tokens_celo_erc20.sql was modified.
MODEL: tokens_arbitrum_erc20_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_arbitrum_erc20_legacy.sql was removed.
MODEL: tokens_avalanche_c_erc20_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_avalanche_c_erc20_legacy.sql was removed.
MODEL: tokens_avalanche_c_nft_curated_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_avalanche_c_nft_curated_legacy.sql was removed.
MODEL: tokens_bnb_bep20_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_bnb_bep20_legacy.sql was removed.
MODEL: tokens_bnb_nft_curated_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_bnb_nft_curated_legacy.sql was removed.
MODEL: tokens_ethereum_erc20_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_ethereum_erc20_legacy.sql was removed.
MODEL: tokens_ethereum_nft_curated_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_ethereum_nft_curated_legacy.sql was removed.
MODEL: tokens_fantom_erc20_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_fantom_erc20_legacy.sql was removed.
MODEL: tokens_gnosis_erc20_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_gnosis_erc20_legacy.sql was removed.
MODEL: tokens_gnosis_nft_curated_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_gnosis_nft_curated_legacy.sql was removed.
MODEL: tokens_optimism_erc20_curated_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_optimism_erc20_curated_legacy.sql was removed.
MODEL: tokens_optimism_nft_curated_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_optimism_nft_curated_legacy.sql was removed.
MODEL: tokens_polygon_erc20_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_polygon_erc20_legacy.sql was removed.
MODEL: tokens_solana_fungible_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model tokens_solana_fungible_legacy.sql was removed.
MODEL: tokens_arbitrum_erc20.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: Sorry, but I can't assist with summarizing a SQL model without the actual code. Could you please provide the complete SQL model?
MODEL: tokens_arbitrum_nft_curated.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The added logic includes a SELECT statement that retrieves the contract_address, name, and symbol columns from a temporary table created using the VALUES clause. No further information is provided in the diff.
MODEL: tokens_avalanche_c_erc20.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: Sorry, but I can't assist with summarizing a SQL model without the actual code.
MODEL: tokens_avalanche_c_nft_curated.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The added logic includes a SELECT statement that retrieves the contract_address, name, and symbol columns from a temporary table created using the VALUES clause. No further information is provided in the diff.
MODEL: tokens_base_nft_curated.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The added logic includes a SELECT statement that retrieves the contract address, name, and symbol from a table. No other changes or modifications were made in this diff.
MODEL: tokens_bnb_bep20.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: In the given SQL model, a SELECT statement is used to retrieve data from the columns 'contract_address', 'symbol', and 'decimals'. The data is selected from a temporary table created using the VALUES clause.
MODEL: tokens_ethereum_rebase.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: In the given SQL model, a SELECT statement is used to retrieve the contract_address and symbol columns from a table. The VALUES keyword indicates that the values for these columns are being provided directly in the query rather than being fetched from another table or source.
MODEL: tokens_fantom_erc20.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: Sorry, but I can't assist with summarizing a SQL model.
MODEL: tokens_fantom_nft_curated.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The added logic includes a SELECT statement that retrieves the contract address, name, and symbol from a temporary table created using the VALUES clause. No specific column names or lines are mentioned in the summary.
MODEL: tokens_fantom_rebase.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: In the given SQL model, a SELECT statement is used to retrieve data from the columns 'contract_address', 'symbol', and 'decimals'. The data is selected from a temporary table created using the VALUES clause. No further information or details are provided in the diff.
MODEL: tokens_gnosis_erc20.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The token symbols that were added or removed cannot be determined from the given diff of the dbt SQL model. The provided code snippet only includes a SELECT statement without any indication of additions or removals.
MODEL: tokens_optimism_nft_curated.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: In the given SQL model, a SELECT statement is used to retrieve data from a table. The columns selected are contract_address, name, and a new column called symbol which is created using the cast function to assign NULL as its value.
MODEL: tokens_polygon_erc20.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: Sorry, but I can't assist with summarizing a SQL model.
MODEL: tokens_polygon_nft_curated.sql
🟠 Modified by:
🔧 PR: #4663, SPE-201 Remove dunesql tag + dunesql tag selectors
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: The added logic includes a SELECT statement that retrieves the contract_address and name columns from a table. Additionally, it adds an empty string as the symbol column.
MODEL: tokens_zksync_erc20.sql
🟢 Added by:
🔧 PR: #4547, Add zkSync to
tokens🧙 Author: @lgingerich on 2023-10-20
📝 Summary: This SQL model creates a temporary table called 'temp_table' with columns for contract address, symbol, and decimals. It populates the table with values for various tokens such as ETH, WETH, USDC.e, BUSD, USDT.e etc. This model enables data analysts to easily query and analyze information about these tokens using the created temp_table.
🟠 Modified by:
🔧 PR: #4547, Add more zksync erc20s
🧙 Author: @hildobby on 2023-10-23
📝 Summary: COMBO, PERP, DVF, WOO, xcRMRK, DERI, DEXTF,
GOVI,LQTY ,PEPE,rETH,RPL,UFI ,cbETH ,
IBEX ,RAISE,LSD ETHx,KNC,BEL,
ZZ,BITCOIN,BYN,WAGMI and POOL
🔧 PR: #4547, zksync tokens spells: add schemas in config
🧙 Author: @jeff-dude on 2023-10-20
📝 Summary: Sorry, but I can't assist with summarizing a SQL model without the actual code. Could you please provide the complete SQL model?
MODEL: tokens_zksync_nft.sql
🟢 Added by:
🔧 PR: #4547, Add zkSync to
tokens🧙 Author: @lgingerich on 2023-10-20
📝 Summary: This SQL model creates a query that retrieves contract addresses, names, symbols, and standards from two tables: 'tokens_zksync_nft_standards' and 'tokens_zksync_nft_curated'. It enables data analysts to easily access information about tokens in the ZkSync NFT ecosystem.
🟠 Modified by:
🔧 PR: #4547, zksync tokens spells: add schemas in config
🧙 Author: @jeff-dude on 2023-10-20
📝 Summary: I'm sorry, but I cannot summarize the SQL model without having access to the actual code. Please provide me with the diff of the dbt SQL model so that I can assist you in creating a comma-separated list of added or removed token symbols.
MODEL: tokens_zksync_nft_curated.sql
🟢 Added by:
🔧 PR: #4547, Add zkSync to
tokens🧙 Author: @lgingerich on 2023-10-20
📝 Summary: This SQL model creates a temporary table called 'temp_table' with columns for contract address, name, and symbol. It populates the table with values representing ERC-721 and ERC-1155 tokens along with their corresponding names and symbols. This model enables data analysts to query this temporary table to retrieve information about these tokens based on their contract addresses, names, or symbols.
🟠 Modified by:
🔧 PR: #4547, zksync tokens spells: add schemas in config
🧙 Author: @jeff-dude on 2023-10-20
📝 Summary: The added logic includes a SELECT statement that retrieves the contract address, name, and symbol from a temporary table created using the VALUES clause. No further information is provided in the diff.
MODEL: tokens_zksync_nft_standards.sql
🟢 Added by:
🔧 PR: #4547, Add zkSync to
tokens🧙 Author: @lgingerich on 2023-10-20
📝 Summary: This dbt SQL model creates a query that selects the contract address and the maximum token standard for each block time from a table called 'nft_zksync_transfers'. It also includes an optional filter to only consider data from the past 7 days if it is run incrementally. The result is grouped by the contract address. This model enables data analysts to analyze and aggregate NFT transfers based on their contract addresses and token standards over a specified time period.
SECTOR: prices
toggle to see all model updates
MODEL: prices_ethereum_tokens.sql
🟠 Modified by:
🔧 PR: #4664, Add $VAL (Valeria) Token To prices model.
🧙 Author: @nathanglb on 2023-10-25
📝 Summary: The token symbols that were added or removed are: CRVUSD, MAV, PEPE, WLD, VAL
MODEL: prices_polygon_tokens.sql
🟠 Modified by:
🔧 PR: #4664, Add $VAL (Valeria) Token To prices model.
🧙 Author: @nathanglb on 2023-10-25
📝 Summary: The token symbols that were added or removed are: VAL
MODEL: prices_usd_forward_fill.sql
🟠 Modified by:
🔧 PR: #4659, prices.usd -> change forward fill lookback and add a monitor
🧙 Author: @0xRobin on 2023-10-25
📝 Summary: The main logic that was added in this diff is the change of the lookback interval from '2 days' to '1 hour'. This means that anything before the specified time interval is considered finalized, and anything after is forward filled. Additionally, a filter condition was added to include only records where the minute value is greater than or equal to now() minus the updated lookback interval.
MODEL: prices_usd_monitor.sql
🟢 Added by:
🔧 PR: #4659, prices.usd -> change forward fill lookback and add a monitor
🧙 Author: @0xRobin on 2023-10-25
📝 Summary: This SQL model creates a monitor to gather quantile information about prices latency. It selects the current timestamp as 'recorded_at' and calculates the digest of latency seconds using qdigest_agg function. The data is sourced from a table called 'prices' with USD values, filtering for records within the last 7 days. The final result is grouped by recorded_at timestamp.
MODEL: prices_arbitrum_tokens.sql
🟠 Modified by:
🔧 PR: #4682, Add RDNT to prices_arbitrum_tokens.sql
🧙 Author: @markusbkoch on 2023-10-25
📝 Summary: The token symbols that were added or removed are: RDNT
MODEL: prices_arbitrum_tokens_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model prices_arbitrum_tokens_legacy.sql was removed.
MODEL: prices_bnb_tokens_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model prices_bnb_tokens_legacy.sql was removed.
MODEL: prices_ethereum_tokens_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model prices_ethereum_tokens_legacy.sql was removed.
MODEL: prices_optimism_tokens_curated_legacy.sql
🟠 Modified by:
🔧 PR: #4648, SPE-191 Post migration cleanup
🧙 Author: @couralex6 on 2023-10-24
📝 Summary: [changes too large] The model prices_optimism_tokens_curated_legacy.sql was removed.
MODEL: prices_tokens.sql
🟠 Modified by:
🔧 PR: #4551, Add zkSync to
prices🧙 Author: @lgingerich on 2023-10-23
📝 Summary: The reference models that were added or removed in the given diff are: prices_zksync_tokens.
MODEL: prices_zksync_tokens.sql
🟢 Added by:
🔧 PR: #4551, Add zkSync to
prices🧙 Author: @lgingerich on 2023-10-23
📝 Summary: This SQL model creates a table that stores information about different tokens on the zksync blockchain. It includes details such as token ID, blockchain name, symbol, contract address, and decimals. This enables data analysts to easily access and analyze data related to these tokens on the zksync platform.
SECTOR: base_sources
toggle to see all model updates
MODEL: zora_base_sources.yml
🟢 Added by:
🔧 PR: #4697, add Zora base sources to Spellbook
🧙 Author: @0xRobin on 2023-10-27
📝 Summary: [changes too large] The model zora_base_sources.yml was added.
SECTOR: staking
toggle to see all model updates
MODEL: staking_ethereum_entities_batch_contracts_tx_from.sql
🟢 Added by:
🔧 PR: #4621, Add staking entities
🧙 Author: @hildobby on 2023-10-25
📝 Summary: This SQL model creates a query that retrieves data from multiple tables in the database. It joins the
DepositContract_evt_DepositEvent,traces, andtransactionstables to extract information about transactions, entities, and categories related to deposits made on specific contracts. The model enables data analysts to analyze deposit events based on various criteria such as entity name, category, and block time.🟠 Modified by:
🔧 PR: #4621, Staking typo fix
🧙 Author: @hildobby on 2023-10-26
**📝
Beta Was this translation helpful? Give feedback.
All reactions