fsc-evm/models/sources.yml

version: 2

sources:
  - name: snowflake_account_usage
    database: snowflake
    schema: account_usage
    tables:
      - name: complete_task_graphs
  - name: github_actions
    database: "{{ target.database }}"
    schema: github_actions
    tables:
      - name: workflows
  - name: bronze_streamline
    database: "{{ target.database }}"
    schema: streamline      
    tables:
      - name: blocks
      - name: blocks_v2
      - name: transactions
      - name: transactions_v2
      - name: receipts_by_hash
      - name: receipts
      - name: receipts_v2
      - name: traces
      - name: traces_v2
      - name: debug_traceblockbynumber
      - name: confirm_blocks
      - name: confirm_blocks_v2
      - name: decoded_logs
      - name: decoded_logs_v2
      - name: decoded_traces
      - name: decoded_traces_v2
      - name: contract_abis
      - name: contract_abis_v2
      - name: beacon_blocks
      - name: beacon_blocks_v2
      - name: beacon_validators
      - name: beacon_validators_v2
      - name: reads
      - name: reads_v2
      - name: state_tracer
      - name: token_reads
      - name: balances_erc20
      - name: balances_native
      - name: contract_reads
  - name: complete_streamline
    database: "{{ target.database }}"
    schema: streamline
    tables:
      - name: complete_contract_abis
  - name: crosschain_silver
    database: >-
      {{ 'CROSSCHAIN_DEV' if '_DEV' in target.database.upper() else 'CROSSCHAIN' }}      
    schema: silver
    tables:
      - name: labels_combined
      - name: complete_provider_asset_metadata
      - name: complete_native_asset_metadata
      - name: complete_native_prices
      - name: complete_provider_prices
      - name: complete_token_asset_metadata
      - name: complete_token_prices
      - name: near_address_encoded
      - name: tokens_stablecoins
  - name: crosschain_public
    database: crosschain
    schema: bronze_public
    tables:
      - name: user_abis
  - name: crosschain_gold
    database: crosschain
    schema: core
    tables:
      - name: dim_dates
  - name: crosschain_chain_stats
    database: crosschain
    schema: chain_stats
    tables:
      - name: ez_arbitrum_allowlist
      - name: ez_avalanche_allowlist
      - name: ez_base_allowlist
      - name: ez_bob_allowlist
      - name: ez_boba_allowlist
      - name: ez_bsc_allowlist
      - name: ez_ethereum_allowlist
      - name: ez_ink_allowlist
      - name: ez_optimism_allowlist
      - name: ez_polygon_allowlist
      - name: ez_arbitrum_address_metrics
      - name: ez_avalanche_address_metrics
      - name: ez_base_address_metrics
      - name: ez_bob_address_metrics
      - name: ez_boba_address_metrics
      - name: ez_bsc_address_metrics
      - name: ez_ethereum_address_metrics
      - name: ez_ink_address_metrics
      - name: ez_optimism_address_metrics
      - name: ez_polygon_address_metrics
      - name: ez_arbitrum_metrics_daily
      - name: ez_avalanche_metrics_daily
      - name: ez_base_metrics_daily
      - name: ez_bob_metrics_daily
      - name: ez_boba_metrics_daily
      - name: ez_bsc_metrics_daily
      - name: ez_ethereum_metrics_daily
      - name: ez_ink_metrics_daily
      - name: ez_optimism_metrics_daily
      - name: ez_polygon_metrics_daily
      - name: ez_arbitrum_protocol_metrics
      - name: ez_avalanche_protocol_metrics
      - name: ez_base_protocol_metrics
      - name: ez_bob_protocol_metrics
      - name: ez_boba_protocol_metrics
      - name: ez_bsc_protocol_metrics
      - name: ez_ethereum_protocol_metrics
      - name: ez_ink_protocol_metrics
      - name: ez_optimism_protocol_metrics
      - name: ez_polygon_protocol_metrics
  - name: abis_silver
    database: "{{ target.database }}"
    schema: silver
    tables:
      - name: verified_abis
      - name: complete_event_abis
  - name: data_science_silver
    database: datascience
    schema: silver
    tables:
      - name: evm_event_sigs
      - name: evm_known_event_names
      - name: evm_known_event_sigs
      - name: evm_wrapped_assets
      - name: dates
      - name: scoring_activity_categories
  - name: fsc_evm_admin
    database: >-
      {{ 'FSC_EVM_DEV' if '_DEV' in target.database.upper() else 'FSC_EVM' }}      
    schema: admin
    tables:
      - name: _master_keys
      - name: rpc_node_logs
  - name: silver_tvl_optimism
    database: optimism
    schema: silver_tvl
    tables:
      - name: etherfi_v1_tvl
  - name: silver_tvl_arbitrum
    database: arbitrum
    schema: silver_tvl
    tables:
      - name: etherfi_v1_tvl
  - name: silver_tvl_base
    database: base
    schema: silver_tvl
    tables:
      - name: etherfi_v1_tvl
  - name: gold_gov_monad
    database: monad
    schema: gov
    tables:
      - name: ez_staking_balances_daily
  - name: ethereum_beacon_chain
    database: >-
      {{ 'ETHEREUM_DEV' if '_DEV' in target.database.upper() else 'ETHEREUM' }}      
    schema: beacon_chain
    tables:
      - name: fact_validators
      - name: fact_blocks