MetricsDAO / harmony_dbt

DBT Project for the Harmony Blockchain
12 stars 8 forks source link

core/blocks.sql - DBT test failures, including syntax errors #137

Open benmillam opened 2 years ago

benmillam commented 2 years ago

See DBT runs going back a few weeks:

04:27:51 Completed with 3 errors and 0 warnings: 04:27:51 04:27:51 Database Error in test tx_gaps_txs_ (models/core/txs.yml) 04:27:51 001003 (42000): SQL compilation error: 04:27:51 syntax error line 9 at position 12 unexpected ','. 04:27:51 syntax error line 11 at position 8 unexpected 'FROM'. 04:27:51 syntax error line 16 at position 12 unexpected ','. 04:27:51 syntax error line 24 at position 4 unexpected ')'. 04:27:51 syntax error line 26 at position 15 unexpected ','. 04:27:51 syntax error line 27 at position 4 unexpected ','. 04:27:51 syntax error line 28 at position 15 unexpected ','. 04:27:51 syntax error line 30 at position 0 unexpected 'FROM'. 04:27:51 syntax error line 33 at position 4 unexpected 'ON'. 04:27:51 compiled SQL at target/run/harmony/models/core/txs.yml/tx_gaps_txs_.sql 04:27:51 04:27:51 Failure in test sequence_gaps_blocks_block_id (models/core/blocks.yml) 04:27:51 Got 3 results, configured to fail if != 0 04:27:51 04:27:51 compiled SQL at target/compiled/harmony/models/core/blocks.yml/sequence_gaps_blocks_block_id.sql 04:27:51 04:27:51 Failure in test tx_gaps_stg_txs_BLOCK_ID__tx_id__tx_count (models/staging/stg_txs.yml) 04:27:51 Got 258 results, configured to fail if != 0 04:27:51 04:27:51 compiled SQL at target/compiled/harmony/models/staging/stg_txs.yml/tx_gaps_stg_txs_BLOCK_ID__tx_id__tx_count.sql