Add freshness test and update test to warning

[chuxinh]

Description

• Add freshness test to harmony db for main tables
• Change test from error to warning before implementing dbt test on dbt cloud for harmony db

Tests

• [x] Please provide evidence of your successful dbt run / dbt test here

  
  dbt source freshness
  Running with dbt=0.21.1
  Found 44 models, 382 tests, 0 snapshots, 0 analyses, 180 macros, 0 operations, 8 seed files, 21 sources, 0 exposures

12:13:26 | Concurrency: 4 threads (target='dev') 12:13:26 | 12:13:26 | 1 of 17 START freshness of chainwalkers.harmony_blocks............... [RUN] 12:13:26 | 2 of 17 START freshness of chainwalkers.harmony_txs.................. [RUN] 12:13:26 | 3 of 17 START freshness of harmony.blocks............................ [RUN] 12:13:26 | 4 of 17 START freshness of harmony.btc_bridge........................ [RUN] 12:13:30 | 4 of 17 PASS freshness of harmony.btc_bridge......................... [PASS in 3.46s] 12:13:30 | 5 of 17 START freshness of harmony.dfk_bank_transactions............. [RUN] 12:13:30 | 1 of 17 PASS freshness of chainwalkers.harmony_blocks................ [PASS in 4.05s] 12:13:30 | 6 of 17 START freshness of harmony.dfk_hero_rental................... [RUN] 12:13:30 | 3 of 17 PASS freshness of harmony.blocks............................. [PASS in 4.28s] 12:13:30 | 7 of 17 START freshness of harmony.dfk_hero_summons.................. [RUN] 12:13:31 | 2 of 17 PASS freshness of chainwalkers.harmony_txs................... [PASS in 4.53s] 12:13:31 | 8 of 17 START freshness of harmony.dfk_hero_updates.................. [RUN] 12:13:33 | 5 of 17 PASS freshness of harmony.dfk_bank_transactions.............. [PASS in 3.11s] 12:13:33 | 9 of 17 START freshness of harmony.dfk_item_transactions............. [RUN] 12:13:33 | 6 of 17 PASS freshness of harmony.dfk_hero_rental.................... [PASS in 2.78s] 12:13:33 | 10 of 17 START freshness of harmony.dfk_potions_crafted.............. [RUN] 12:13:33 | 7 of 17 PASS freshness of harmony.dfk_hero_summons................... [PASS in 2.95s] 12:13:33 | 11 of 17 START freshness of harmony.dfk_quest_rewards................ [RUN] 12:13:36 | 10 of 17 PASS freshness of harmony.dfk_potions_crafted............... [PASS in 3.09s] 12:13:36 | 12 of 17 START freshness of harmony.dfk_seed_harvests................ [RUN] 12:13:36 | 8 of 17 PASS freshness of harmony.dfk_hero_updates................... [PASS in 5.46s] 12:13:36 | 9 of 17 PASS freshness of harmony.dfk_item_transactions.............. [PASS in 3.40s] 12:13:36 | 13 of 17 START freshness of harmony.dfk_seed_liquidity_actions....... [RUN] 12:13:36 | 14 of 17 START freshness of harmony.logs............................. [RUN] 12:13:38 | 11 of 17 PASS freshness of harmony.dfk_quest_rewards................. [PASS in 4.89s] 12:13:38 | 15 of 17 START freshness of harmony.swaps............................ [RUN] 12:13:39 | 12 of 17 PASS freshness of harmony.dfk_seed_harvests................. [PASS in 3.05s] 12:13:39 | 16 of 17 START freshness of harmony.transfers........................ [RUN] 12:13:40 | 13 of 17 PASS freshness of harmony.dfk_seed_liquidity_actions........ [PASS in 3.78s] 12:13:40 | 17 of 17 START freshness of harmony.txs.............................. [RUN] 12:13:48 | 15 of 17 PASS freshness of harmony.swaps............................. [PASS in 9.41s] 12:14:04 | 16 of 17 PASS freshness of harmony.transfers......................... [PASS in 24.83s] 12:14:14 | 17 of 17 PASS freshness of harmony.txs............................... [PASS in 34.34s] 12:14:19 | 14 of 17 PASS freshness of harmony.logs.............................. [PASS in 43.11s] 12:14:19 | Done.

- [ ] Any comparison between `prod` and `dev` for any schema change

# Checklist
- [x] Follow [dbt style guide](https://github.com/dbt-labs/corp/blob/main/dbt_style_guide.md)
- [x] Tag the person(s) responsible for reviewing proposed changes
- [x] Notes to deployment, if a `full-refresh` is needed for any table: add dbt test to incremental build for Harmony
- [ ] Run `dbt docs generate` to update the documentation files if this PR is changing the models in any way.

[netlify[bot]]

✅ Deploy Preview for mdao-harmony canceled.

Name	Link
🔨 Latest commit	75621563ec0494a466ef069bdca283ab21f80d2d
🔍 Latest deploy log	https://app.netlify.com/sites/mdao-harmony/deploys/628a2a9e5c92c20008a694cd