Description

Added gas used to the transaction table.

Tests

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

dbt run


root@08618cd2dc1f:/harmony# dbt run --select txs --full-refresh
Running with dbt=0.21.1
Found 47 models, 398 tests, 0 snapshots, 0 analyses, 182 macros, 0 operations, 10 seed files, 21 sources, 0 exposures

11:13:26 | Concurrency: 4 threads (target='dev') 11:13:26 | 11:13:26 | 1 of 1 START incremental model DEV.txs............................... [RUN] 12:05:10 | 1 of 1 OK created incremental model DEV.txs.......................... [SUCCESS 1 in 3104.02s] 12:05:10 | 12:05:10 | Finished running 1 incremental model in 3110.24s.


#### dbt test

root@08618cd2dc1f:/harmony# dbt test --select txs Running with dbt=0.21.1 Found 47 models, 398 tests, 0 snapshots, 0 analyses, 182 macros, 0 operations, 10 seed files, 21 sources, 0 exposures

Some tests were excluded because at least one parent is not selected. Use the --greedy flag to include them.

tx_gaps_txs_block_number__tx_hash

12:06:25 | Concurrency: 4 threads (target='dev') 12:06:25 | 12:06:25 | 1 of 15 START test not_null_txs_block_timestamp...................... [RUN] 12:06:25 | 2 of 15 START test not_null_txs_data................................. [RUN] 12:06:25 | 3 of 15 START test not_null_txs_from_address......................... [RUN] 12:06:25 | 4 of 15 START test not_null_txs_gas_limit............................ [RUN] 12:06:30 | 1 of 15 PASS not_null_txs_block_timestamp............................ [PASS in 4.96s] 12:06:30 | 5 of 15 START test not_null_txs_gas_price............................ [RUN] 12:06:30 | 3 of 15 WARN 715690 not_null_txs_from_address........................ [WARN 715690 in 5.18s] 12:06:30 | 6 of 15 START test not_null_txs_gas_used............................. [RUN] 12:06:31 | 2 of 15 WARN 715690 not_null_txs_data................................ [WARN 715690 in 5.52s] 12:06:31 | 7 of 15 START test not_null_txs_ingested_at.......................... [RUN] 12:06:34 | 6 of 15 PASS not_null_txs_gas_used................................... [PASS in 3.79s] 12:06:34 | 8 of 15 START test not_null_txs_native_from_address.................. [RUN] 12:06:35 | 7 of 15 PASS not_null_txs_ingested_at................................ [PASS in 4.05s] 12:06:35 | 9 of 15 START test not_null_txs_native_to_address.................... [RUN] 12:06:38 | 4 of 15 WARN 715690 not_null_txs_gas_limit........................... [WARN 715690 in 12.85s] 12:06:38 | 10 of 15 START test not_null_txs_nonce............................... [RUN] 12:06:41 | 10 of 15 PASS not_null_txs_nonce..................................... [PASS in 3.35s] 12:06:41 | 11 of 15 START test not_null_txs_status.............................. [RUN] 12:06:45 | 11 of 15 WARN 715690 not_null_txs_status............................. [WARN 715690 in 3.86s] 12:06:45 | 12 of 15 START test not_null_txs_to_address.......................... [RUN] 12:06:53 | 9 of 15 WARN 715690 not_null_txs_native_to_address................... [WARN 715690 in 18.15s] 12:06:53 | 13 of 15 START test not_null_txs_tx_hash............................. [RUN] 12:06:53 | 8 of 15 WARN 715690 not_null_txs_native_from_address................. [WARN 715690 in 18.83s] 12:06:53 | 14 of 15 START test not_null_txs_value............................... [RUN] 12:06:53 | 12 of 15 WARN 715690 not_null_txs_to_address......................... [WARN 715690 in 7.79s] 12:06:53 | 15 of 15 START test unique_txs_tx_hash............................... [RUN] 12:06:58 | 13 of 15 PASS not_null_txs_tx_hash................................... [PASS in 4.71s] 12:07:02 | 5 of 15 WARN 715690 not_null_txs_gas_price........................... [WARN 715690 in 32.16s] 12:07:10 | 14 of 15 WARN 715690 not_null_txs_value.............................. [WARN 715690 in 17.42s] 12:12:58 | 15 of 15 PASS unique_txs_tx_hash..................................... [PASS in 365.12s] 12:12:58 | 12:12:58 | Finished running 15 tests in 396.29s.


- [x] 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
- [x] Run `dbt docs generate` to update the documentation files if this PR is changing the models in any way.

@antonyip

Name	Link
Latest commit	94ef8192ef5ed058e84ed613831042496e92a8ec
Latest deploy log	https://app.netlify.com/sites/mdao-harmony/deploys/62bb6ea8d944b00008bc0ad8
Deploy Preview	https://deploy-preview-132--mdao-harmony.netlify.app
Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

MetricsDAO / harmony_dbt

modified txs table to include gas used #132

Description

Tests

dbt run

Deploy Preview for mdao-harmony ready!

MetricsDAO / harmony_dbt

modified txs table to include gas used #132

Description

Tests

dbt run

✅ Deploy Preview for mdao-harmony ready!

Deploy Preview for mdao-harmony ready!