General: Global Project Variables - FlipsideCrypto/fsc-evm GitHub Wiki

Model/function variables are set and managed in each repo's dbt_project.yml file, or the models/functions themselves. Please see the fsc-evm installation instructions in the README or the Installing fsc-evm guide for more details on how to access and utilize variables effectively.


Overview

  • This document is intended to track all available GLOBAL level project variables, which are managed in each repo's dbt_project.yml.
  • When adding a new variable to an fsc-evm release version, please add a new row in the following table. If a variable requires further detail, examples, implementation instructions etc. please create a separate Tech Specs document or Guide in the wiki.
  • All variables documented here should include the prefix GLOBAL_. If the variable does not include that prefix, it's likely not a global project variable and should be documented elsewhere (the model/function's tech specs doc).

Note, if no default values exist for the model, use a dash - for each column value.


Variable Type Default Required Description
GLOBAL_PROD_DB_NAME String - Yes Name of the chain or prod database
GLOBAL_NODE_SECRET_PATH String - Yes Secret path for the node
GLOBAL_BLOCKS_PER_HOUR Number - Yes Number of blocks produced per hour
GLOBAL_NODE_URL String '{Service}/{Authentication}' No URL for posting requests
GLOBAL_PROD_NETWORK String 'mainnet' No Network version
GLOBAL_USES_RECEIPTS_BY_HASH Bool False No Use receipts method by hash with LQ instead of by block default
GLOBAL_USES_BASE_FEE Bool True No Include columns for base gas fee in fact_blocks
GLOBAL_AVG_TXS_PER_BLOCK Number - No Only used if GLOBAL_USES_RECEIPTS_BY_HASH is True
GLOBAL_BLOCKS_TOTAL_TO_BACKFILL Number - No Used for backfills
GLOBAL_START_UP_BLOCK Number 0 No Override to start up a chain at a specific block
GLOBAL_MAX_SEQUENCE_NUMBER Number 100000000 No Used to trim the sequence spine for streamline__blocks model
GLOBAL_USES_PARTITION_KEY Bool True No If false, uses _partition_by_block_id