FlipsideCrypto / crosschain-models

MIT License
4 stars 6 forks source link

AN-4784/prices-deprecations #350

Closed drethereum closed 3 months ago

drethereum commented 3 months ago
  1. Deletes legacy models, deprecated tables/columns and renames new pipeline models, removing 2 suffix
  2. Removes v1 pipeline from workflow runs

STEPS

  1. FR prices pipeline to capture updated names (~25 min) and run incremental on 2xl for imputing gaps (~20 min) dbt run -m models/bronze/prices models/silver/prices models/gold/price --full-refresh --exclude models/bronze/prices/_legacy models/silver/prices/_legacy && dbt run -m models/bronze/prices models/silver/prices models/gold/price --exclude models/bronze/prices/_legacy models/silver/prices/_legacy (use deployment job)
  2. Update permissions if necessary / revoke perms for deprecated gold views
  3. FR downstream models (after prices/downstream pipelines are FR'd in each chain) dbt run -m models/silver/defi/silver__complete_bridge_activity.sql models/silver/defi/silver__complete_dex_swaps.sql --full-refresh