dbt_project.yml

#Welcome to your Spellbook!

name: "spellbook"
version: "1.0.0"
config-version: 2

# This setting configures which "profile" dbt uses for this project.
profile: "spellbook"

vars:
  DBT_ENV_CUSTOM_ENV_S3_BUCKET: "{{ env_var('DBT_ENV_CUSTOM_ENV_S3_BUCKET', 'local') }}"

# These configurations specify where dbt should look for different types of files.
# You don't need to change these!
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

target-path: "target" # directory which will store compiled SQL files
clean-targets: # directories to be removed by `dbt clean`
  - "target"
  - "dbt_packages"

#quoting:
#  identifier: true

# Configuring tests
# Full documentation: https://docs.getdbt.com/reference/test-configs
tests:
  spellbook:
    +store_failures: true  # store failures for all tests

# Configureing seeds
# Full documentation: https://docs.getdbt.com/reference/seed-configs
# For configuring individual seeds (e.g. overriding column types) we recommend a yml file nested in the same folder as the seed
# example: seeds/cryptopunks/schema.yml
seeds:
  +quote_columns: true
  spellbook:
    +schema: test_data


# Configuring models
# Full documentation: https://docs.getdbt.com/docs/configuring-models
models:
  spellbook:
    +post-hook:
      - sql: "{{ optimize_spell(this, model.config.materialized) }}"
        transaction: true
      - sql: "{{ mark_as_spell(this, model.config.materialized) }}"
        transaction: true
    +materialized: view
    +schema: no_schema    # this should be overriden in model specific configs

    aave:
      +schema: aave
      ethereum:
        +schema: aave_ethereum
      optimism:
        +schema: aave_optimism

    aavegotchi:
      +schema: aavegotchi
      polygon:
        +schema: aavegotchi_polygon

    balancer:
      +schema: balancer
      arbitrum:
        +schema: balancer_arbitrum
      ethereum:
        +schema: balancer_ethereum
      polygon:
        +schema: balancer_polygon
      optimism:
        +schema: balancer_optimism
      gnosis:
        +schema: balancer_gnosis

    ens:
      +schema: ens

    airdrop:
      +schema: airdrop
      +materialized: table
      optimism:
        +schema: airdrop_optimism
        +materialized: table

    staking:
      +schema: staking
      ethereum:
        +schema: staking_ethereum

    dex:
      +schema: dex

    nft:
      +schema: nft
      arbitrum:
        +schema: nft_arbitrum
      avalanche_c:
        +schema: nft_avalanche_c
      bnb:
        +schema: nft_bnb
      ethereum:
        +schema: nft_ethereum
        metadata:
          +schema: nft_ethereum_metadata
          +materialized: table
          +file_format: delta
          +tags: "static"
      gnosis:
        +schema: nft_gnosis
      optimism:
        +schema: nft_optimism
      polygon:
        +schema: nft_polygon
      fantom:
        +schema: nft_fantom
      goerli:
        +schema: nft_goerli

    compound:
      +schema: compound
      ethereum:
        +schema: compound_ethereum

    gitcoin:
      +schema: gitcoin
      ethereum:
        +schema: gitcoin_ethereum

    uniswap:
      +schema: uniswap
      arbitrum:
        +schema: uniswap_arbitrum
      ethereum:
        +schema: uniswap_ethereum
      optimism:
        +schema: uniswap_optimism
      polygon:
        +schema: uniswap_polygon
      bnb:
        +schema: uniswap_bnb

    quickswap:
      +schema: quickswap
      polygon:
        +schema: quickswap_polygon

    paraswap:
      +schema: paraswap
      avalanche_c:
        +schema: paraswap_avalanche_c
      fantom:
        +schema: paraswap_fantom

    nomiswap:
      +schema: nomiswap
      bnb:
        +schema: nomiswap_bnb

    maverick:
      +schema: maverick
      ethereum:
        +schema: maverick_ethereum

    sushiswap:
      +schema: sushiswap
      ethereum:
        +schema: sushiswap_ethereum
      avalanche_c:
        +schema: sushiswap_avalanche_c
      gnosis:
        +schema: sushiswap_gnosis
      arbitrum:
        +schema: sushiswap_arbitrum
      fantom:
        +schema: sushiswap_fantom
      optimism:
        +schema: sushiswap_optimism

    openocean:
      +schema: openocean
      fantom:
        +schema: openocean_fantom
      avalanche_c:
        +schema: openocean_avalanche_c

    babyswap:
      +schema: babyswap
      bnb:
        +schema: babyswap_bnb

    oneplanet:
      +schema: oneplanet
      polygon:
        +schema: oneplanet_polygon

    opensea:
      +schema: opensea
      ethereum:
        +schema: opensea_ethereum
      solana:
        +schema: opensea_solana

    element:
      +schema: element
      ethereum:
        +schema: element_ethereum
      bnb:
        +schema: element_bnb
      avalanche_c:
        +schema: element_avalanche_c


#    abi:
#      +schema: abi

    superrare:
      +schema: superrare
    looksrare:
      +schema: looksrare
      ethereum:
        +schema: looksrare_ethereum
    foundation:
      +schema: foundation
      ethereum:
        +schema: foundation_ethereum
    blur:
      +schema: blur
      ethereum:
        +schema: blur_ethereum
        
    stealcam:
      +schema: stealcam
      arbitrum:
        +schema: stealcam_arbitrum

    gas:
      +schema: gas
      ethereum:
        +schema: gas_ethereum
      bnb:
        +schema: gas_bnb
      avalanche_c:
        +schema: gas_avalanche_c
      optimism:
        +schema: gas_optimism
      arbitrum:
        +schema: gas_arbitrum

    gmx:
      +schema: gmx
      arbitrum:
        +schema: gmx_arbitrum
      avalanche_c:
        +schema: gmx_avalanche_c

    tigris:
      +schema: tigris
      arbitrum:
        +schema: tigris_arbitrum
      polygon:
        +schema: tigris_polygon

    x2y2:
      +schema: x2y2
      ethereum:
        +schema: x2y2_ethereum
    zora:
      +schema: zora
      ethereum:
        +schema: zora_ethereum
    magiceden:
      +schema: magiceden
      polygon:
        +schema: magiceden_polygon
      solana:
        +schema: magiceden_solana

    nomad:
      +schema: nomad
      ethereum:
        +schema: nomad_ethereum

    ellipsis_finance:
      +schema: ellipsis_finance
      bnb:
        +schema: ellipsis_finance_bnb

    wigoswap:
      +schema: wigoswap
      fantom:
        +schema: wigoswap_fantom

    bend_dao:
      +schema: bend_dao
      ethereum:
        +schema: bend_dao_ethereum

    seaport:
      +schema: seaport
      ethereum:
        +schema: seaport_ethereum
      bnb:
        +schema: seaport_bnb
      arbitrum:
        +schema: seaport_arbitrum
      optimism:
        +schema: seaport_optimism
      avalanche_c:
        +schema: seaport_avalanche_c
      polygon:
        +schema: seaport_polygon

    balances:
      +schema: balances
      ethereum:
        +schema: balances_ethereum

    dodo:
      +schema: dodo
      ethereum:
        +schema: dodo_ethereum
      bnb:
        +schema: dodo_bnb
      polygon:
        +schema: dodo_polygon
      arbitrum:
        +schema: dodo_arbitrum
      optimism:
        +schema: dodo_optimism


    spookyswap:
      +schema: spookyswap
      fantom:
        +schema: spookyswap_fantom

    labels:
      +schema: labels
      +materialized: table
      +file_format: delta

    dao:
      +schema: dao

    addresses:
      +schema: addresses
      ethereum:
        +schema: addresses_ethereum
      optimism:
        +schema: addresses_optimism

    addresses_events:
      +schema: addresses_events
      arbitrum:
        +schema: addresses_events_arbitrum
      avalanche_c:
        +schema: addresses_events_avalanche_c
      bnb:
        +schema: addresses_events_bnb
      ethereum:
        +schema: addresses_events_ethereum
      fantom:
        +schema: addresses_events_fantom
      gnosis:
        +schema: addresses_events_gnosis
      optimism:
        +schema: addresses_events_optimism
      polygon:
        +schema: addresses_events_polygon
    addresses_events_testnets:
      +schema: addresses_events_testnets
      goerli:
        +schema: addresses_events_testnets_goerli

    aztec:
      +schema: aztec
      ethereum:
        +schema: aztec_ethereum

    tokens:
      +schema: tokens
      +materialized: table
      +file_format: delta
      ethereum:
        +schema: tokens_ethereum
        +materialized: table
        +file_format: delta
      optimism:
        +schema: tokens_optimism
        +materialized: table
        +file_format: delta
      avalanche_c:
        +schema: tokens_avalanche_c
        +materialized: table
        +file_format: delta
      bnb:
        +schema: tokens_bnb
        +materialized: table
        +file_format: delta
      gnosis:
        +schema: tokens_gnosis
        +materialized: table
        +file_format: delta
      arbitrum:
        +schema: tokens_arbitrum
        +materialized: table
        +file_format: delta
      polygon:
        +schema: tokens_polygon
        +materialized: table
        +file_format: delta
      fantom:
        +schema: tokens_fantom
        +materialized: table
        +file_format: delta
      solana:
        +schema: tokens_solana
        +materialized: table
        +file_format: delta

    trader_joe:
      +schema: trader_joe
      avalanche_c:
        +schema: trader_joe_avalanche_c

    odos:
      +schema: odos
      avalanche_c:
        +schema: odos_avalanche_c

    transfers:
      +schema: transfers
      ethereum:
        +schema: transfers_ethereum
      optimism:
        +schema: transfers_optimism
      bnb:
        +schema: transfers_bnb
      arbitrum:
        +schema: transfers_arbitrum
      polygon:
        +schema: transfers_polygon
      avalanche_c:
        +schema: transfers_avalanche_c
      fantom:
        +schema: transfers_fantom

    sudoswap:
      +schema: sudoswap
      ethereum:
        +schema: sudoswap_ethereum

    equalizer_exchange:
      +schema: equalizer_exchange
      fantom:
        +schema: equalizer_exchange_fantom

    safe:
      +schema: safe
      ethereum:
        +schema: safe_ethereum
      optimism:
        +schema: safe_optimism
      gnosis:
        +schema: safe_gnosis
      polygon:
        +schema: safe_polygon
      bnb:
        +schema: safe_bnb
      avalanche_c:
        +schema: safe_avalanche_c
      fantom:
        +schema: safe_fantom
      arbitrum:
        +schema: safe_arbitrum

    liquidifty:
      +schema: liquidifty
      bnb:
        +schema: liquidifty_bnb
      ethereum:
        +schema: liquidifty_ethereum

    nftb:
      +schema: nftb
      bnb:
        +schema: nftb_bnb

    nftrade:
      +schema: nftrade
      bnb:
        +schema: nftrade_bnb


    trove:
      +schema: trove
      arbitrum:
        +schema: trove_arbitrum
      ethereum:
        +schema: trove_ethereum

    lifi:
      +schema: lifi
      fantom:
        +schema: lifi_fantom

    spiritswap:
      +schema: spiritswap
      fantom:
        +schema: spiritswap_fantom

    jarvis_network:
      +schema: jarvis_network
      polygon:
        +schema: jarvis_network_polygon

    cryptopunks:
      +schema: cryptopunks
      ethereum:
        +schema: cryptopunks_ethereum

    spaceid:
      +schema: spaceid
      bnb:
        +schema: spaceid_bnb

    spartacus_exchange:
      +schema: spartacus_exchange
      fantom:
        +schema: spartacus_exchange_fantom

    tornado_cash:
      +schema: tornado_cash

    perpetual:
      +schema: perpetual

    perpetual_protocol:
      +schema: perpetual_protocol
      optimism:
        +schema: perpetual_protocol_optimism

    pika:
      +schema: pika
      optimism:
        +schema: pika_optimism

    synthetix:
      +schema: synthetix
      optimism:
        +schema: synthetix_optimism

    archipelago:
      +schema: archipelago
      ethereum:
        +schema: archipelago_ethereum

    integration_test:
      +schema: integration_test

    curvefi:
      +schema: curvefi
      ethereum:
        +schema: curvefi_ethereum
      optimism:
        +schema: curvefi_optimism
      avalanche_c:
        +schema: curvefi_avalanche_c
      fantom:
        +schema: curvefi_fantom

    cow_protocol:
      +schema: cow_protocol
      ethereum:
        +schema: cow_protocol_ethereum
      gnosis:
        +schema: cow_protocol_gnosis

    ironbank:
      +schema: ironbank
      ethereum:
        +schema: ironbank_ethereum
      optimism:
        +schema: ironbank_optimism

    keep3r_network:
      +schema: keep3r_network
      ethereum:
        +schema: keep3r_network_ethereum

    airswap:
      +schema: airswap
      ethereum:
        +schema: airswap_ethereum

    apeswap:
      +schema: apeswap
      ethereum:
        +schema: apeswap_ethereum
      bnb:
        +schema: apeswap_bnb
      polygon:
        +schema: apeswap_polygon

    chainlink:
      +schema: chainlink
      optimism:
        +schema: chainlink_optimism
      polygon:
        +schema: chainlink_polygon
      bnb:
        +schema: chainlink_bnb

    contracts:
      +schema: contracts
      optimism:
        +schema: contracts_optimism
      bnb:
        +schema: contracts_bnb
      fantom:
        +schema: contracts_fantom

    clipper:
      +schema: clipper
      ethereum:
        +schema: clipper_ethereum
      arbitrum:
        +schema: clipper_arbitrum

    reaper:
      +schema: reaper
      optimism:
        +schema: reaper_optimism

    biswap:
      +schema: biswap
      bnb:
        +schema: biswap_bnb

    defiswap:
      +schema: defiswap
      ethereum:
        +schema: defiswap_ethereum

    mdex:
      +schema: mdex
      bnb:
        +schema: mdex_bnb

    swapr:
      +schema: swapr
      ethereum:
        +schema: swapr_ethereum

    dfx:
      +schema: dfx
      ethereum:
        +schema: dfx_ethereum

    yield_yak:
      +schema: yield_yak
      avalanche_c:
        +schema: yield_yak_avalanche_c

    shibaswap:
      +schema: shibaswap
      ethereum:
        +schema: shibaswap_ethereum

    velodrome:
      +schema: velodrome
      optimism:
        +schema: velodrome_optimism

    zigzag:
      +schema: zigzag
      arbitrum:
        +schema: zigzag_arbitrum

    pancakeswap:
      +schema: pancakeswap
      bnb:
        +schema: pancakeswap_bnb
      ethereum:
        +schema: pancakeswap_ethereum

    bancor:
      +schema: bancor
      ethereum:
        +schema: bancor_ethereum

    kyberswap:
      +schema: kyberswap
      avalanche_c:
        +schema: kyberswap_avalanche_c
      optimism:
        +schema: kyberswap_optimism

    hubble_exchange:
      +schema: hubble_exchange
      avalanche_c:
        +schema: hubble_exchange_avalanche_c

    fraxswap:
      +schema: fraxswap
      avalanche_c:
        +schema: fraxswap_avalanche_c
      bnb:
        +schema: fraxswap_bnb
      polygon:
        +schema: fraxswap_polygon
      ethereum:
        +schema: fraxswap_ethereum

    mstable:
      +schema: mstable
      ethereum:
        +schema: mstable_ethereum

    platypus_finance:
      +schema: platypus_finance
      avalanche_c:
        +schema: platypus_finance_avalanche_c

    emdx:
      +schema: emdx
      avalanche_c:
        +schema: emdx_avalanche_c

    woofi:
      +schema: woofi
      avalanche_c:
        +schema: woofi_avalanche_c
      bnb:
        +schema: woofi_bnb

    hashflow:
      +schema: hashflow
      ethereum:
        +schema: hashflow_ethereum
      avalanche_c:
        +schema: hashflow_avalanche_c
      bnb:
        +schema: hashflow_bnb

    nexusmutual:
      +schema: nexusmutual
      ethereum:
        +schema: nexusmutual_ethereum

    quix:
      +schema: quix
      optimism:
        +schema: quix_optimism

    zeroex:
      +schema: zeroex
      ethereum:
        +schema: zeroex_ethereum
      optimism:
        +schema: zeroex_optimism

      polygon:
        +schema: zeroex_polygon

      avalanche_c:
        +schema: zeroex_avalanche_c
      fantom:
        +schema: zeroex_fantom

      arbitrum:
        +schema: zeroex_arbitrum


    wombat:
      +schema: wombat
      bnb:
        +schema: wombat_bnb

    iziswap:
      +schema: iziswap
      bnb:
        +schema: iziswap_bnb

    hop_protocol:
      +schema: hop_protocol
      optimism:
        +schema: hop_protocol_optimism
      # ethereum:
      #   +schema: hop_protocol_ethereum
      # polygon:
      #   +schema: hop_protocol_polygon
      # polygon2:
      #   +schema: hop_polygon
      # arbitrum:
      #   +schema: hop_protocol_arbitrum
      # gnosis:
      #   +schema: hop_protocol_gnosis
      # gnosis2:
      #   +schema: hop_gnosis

    chain_info:
      +schema: chain_info

    bridge:
      +schema: bridge
      optimism:
        +schema: bridge_optimism

    the_granary:
      +schema: the_granary
      optimism:
        +schema: the_granary_optimism

    tessera:
      +schema: tessera
      ethereum:
        +schema: tessera_ethereum

    tofu:
      +schema: tofu
      bnb:
        +schema: tofu_bnb
      arbitrum:
        +schema: tofu_arbitrum
      optimism:
        +schema: tofu_optimism

    maker:
      +schema: maker
      ethereum:
        +schema: maker_ethereum

    ovm:
      +schema: ovm
      optimism:
        +schema: ovm_optimism

    op:
      +schema: op
      token_distributions:
        +schema: op_token_distributions
        optimism:
          +schema: op_token_distributions_optimism
      op_chains:
        +schema: op_chains
      op_token:
        optimism:
          +schema: op_token_optimism

    rubicon:
      +schema: rubicon
      optimism:
        +schema: rubicon_optimism

    beethoven_x:
      +schema: beethoven_x
      optimism:
        +schema: beethoven_x_optimism
      fantom:
        +schema: beethoven_x_fantom

    zipswap:
      +schema: zipswap
      optimism:
        +schema: zipswap_optimism

    sharky:
      +schema: sharky
      solana:
        +schema: sharky_solana

    arbswap:
      +schema: arbswap

    rocifi:
      +schema: rocifi
      polygon:
        +schema: rocifi_polygon

    oneinch:
      +schema: oneinch
      ethereum:
        +schema: oneinch_ethereum
        
    nftearth:
      +schema: nftearth
      optimism:
        +schema: nftearth_optimism

    zonic:
      +schema: zonic
      optimism:
        +schema: zonic_optimism

    pooltogether:
      +schema: pooltogether
      ethereum:
        +schema: pooltogether_ethereum

    method_ids:
      +schema: method_ids
      
    coinbase_wallet_quests:
      +schema: coinbase_wallet_quests
      optimism:
        +schema: coinbase_wallet_quests_optimism

    optimism_quests:
      +schema: optimism_quests
      optimism:
        +schema: optimism_quests_optimism

    fractal:
      +schema: fractal
      polygon:
        +schema: fractal_polygon

    rarible:
      +schema: rarible
      polygon:
        +schema: rarible_polygon

    optimism_attestationstation:
      +schema: optimism_attestationstation
      optimism:
        +schema: optimism_attestationstation_optimism