delegator table sql

[geewynn]

Description

sql query to create delegator table

74

Tests

dbt run

root@c8d64235b3fa:/harmony# dbt run --select delegators
Running with dbt=0.21.1
Found 45 models, 389 tests, 0 snapshots, 0 analyses, 180 macros, 0 operations, 8 seed files, 6 sources, 0 exposures

09:12:18 | Concurrency: 4 threads (target='dev')
09:12:18 | 
09:12:18 | 1 of 1 START incremental model DEV.delegators........................ [RUN]
09:12:25 | 1 of 1 OK created incremental model DEV.delegators................... [SUCCESS 1 in 7.25s]
09:12:25 | 
09:12:25 | Finished running 1 incremental model in 13.24s.

Completed successfully

Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1

dbt test

root@c8d64235b3fa:/harmony# dbt test --select delegators
Running with dbt=0.21.1
Found 45 models, 389 tests, 0 snapshots, 0 analyses, 180 macros, 0 operations, 8 seed files, 6 sources, 0 exposures

09:11:22 | Concurrency: 4 threads (target='dev')
09:11:22 | 
09:11:22 | 1 of 7 START test not_null_delegators_day_date....................... [RUN]
09:11:22 | 2 of 7 START test not_null_delegators_delegator_address.............. [RUN]
09:11:22 | 3 of 7 START test not_null_delegators_delegator_reward............... [RUN]
09:11:22 | 4 of 7 START test not_null_delegators_total_amount_delegated......... [RUN]
09:11:26 | 4 of 7 PASS not_null_delegators_total_amount_delegated............... [PASS in 3.76s]
09:11:26 | 5 of 7 START test not_null_delegators_total_amount_undelegated....... [RUN]
09:11:26 | 1 of 7 PASS not_null_delegators_day_date............................. [PASS in 3.99s]
09:11:26 | 6 of 7 START test not_null_delegators_u_key.......................... [RUN]
09:11:26 | 3 of 7 PASS not_null_delegators_delegator_reward..................... [PASS in 4.02s]
09:11:26 | 7 of 7 START test unique_delegators_u_key............................ [RUN]
09:11:26 | 2 of 7 PASS not_null_delegators_delegator_address.................... [PASS in 4.13s]
09:11:29 | 7 of 7 PASS unique_delegators_u_key.................................. [PASS in 3.15s]
09:11:29 | 5 of 7 PASS not_null_delegators_total_amount_undelegated............. [PASS in 3.68s]
09:11:29 | 6 of 7 PASS not_null_delegators_u_key................................ [PASS in 3.45s]
09:11:29 | 
09:11:29 | Finished running 7 tests in 10.47s.

Completed successfully

Done. PASS=7 WARN=0 ERROR=0 SKIP=0 TOTAL=7

@antonyip @chuxinh @forgxyz

Checklist

• [x] Follow dbt style guide
• [x] Tag the person(s) responsible for reviewing proposed changes
• [ ] Notes to deployment, if a full-refresh is needed for any table
• [x] 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 ready!

Name	Link
🔨 Latest commit	c8ab220b12eb2bee1b7e49438ebc12ed7cc9e5d3
🔍 Latest deploy log	https://app.netlify.com/sites/mdao-harmony/deploys/628e3486c29a3600084ce133
😎 Deploy Preview	https://deploy-preview-116--mdao-harmony.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site settings.