# Table of Contents - [Dune Spellbook](#dune-spellbook) --- # Dune Spellbook icons ###### Lineage Graph All selected * **Select All** * Models * Seeds * Snapshots * Sources * Tests * Analyses * Exposures * Metrics * Semantic\_models resources spellbook * **Select All** * spellbook packages All selected * **Select All** * arbitrum * avalanche\_c * 0xRob * 0xr3x * 0xroll * 1155C * 721C * ARDev097 * Aragon App * Aragon Client * Aragon app * BLOB\_TX\_TYPE * BroderickBonelli * DEX trades * ENS resolver * ENS reverse * ERC1155C * ERC721C * Flashbots * Henrystats * Jarvis Network * KYT * L1 * L2 * Limit Break * MEV * aave * aave\_v2 * aave\_v3 * abi * abstraction * account * accounting * accounts * actions * addresses * addresses\_summary * aerodrome * affiliate * agave * agg\_day * agg\_hour * aggregator * agora * airdrop * ajna * alchemydao * algorand * all * alm * amm * ampleforth * apecoin * app\_data * approvals * aptos * aragon * arb * arbitrage * arbitrage\_traders * arbitrum * arbitrum\_chain * archetypes * arkham * arrakis * arrakis\_finance * attestation * attester * auction * auto-compound * avalanche * avalanche\_c * average\_trade\_values * avt * aztec * balancer * balances * base * basemax\_finance * batch * batch submitters * batches * beethoven\_x * bend\_dao * bennyfeng * benqi * bep1155 * bep20 * bep20\_daily * bep20\_hourly * bep20\_latest * bep721 * bernat * beta * bids * bitcoin * blast * blend * blob * blobs * blocks * bluechip\_investment * blur * bmx * bnb * boost * boost\_inbox * borrow * bot * bots * botto * bpt * bridge * bridges * burn\_addresses * cErc20 * cEther * cToken * capital\_pool * cardano * celo * cex * chains * changes * cipher * claim * coinbase * coinbase wallet * colony * component * compound * compound\_v2 * contract\_deployers * contracts * cosmos * covers * cow\_protocol * creation * creator tokens * creatortokens * cross-chain * cross-chain evm * crosschain * cryptopunks * currencies * curve * curvefi * daily * dao * dao creator tools * daohaus * daos * dappradar * day * decentrex * decoded * defi * delegators * depin * deploys * deposit * deposits * derived * derived archetype * dex * dex\_aggregator * distribution * donation * dot2dotseurat * dunesql * dydx * early\_investment * eas * eclp * ellipsis\_finance * elrond * emdx * endpoint * ens * entities * entrypoint * eos * equalizer * erc1155 * erc20 * erc20\_daily * erc20\_hourly * erc20\_latest * erc4337 * erc721 * eth * eth-flow * ethereum * ethereum\_name\_service * ethereumnameservice * etherfi * events * evms * exclude * fantom * fee * fees * flashloans * floor * flows * fluxfinance * forefront * forex * forta\_network * forward\_fill * frax\_finance * friend3 * friend\_tech * funcsig * function * funds * fungible * fxdx * galxe * gandalf * gas * gas\_dao * gauges * gearbox * genesis * genie * gitcoin * giveth * glp * gmx * gnosis * gnosis\_chain * goerli * governance * granary * grant * gyroscope * hackers * harvest\_yield * hashflow * henrystats * hop\_protocol * hosuke * hour * hubble\_exchange * immortalx * incentives * info * infrastructure * injective * inscriptions * institution * integration\_test * interest * ironbank * jelly\_swap * kwenta * l2 * labels * latest * layer\_bank * layerzero * lbp * lend * lending * lens * lido * limitbreak * linea * liquidation * liquidations * liquidity * listings * litecoin * loans * lodestar * logs * longnhbkhn * looksrare * magiceden * mainnet * maker * mantle * margin * masterchef * matic * mauve * meridian * messages * metadata * method\_ids * methods * mev * miners * minerva\_money * mint * minters * mints * miso * monitoring * moola * moonwell * morpho * multisig * mummy\_finance * name * native\_bridge * nether\_fi * nex * nexusmutual * nft * nft trades * nft\_traders * node\_names * nomad * notional * untagged * ofac * ofac\_sanction * offers * offramp * omen * oneinch * onramp * op chain * opensea * optimisim * optimism * options * optionss * opx\_finance * order-books * orders * owners * paladin * pangolin * paraswap * perpetual * perpetual trades * perpetual-protocol * perpetuals * perps * pika * pika, pika\_v1 * pika, pika\_v2 * pika, pika\_v3 * polkadot * polygon * pool * pool\_balance\_agg\_day * pool\_creations * pool\_settings\_latest * pool\_trades\_agg\_day * pool\_view * pools * pooltogether * pooltogether\_v4 * post\_tech * prices * prod\_exclude * projects * proposal submitters * proposals * protocol * query * quest * quests * quotation\_trades * radiant * realt\_rmm * reaper * rebase * redeem underlying * referral * referrals * registrations * reinvests * repay * resolver\_latest * resolver\_records * retropgf * revenue * reverse * rewards * ribbon * ripple * rocifi * rolling\_day * rolling\_hour * rollup * round * rubicon * rwa * safe * sanctioned * sandwich * sandwich\_attackers * satoshi * scroll * seamlessprotocol * sei * send * services * setname * shapeshift * sharky * signature * signatures * single * singletons * slope * smart\_dex\_traders * snapshot * snowswap * social * soispoke * solana * solver * sonne\_finance * spaceid * spark * stability * stable\_to\_stable * stablecoin * stablecoins * staker * staking * staking\_token\_investment * standard\_bridge * stars\_arena * static * stats * steth * strategies * strike * sudoswap * superrare * supply * sushi * sushiswap * swaps * syndicate * synthereum * synthetix * system * table * tessera * thales * tigris * timeswap * tokemak * token\_standards * tokenfy * tokens * tollywood * tomfutago * topics * tornado\_cash * traces * trade\_slippage * trader\_age * trader\_dex\_diversity * trader\_frequencies * trader\_platforms * traders * trades * transaction * transactions * transfers * treasury\_management * tron * tvl * tx\_hash * unidex * unidex\_v1 * unidex\_v2 * unidex\_v3 * uniswap * usd * usernames * users * uwulend * v2 * v3 * validator * validators * value\_defi * vault * vaults * vebal * vela\_exchange * velo * velodrome * view * volume * voodoo\_trade * voters * votes * wallet summary * wash traders * weights * withdrawals * withdraws * worldcoin * x2y2 * xena\_finance * yakadapter * yakswap * yield * yield\_yak * zerion * zerolend * zilliqa * zkevm * zksync * zodiac * zora tags \--select \--exclude [![](data:image/svg+xml,%3Csvg width='242' height='90' viewBox='0 0 242 90' fill='none' xmlns='http://www.w3.org/2000/svg'%3E %3Cpath d='M240.384 74.5122L239.905 75.8589H239.728L239.249 74.5156V75.8589H238.941V74.0234H239.324L239.816 75.3872L240.309 74.0234H240.691V75.8589H240.384V74.5122ZM238.671 74.3003H238.169V75.8589H237.858V74.3003H237.352V74.0234H238.671V74.3003Z' fill='%23262A38'/%3E %3Cpath d='M154.123 13.915V75.3527H141.672V69.0868C140.37 71.2839 138.499 73.0742 136.22 74.2134C133.779 75.434 131.012 76.085 128.246 76.085C124.828 76.1664 121.41 75.1899 118.562 73.2369C115.633 71.2839 113.354 68.5986 111.889 65.425C110.262 61.7631 109.448 57.8572 109.529 53.8698C109.448 49.8825 110.262 45.9765 111.889 42.3961C113.354 39.3038 115.633 36.6185 118.481 34.7469C121.41 32.8753 124.828 31.9801 128.246 32.0615C130.931 32.0615 133.616 32.6311 135.976 33.8517C138.255 34.991 140.126 36.6999 141.428 38.8156V18.0651L154.123 13.915ZM139.15 63.2279C140.777 61.1121 141.672 58.0199 141.672 54.0326C141.672 50.0452 140.859 47.0344 139.15 44.9187C137.441 42.8029 134.755 41.5823 131.989 41.6637C129.222 41.5009 126.537 42.7215 124.746 44.8373C123.038 46.953 122.142 49.9639 122.142 53.8698C122.142 57.8572 123.038 60.9494 124.746 63.1465C126.455 65.3436 129.222 66.5642 131.989 66.4828C135.081 66.4828 137.522 65.3436 139.15 63.2279Z' fill='%23262A38'/%3E %3Cpath d='M198.635 34.6655C201.564 36.5371 203.843 39.2225 205.226 42.3147C206.853 45.8952 207.667 49.8011 207.586 53.7885C207.667 57.7758 206.853 61.7632 205.226 65.3436C203.761 68.5172 201.483 71.2026 198.553 73.1556C195.705 75.0272 192.287 76.0037 188.87 75.9223C186.103 76.0037 183.336 75.3527 180.895 74.0507C178.617 72.9114 176.745 71.1212 175.524 68.9241V75.2713H162.993V18.0651L175.606 13.915V38.9783C176.826 36.7812 178.698 34.991 180.976 33.8517C183.418 32.5498 186.103 31.8988 188.87 31.9801C192.287 31.8988 195.705 32.8753 198.635 34.6655ZM192.45 63.1465C194.159 60.9494 194.973 57.8572 194.973 53.7885C194.973 49.8825 194.159 46.8716 192.45 44.7559C190.741 42.6402 188.381 41.5823 185.289 41.5823C182.523 41.4196 179.837 42.6402 178.047 44.8373C176.338 47.0344 175.524 50.0452 175.524 53.9512C175.524 57.9386 176.338 61.0308 178.047 63.1465C179.756 65.3436 182.441 66.5642 185.289 66.4015C188.056 66.5642 190.741 65.3436 192.45 63.1465Z' fill='%23262A38'/%3E %3Cpath d='M225 42.4774V58.915C225 61.2749 225.651 62.9838 226.791 64.0416C228.093 65.1809 229.801 65.7505 231.592 65.6691C232.975 65.6691 234.44 65.425 235.742 65.0995V74.8644C233.382 75.6782 230.941 76.085 228.499 76.0037C223.292 76.0037 219.304 74.5389 216.537 71.6094C213.771 68.68 212.387 64.5299 212.387 59.1592V23.1103L225 19.0416V33.038H235.742V42.4774H225Z' fill='%23262A38'/%3E %3Cpath d='M86.1754 3.74322C88.2911 5.77758 89.6745 8.46293 90 11.3924C90 12.613 89.6745 13.4268 88.9421 14.9729C88.2098 16.519 79.1772 32.1429 76.4919 36.4557C74.9458 38.9783 74.132 41.9892 74.132 44.9186C74.132 47.9295 74.9458 50.859 76.4919 53.3816C79.1772 57.6944 88.2098 73.3996 88.9421 74.9457C89.6745 76.4919 90 77.2242 90 78.4448C89.6745 81.3743 88.3725 84.0597 86.2568 86.0127C84.2224 88.1284 81.5371 89.5118 78.689 89.7559C77.4684 89.7559 76.6546 89.4304 75.1899 88.698C73.7251 87.9656 57.7758 79.1772 53.4629 76.4919C53.1374 76.3291 52.8119 76.085 52.4051 75.9222L31.085 63.3092C31.5732 67.3779 33.3635 71.2839 36.2929 74.132C36.8626 74.7016 37.4322 75.1899 38.0832 75.6781C37.5949 75.9222 37.0253 76.1664 36.5371 76.4919C32.2242 79.1772 16.519 88.2098 14.9729 88.9421C13.4268 89.6745 12.6944 90 11.3924 90C8.46293 89.6745 5.77758 88.3725 3.82459 86.2568C1.70886 84.2224 0.325497 81.5371 0 78.6076C0.0813743 77.387 0.406872 76.1664 1.05787 75.1085C1.79024 73.5624 10.8228 57.8571 13.5081 53.5443C15.0542 51.0217 15.868 48.0922 15.868 45.0814C15.868 42.0705 15.0542 39.141 13.5081 36.6184C10.8228 32.1429 1.70886 16.4376 1.05787 14.8915C0.406872 13.8336 0.0813743 12.613 0 11.3924C0.325497 8.46293 1.62749 5.77758 3.74322 3.74322C5.77758 1.62749 8.46293 0.325497 11.3924 0C12.613 0.0813743 13.8336 0.406872 14.9729 1.05787C16.2749 1.62749 27.7486 8.30018 33.8517 11.8807L35.2351 12.6944C35.7233 13.0199 36.1302 13.264 36.4557 13.4268L37.1067 13.8336L58.8336 26.6908C58.3454 21.8083 55.8228 17.3327 51.9168 14.3219C52.4051 14.0778 52.9747 13.8336 53.4629 13.5081C57.7758 10.8228 73.481 1.70886 75.0271 1.05787C76.085 0.406872 77.3056 0.0813743 78.6076 0C81.4557 0.325497 84.1411 1.62749 86.1754 3.74322ZM46.1392 50.7776L50.7776 46.1392C51.4286 45.4882 51.4286 44.5118 50.7776 43.8608L46.1392 39.2224C45.4882 38.5714 44.5118 38.5714 43.8608 39.2224L39.2224 43.8608C38.5714 44.5118 38.5714 45.4882 39.2224 46.1392L43.8608 50.7776C44.4304 51.3472 45.4882 51.3472 46.1392 50.7776Z' fill='%23FF694A'/%3E %3C/svg%3E)](https://spellbook-docs.dune.com/#!/overview) ### Welcome! Welcome to the documentation for Spellbook! 🧙‍♂️🧙‍♀️ #### Navigation Looking at the source code on [Github](https://github.com/duneanalytics/spellbook) : * The `Spells` section mirrors the `models` directory - i.e. abstracted tables built by the community * The `Sources` section mirrors the `sources` directory - i.e. raw and decoded data provided by Dune ### Graph Exploration You can click the blue icon on the bottom-right corner of the page to view the lineage graph of Dune spells. On spell pages, you'll see the immediate parents and children of the spell you're exploring. By clicking the `Expand` button at the top-right of this lineage pane, you'll be able to see all of the spells that are used to build, or are built from, the spell you're exploring. Once expanded, you'll be able to use the `--select` and `--exclude` spell selection syntax to filter the spells in the graph. For more information on spell selection, check out the [dbt docs](https://docs.getdbt.com/docs/model-selection-syntax) . Note that you can also right-click on spells to interactively filter and explore the graph. * * * ### More information * [Why we built spellbook](https://dune.com/blog/spellbook) * Read the [Dune docs](https://dune.com/docs/spellbook) * Contribute on [Github](https://github.com/duneanalytics/spellbook) 7228 search results =================== Name Description Column Column Description SQL Tags #### eas\_optimism\_schemas model EAS schema registry on Optimism columns: schema\_uid, schema\_uid Show -2 more {{ config( schema = 'eas\_optimism', alias = 'schemas', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_schemas( blockchain = 'optimism', project = 'eas', version = '1', decoded\_project\_name = 'attestationstation\_v1' ) }} tags: attestation, attestation tags: eas, eas tags: optimism, optimism #### eas\_optimism\_attestations model EAS attestations on Optimism columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid Show -1 more {{ config( schema = 'eas\_optimism', alias = 'attestations', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid'\] ) }} {{ eas\_attestations( blockchain = 'optimism', project = 'eas', version = '1', decoded\_project\_name = 'attestationstation\_v1' ) }} tags: attestation, attestation tags: eas, eas tags: optimism, optimism #### eas\_optimism\_schema\_details model EAS schema registry details on Optimism columns: schema\_uid, schema\_uid columns: ordinality, ordinality Show -1 more {{ config( schema = 'eas\_optimism', alias = 'schema\_details', materialized = 'view', unique\_key = \['schema\_uid', 'ordinality'\] ) }} {{ eas\_schema\_details( blockchain = 'optimism', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: optimism, optimism #### eas\_optimism\_attestation\_details model EAS attestation details on Optimism columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid columns: ordinality, ordinality Show 0 more {{ config( schema = 'eas\_optimism', alias = 'attestation\_details', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid', 'ordinality'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_attestation\_details( blockchain = 'optimism', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: optimism, optimism #### eas\_ethereum\_attestations model EAS attestations on Ethereum columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid Show -1 more {{ config( schema = 'eas\_ethereum', alias = 'attestations', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid'\] ) }} {{ eas\_attestations( blockchain = 'ethereum', project = 'eas', version = '1', decoded\_project\_name = 'ethereum\_attestation\_service' ) }} tags: attestation, attestation tags: eas, eas tags: ethereum, ethereum #### eas\_ethereum\_schemas model EAS schema registry on Ethereum columns: schema\_uid, schema\_uid Show -2 more {{ config( schema = 'eas\_ethereum', alias = 'schemas', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_schemas( blockchain = 'ethereum', project = 'eas', version = '1', decoded\_project\_name = 'ethereum\_attestation\_service\_ethereum\_schema' ) }} tags: attestation, attestation tags: eas, eas tags: ethereum, ethereum #### eas\_ethereum\_schema\_details model EAS schema registry details on Ethereum columns: schema\_uid, schema\_uid columns: ordinality, ordinality Show -1 more {{ config( schema = 'eas\_ethereum', alias = 'schema\_details', materialized = 'view', unique\_key = \['schema\_uid', 'ordinality'\] ) }} {{ eas\_schema\_details( blockchain = 'ethereum', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: ethereum, ethereum #### eas\_ethereum\_attestation\_details model EAS attestation details on Ethereum columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid columns: ordinality, ordinality Show 0 more {{ config( schema = 'eas\_ethereum', alias = 'attestation\_details', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid', 'ordinality'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_attestation\_details( blockchain = 'ethereum', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: ethereum, ethereum #### eas\_base\_schemas model EAS schema registry on Base columns: schema\_uid, schema\_uid Show -2 more {{ config( schema = 'eas\_base', alias = 'schemas', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_schemas( blockchain = 'base', project = 'eas', version = '1', decoded\_project\_name = 'attestationstation\_v1' ) }} tags: attestation, attestation tags: eas, eas tags: base, base #### eas\_base\_attestations model EAS attestations on Base columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid Show -1 more {{ config( schema = 'eas\_base', alias = 'attestations', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid'\] ) }} {{ eas\_attestations( blockchain = 'base', project = 'eas', version = '1', decoded\_project\_name = 'attestationstation\_v1' ) }} tags: attestation, attestation tags: eas, eas tags: base, base #### eas\_base\_schema\_details model EAS schema registry details on Base columns: schema\_uid, schema\_uid columns: ordinality, ordinality Show -1 more {{ config( schema = 'eas\_base', alias = 'schema\_details', materialized = 'view', unique\_key = \['schema\_uid', 'ordinality'\] ) }} {{ eas\_schema\_details( blockchain = 'base', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: base, base #### eas\_base\_attestation\_details model EAS attestation details on Base columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid columns: ordinality, ordinality Show 0 more {{ config( schema = 'eas\_base', alias = 'attestation\_details', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid', 'ordinality'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_attestation\_details( blockchain = 'base', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: base, base #### eas\_arbitrum\_attestations model EAS attestations on Arbitrum columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid Show -1 more {{ config( schema = 'eas\_arbitrum', alias = 'attestations', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid'\] ) }} {{ eas\_attestations( blockchain = 'arbitrum', project = 'eas', version = '1', decoded\_project\_name = 'arbitrum\_eas' ) }} tags: attestation, attestation tags: eas, eas tags: arbitrum, arbitrum #### eas\_arbitrum\_schemas model EAS schema registry on Arbitrum columns: schema\_uid, schema\_uid Show -2 more {{ config( schema = 'eas\_arbitrum', alias = 'schemas', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_schemas( blockchain = 'arbitrum', project = 'eas', version = '1', decoded\_project\_name = 'arbitrum\_eas', uid\_column\_name = 'uuid' ) }} tags: attestation, attestation tags: eas, eas tags: arbitrum, arbitrum #### eas\_arbitrum\_schema\_details model EAS schema registry details on Arbitrum columns: schema\_uid, schema\_uid columns: ordinality, ordinality Show -1 more {{ config( schema = 'eas\_arbitrum', alias = 'schema\_details', materialized = 'view', unique\_key = \['schema\_uid', 'ordinality'\] ) }} {{ eas\_schema\_details( blockchain = 'arbitrum', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: arbitrum, arbitrum #### eas\_arbitrum\_attestation\_details model EAS attestation details on Arbitrum columns: schema\_uid, schema\_uid columns: attestation\_uid, attestation\_uid columns: ordinality, ordinality Show 0 more {{ config( schema = 'eas\_arbitrum', alias = 'attestation\_details', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['schema\_uid', 'attestation\_uid', 'ordinality'\], incremental\_predicates = \[incremental\_predicate('DBT\_INTERNAL\_DEST.block\_time')\] ) }} {{ eas\_attestation\_details( blockchain = 'arbitrum', project = 'eas', version = '1' ) }} tags: attestation, attestation tags: eas, eas tags: arbitrum, arbitrum #### eas\_schemas model EAS schema registry columns: blockchain, blockchain columns: project, project columns: version, version Show 11 more {{ config( schema = 'eas', alias = 'schemas', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['blockchain', 'project', 'version', 'schema\_uid'\], post\_hook = '{{ expose\_spells(\\'\["arbitrum", "base", "ethereum", "optimism", "polygon", "scroll", "celo"\]\\', "sector", "attestation", \\'\["tomfutago"\]\\') }}' ) }} {% set models = \[ ref('eas\_arbitrum\_schemas'), ref('eas\_base\_schemas'), ref('eas\_ethereum\_schemas'), ref('eas\_optimism\_schemas'), ref('eas\_polygon\_schemas'), ref('eas\_scroll\_schemas'), ref('eas\_celo\_schemas') \] %} {% for model in models %} select blockchain, project, version, schema\_uid, registerer, resolver, schema, schema\_array, is\_revocable, contract\_address, block\_number, block\_time, tx\_hash, evt\_index from {{ model }} {% if is\_incremental() %} where {{ incremental\_predicate('block\_time') }} {% endif %} {% if not loop.last %} union all {% endif %} {% endfor %} tags: attestation, attestation tags: eas, eas #### eas\_schema\_details model EAS schema registry details columns: blockchain, blockchain columns: project, project columns: version, version Show 8 more {{ config( schema = 'eas', alias = 'schema\_details', materialized = 'view', unique\_key = \['blockchain', 'project', 'version', 'schema\_uid', 'ordinality'\], post\_hook = '{{ expose\_spells(\\'\["arbitrum", "base", "ethereum", "optimism", "polygon", "scroll", "celo"\]\\', "sector", "attestation", \\'\["tomfutago"\]\\') }}' ) }} {% set models = \[ ref('eas\_arbitrum\_schema\_details'), ref('eas\_base\_schema\_details'), ref('eas\_ethereum\_schema\_details'), ref('eas\_optimism\_schema\_details'), ref('eas\_polygon\_schema\_details'), ref('eas\_scroll\_schema\_details'), ref('eas\_celo\_schema\_details') \] %} {% for model in models %} select blockchain, project, version, schema\_uid, ordinality, data\_type, field\_name, block\_number, block\_time, tx\_hash, evt\_index from {{ model }} {% if not loop.last %} union all {% endif %} {% endfor %} tags: attestation, attestation tags: eas, eas #### eas\_attestations model EAS attestations columns: blockchain, blockchain columns: project, project columns: version, version Show 18 more {{ config( schema = 'eas', alias = 'attestations', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['blockchain', 'project', 'version', 'schema\_uid', 'attestation\_uid'\], post\_hook = '{{ expose\_spells(\\'\["arbitrum", "base", "ethereum", "optimism", "polygon", "scroll", "celo"\]\\', "sector", "attestation", \\'\["tomfutago"\]\\') }}' ) }} {% set models = \[ ref('eas\_arbitrum\_attestations'), ref('eas\_base\_attestations'), ref('eas\_ethereum\_attestations'), ref('eas\_optimism\_attestations'), ref('eas\_polygon\_attestations'), ref('eas\_scroll\_attestations'), ref('eas\_celo\_attestations') \] %} {% for model in models %} select blockchain, project, version, schema\_uid, attestation\_uid, attester, recipient, request, is\_revocable, ref\_uid, raw\_data, raw\_value, expiration\_time, revocation\_time, attestation\_state, is\_revoked, contract\_address, block\_number, block\_time, tx\_hash, evt\_index from {{ model }} {% if is\_incremental() %} where {{ incremental\_predicate('block\_time') }} {% endif %} {% if not loop.last %} union all {% endif %} {% endfor %} tags: attestation, attestation tags: eas, eas #### eas\_attestation\_details model EAS attestation details columns: blockchain, blockchain columns: project, project columns: version, version Show 11 more {{ config( schema = 'eas', alias = 'attestation\_details', materialized = 'incremental', file\_format = 'delta', incremental\_strategy = 'merge', unique\_key = \['blockchain', 'project', 'version', 'schema\_uid', 'attestation\_uid', 'ordinality'\], post\_hook = '{{ expose\_spells(\\'\["arbitrum", "base", "ethereum", "optimism", "polygon", "scroll", "celo"\]\\', "sector", "attestation", \\'\["tomfutago"\]\\') }}' ) }} {% set models = \[ ref('eas\_arbitrum\_attestation\_details'), ref('eas\_base\_attestation\_details'), ref('eas\_ethereum\_attestation\_details'), ref('eas\_optimism\_attestation\_details'), ref('eas\_polygon\_attestation\_details'), ref('eas\_scroll\_attestation\_details'), ref('eas\_celo\_attestation\_details') \] %} {% for model in models %} select blockchain, project, version, schema\_uid, attestation\_uid, ordinality, data\_type, field\_name, decoded\_data, block\_number, block\_time, tx\_hash, evt\_index from {{ model }} {% if is\_incremental() %} where {{ incremental\_predicate('block\_time') }} {% endif %} {% if not loop.last %} union all {% endif %} {% endfor %} tags: attestation, attestation tags: eas, eas Show 7208 more Refocus on NodeView documentationHide this and parentsHide this and childrenExport PNG ---