Open aaronsteers opened 1 year ago
Sorry for the late response. Because this isn't a Meltano/MeltanoLabs repository, the email went to my personal account.
Reproduction steps:
docker run -it --entrypoint bash meltano/meltano:v2.9.0
git clone https://github.com/aaronsteers/meltano-demo-in-a-box.git .
meltano install
meltano schedule run daily-run-all
Output of step 4:
2022-11-09T16:20:34.804243Z [info ] The default environment 'dev' will be ignored for `meltano schedule`. To configure a specific environment, please use the option `--environment=<environment name>`.
2022-11-09T16:20:36.391305Z [info ] Environment 'dev' is active
2022-11-09T16:20:37.042636Z [warning ] No state was found, complete import.
2022-11-09T16:20:39.562535Z [info ] INFO Using supplied catalog /project/.meltano/run/tap-spreadsheets-anywhere/tap.properties.json. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.563042Z [info ] INFO Processing 6 selected streams from Catalog cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.563364Z [info ] INFO Syncing stream:nba_schedule_2023 cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.563767Z [info ] INFO Walking ./data. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.564091Z [info ] INFO Found 3 files. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.564371Z [info ] INFO Checking 3 resolved objects for any that match regular expression "nba_schedule_2023.csv" and were modified since 2001-01-01 00:00:00+00:00 cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.564579Z [info ] INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.564777Z [info ] INFO Syncing file "nba_schedule_2023.csv". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.568822Z [info ] time=2022-11-09 16:20:39 name=target_duckdb level=INFO message=Schema 'raw' does not exist. Creating... CREATE SCHEMA IF NOT EXISTS raw cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:39.581429Z [info ] time=2022-11-09 16:20:39 name=target_duckdb level=INFO message=Table '"nba_schedule_2023"' does not exist. Creating... CREATE TABLE IF NOT EXISTS raw."nba_schedule_2023" ("_smart_source_bucket" varchar, "_smart_source_file" varchar, "_smart_source_lineno" hugeint, "arena" varchar, "attend" varchar, "date" varchar, "homeneutral" varchar, "key" hugeint, "notes" varchar, "pts" varchar, "series_id" hugeint, "start_et" varchar, "type" varchar, "visitorneutral" varchar, PRIMARY KEY ("key")) cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:39.728102Z [info ] INFO Wrote 1341 records for stream "nba_schedule_2023". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.728401Z [info ] INFO Syncing stream:team_ratings cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.728695Z [info ] INFO Walking ./data. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.728883Z [info ] INFO Found 3 files. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.729065Z [info ] INFO Checking 3 resolved objects for any that match regular expression "team_ratings.csv" and were modified since 2001-01-01 00:00:00+00:00 cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.729244Z [info ] INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.729433Z [info ] INFO Syncing file "team_ratings.csv". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.731118Z [info ] INFO Wrote 30 records for stream "team_ratings". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.731379Z [info ] INFO Syncing stream:xf_series_to_seed cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.731581Z [info ] INFO Walking ./data. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.731761Z [info ] INFO Found 3 files. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.732223Z [info ] INFO Checking 3 resolved objects for any that match regular expression "xf_series_to_seed.csv" and were modified since 2001-01-01 00:00:00+00:00 cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.732420Z [info ] INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.732611Z [info ] INFO Syncing file "xf_series_to_seed.csv". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.733022Z [info ] INFO Wrote 14 records for stream "xf_series_to_seed". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.733215Z [info ] INFO Syncing stream:nba_elo_latest cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.733405Z [info ] INFO Assembled https://projects.fivethirtyeight.com/nba-model/nba_elo_latest.csv as the URL to a source file. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.735538Z [info ] time=2022-11-09 16:20:39 name=target_duckdb level=INFO message=Table '"team_ratings"' does not exist. Creating... CREATE TABLE IF NOT EXISTS raw."team_ratings" ("_smart_source_bucket" varchar, "_smart_source_file" varchar, "_smart_source_lineno" hugeint, "conf" varchar, "elo_rating" hugeint, "team" varchar, "team_long" varchar, "win_total" double, PRIMARY KEY ("team")) cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:39.740825Z [info ] time=2022-11-09 16:20:39 name=target_duckdb level=INFO message=Table '"xf_series_to_seed"' does not exist. Creating... CREATE TABLE IF NOT EXISTS raw."xf_series_to_seed" ("_smart_source_bucket" varchar, "_smart_source_file" varchar, "_smart_source_lineno" hugeint, "seed" varchar, "series_id" hugeint, PRIMARY KEY ("series_id")) cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:39.752879Z [info ] time=2022-11-09 16:20:39 name=target_duckdb level=INFO message=Table '"nba_elo_latest"' does not exist. Creating... CREATE TABLE IF NOT EXISTS raw."nba_elo_latest" ("_smart_source_bucket" varchar, "_smart_source_file" varchar, "_smart_source_lineno" hugeint, "carmelo1_post" varchar, "carmelo1_pre" varchar, "carmelo2_post" varchar, "carmelo2_pre" varchar, "carmelo_prob1" varchar, "carmelo_prob2" varchar, "date" varchar, "elo1_post" double, "elo1_pre" double, "elo2_post" double, "elo2_pre" double, "elo_prob1" double, "elo_prob2" double, "importance" hugeint, "neutral" hugeint, "playoff" varchar, "quality" hugeint, "raptor1_pre" double, "raptor2_pre" double, "raptor_prob1" double, "raptor_prob2" double, "score1" hugeint, "score2" hugeint, "season" hugeint, "team1" varchar, "team2" varchar, "total_rating" hugeint, PRIMARY KEY ("date", "team1", "team2")) cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:39.798536Z [info ] INFO Checking 1 resolved objects for any that match regular expression "nba_elo_latest.csv" and were modified since 2001-01-01 00:00:00+00:00 cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.798891Z [info ] INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:39.799231Z [info ] INFO Syncing file "nba_elo_latest.csv". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:40.361111Z [info ] INFO Wrote 1230 records for stream "nba_elo_latest". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:40.361410Z [info ] INFO Syncing stream:latest_RAPTOR_by_player cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:40.361606Z [info ] INFO Assembled https://projects.fivethirtyeight.com/nba-model/2022/latest_RAPTOR_by_player.csv as the URL to a source file. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:40.376060Z [info ] time=2022-11-09 16:20:40 name=target_duckdb level=INFO message=Table '"latest_raptor_by_player"' does not exist. Creating... CREATE TABLE IF NOT EXISTS raw."latest_raptor_by_player" ("_smart_source_bucket" varchar, "_smart_source_file" varchar, "_smart_source_lineno" hugeint, "mp" hugeint, "pace_impact" double, "player_id" varchar, "player_name" varchar, "poss" hugeint, "predator_defense" double, "predator_offense" double, "predator_total" double, "raptor_box_defense" double, "raptor_box_offense" double, "raptor_box_total" double, "raptor_defense" double, "raptor_offense" double, "raptor_onoff_defense" double, "raptor_onoff_offense" double, "raptor_onoff_total" double, "raptor_total" double, "season" hugeint, "war_playoffs" double, "war_reg_season" double, "war_total" double, PRIMARY KEY ("player_id")) cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:40.480836Z [info ] INFO Checking 1 resolved objects for any that match regular expression "latest_RAPTOR_by_player.csv" and were modified since 2001-01-01 00:00:00+00:00 cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:40.481226Z [info ] INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:40.481497Z [info ] INFO Syncing file "latest_RAPTOR_by_player.csv". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.118297Z [info ] INFO Wrote 606 records for stream "latest_RAPTOR_by_player". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.118572Z [info ] INFO Syncing stream:latest_RAPTOR_by_team cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.118781Z [info ] INFO Assembled https://projects.fivethirtyeight.com/nba-model/2022/latest_RAPTOR_by_team.csv as the URL to a source file. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.134863Z [info ] time=2022-11-09 16:20:41 name=target_duckdb level=INFO message=Table '"latest_raptor_by_team"' does not exist. Creating... CREATE TABLE IF NOT EXISTS raw."latest_raptor_by_team" ("_smart_source_bucket" varchar, "_smart_source_file" varchar, "_smart_source_lineno" hugeint, "mp" hugeint, "pace_impact" double, "player_id" varchar, "player_name" varchar, "poss" hugeint, "predator_defense" double, "predator_offense" double, "predator_total" double, "raptor_box_defense" double, "raptor_box_offense" double, "raptor_box_total" double, "raptor_defense" double, "raptor_offense" double, "raptor_onoff_defense" double, "raptor_onoff_offense" double, "raptor_onoff_total" double, "raptor_total" double, "season" hugeint, "season_type" varchar, "team" varchar, "war_playoffs" double, "war_reg_season" double, "war_total" double, PRIMARY KEY ("player_id", "season_type")) cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:41.237621Z [info ] INFO Checking 1 resolved objects for any that match regular expression "latest_RAPTOR_by_team.csv" and were modified since 2001-01-01 00:00:00+00:00 cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.237961Z [info ] INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details. cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.238190Z [info ] INFO Syncing file "latest_RAPTOR_by_team.csv". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.818710Z [info ] INFO Wrote 932 records for stream "latest_RAPTOR_by_team". cmd_type=elb consumer=False name=tap-spreadsheets-anywhere producer=True stdio=stderr string_id=tap-spreadsheets-anywhere
2022-11-09T16:20:41.855039Z [info ] time=2022-11-09 16:20:41 name=target_duckdb level=INFO message=Loading 1341 rows into 'raw."nba_schedule_2023"' cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:42.348945Z [info ] time=2022-11-09 16:20:42 name=target_duckdb level=INFO message=Loading 30 rows into 'raw."team_ratings"' cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:42.362563Z [info ] time=2022-11-09 16:20:42 name=target_duckdb level=INFO message=Loading 14 rows into 'raw."xf_series_to_seed"' cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:42.369559Z [info ] time=2022-11-09 16:20:42 name=target_duckdb level=INFO message=Loading 1230 rows into 'raw."nba_elo_latest"' cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:43.107317Z [info ] time=2022-11-09 16:20:43 name=target_duckdb level=INFO message=Loading 606 rows into 'raw."latest_raptor_by_player"' cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:43.418012Z [info ] time=2022-11-09 16:20:43 name=target_duckdb level=INFO message=Loading 822 rows into 'raw."latest_raptor_by_team"' cmd_type=elb consumer=True name=target-duckdb producer=False stdio=stderr string_id=target-duckdb
2022-11-09T16:20:43.879501Z [info ] Incremental state has been updated at 2022-11-09 16:20:43.879413.
2022-11-09T16:20:43.916242Z [info ] Block run completed. block_type=ExtractLoadBlocks err=None set_number=0 success=True
2022-11-09T16:20:44.799313Z [info ] Extension executing `dbt build`... cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:46.971024Z [info ] 16:20:46 Running with dbt=1.2.2 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.058833Z [info ] 16:20:47 Found 31 models, 41 tests, 0 snapshots, 0 analyses, 257 macros, 0 operations, 0 seed files, 6 sources, 0 exposures, 0 metrics cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.064667Z [info ] 16:20:47 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.432499Z [info ] 16:20:47 Concurrency: 4 threads (target='dev') cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.432894Z [info ] 16:20:47 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.439903Z [info ] 16:20:47 1 of 72 START view model main_prep.prep_elo_post ............................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.441254Z [info ] 16:20:47 2 of 72 START view model main_prep.prep_nba_elo_latest ......................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.441980Z [info ] 16:20:47 3 of 72 START view model main_prep.prep_schedule ............................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.443222Z [info ] 16:20:47 4 of 72 START view model main_prep.prep_team_ratings ........................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.601430Z [info ] 16:20:47 1 of 72 ERROR creating view model main_prep.prep_elo_post ...................... [ERROR in 0.16s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.603010Z [info ] 16:20:47 5 of 72 START view model main_prep.prep_xf_series_to_seed ...................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.938189Z [info ] 16:20:47 4 of 72 OK created view model main_prep.prep_team_ratings ...................... [OK in 0.19s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.939937Z [info ] 16:20:47 3 of 72 OK created view model main_prep.prep_schedule .......................... [OK in 0.20s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.940645Z [info ] 16:20:47 2 of 72 OK created view model main_prep.prep_nba_elo_latest .................... [OK in 0.50s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.944969Z [info ] 16:20:47 6 of 72 START view model main.scenario_gen ..................................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.953627Z [info ] 16:20:47 7 of 72 START test empty_table_prep_team_ratings_ .............................. [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:47.954748Z [info ] 16:20:47 8 of 72 START test empty_table_prep_schedule_ .................................. [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.031957Z [info ] 16:20:48 5 of 72 OK created view model main_prep.prep_xf_series_to_seed ................. [OK in 0.42s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.038287Z [info ] 16:20:48 9 of 72 START test empty_table_prep_nba_elo_latest_ ............................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.041416Z [info ] 16:20:48 8 of 72 PASS empty_table_prep_schedule_ ........................................ [PASS in 0.08s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.042280Z [info ] 16:20:48 7 of 72 PASS empty_table_prep_team_ratings_ .................................... [PASS in 0.09s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.054763Z [info ] 16:20:48 10 of 72 START test empty_table_prep_xf_series_to_seed_ ........................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.055785Z [info ] 16:20:48 11 of 72 START view model main.post_season_schedule ............................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.348447Z [info ] 16:20:48 6 of 72 OK created view model main.scenario_gen ................................ [OK in 0.40s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.367379Z [info ] 16:20:48 12 of 72 SKIP relation main.ratings ............................................ [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.373427Z [info ] 16:20:48 13 of 72 START test empty_table_scenario_gen_ .................................. [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.383631Z [info ] 16:20:48 9 of 72 PASS empty_table_prep_nba_elo_latest_ .................................. [PASS in 0.34s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.394240Z [info ] 16:20:48 14 of 72 SKIP test accepted_values_ratings_conf__East__West .................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.399705Z [info ] 16:20:48 10 of 72 PASS empty_table_prep_xf_series_to_seed_ .............................. [PASS in 0.34s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.400856Z [info ] 16:20:48 15 of 72 SKIP test not_null_ratings_conf ....................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.403772Z [info ] 16:20:48 16 of 72 SKIP test not_null_ratings_elo_rating ................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.404796Z [info ] 16:20:48 17 of 72 SKIP test not_null_ratings_team ....................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.409953Z [info ] 16:20:48 18 of 72 SKIP test not_null_ratings_team_long .................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.412793Z [info ] 16:20:48 19 of 72 SKIP test unique_ratings_team ......................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.417630Z [info ] 16:20:48 20 of 72 SKIP test unique_ratings_team_long .................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.418228Z [info ] 16:20:48 21 of 72 START view model main.latest_results .................................. [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.711743Z [info ] 16:20:48 11 of 72 OK created view model main.post_season_schedule ....................... [OK in 0.36s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.713310Z [info ] 16:20:48 13 of 72 PASS empty_table_scenario_gen_ ........................................ [PASS in 0.34s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.714428Z [info ] 16:20:48 22 of 72 START view model main_prep.prep_latest_ratings ........................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.722340Z [info ] 16:20:48 23 of 72 START view model main.xf_series_to_seed ............................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.723239Z [info ] 16:20:48 24 of 72 SKIP relation main.reg_season_schedule ................................ [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.736275Z [info ] 16:20:48 25 of 72 SKIP relation main.teams .............................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.753734Z [info ] 16:20:48 26 of 72 SKIP relation main.vegas_wins ......................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.757223Z [info ] 16:20:48 27 of 72 START test empty_table_post_season_schedule_ .......................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.799155Z [info ] 16:20:48 21 of 72 OK created view model main.latest_results ............................. [OK in 0.38s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.801769Z [info ] 16:20:48 22 of 72 OK created view model main_prep.prep_latest_ratings ................... [OK in 0.09s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.805436Z [info ] 16:20:48 23 of 72 OK created view model main.xf_series_to_seed .......................... [OK in 0.08s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.806282Z [info ] 16:20:48 28 of 72 SKIP test empty_table_reg_season_schedule_ ............................ [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.808615Z [info ] 16:20:48 29 of 72 SKIP test not_null_teams_team ......................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.810435Z [info ] 16:20:48 30 of 72 SKIP test not_null_teams_team_long .................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:48.811025Z [info ] 16:20:48 31 of 72 SKIP test unique_teams_team ........................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.110240Z [info ] 16:20:49 27 of 72 PASS empty_table_post_season_schedule_ ................................ [PASS in 0.35s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.110724Z [info ] 16:20:49 32 of 72 SKIP test unique_teams_team_long ...................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.112924Z [info ] 16:20:49 33 of 72 SKIP test not_null_vegas_wins_team .................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.113505Z [info ] 16:20:49 34 of 72 SKIP test not_null_vegas_wins_win_total ............................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.115572Z [info ] 16:20:49 35 of 72 SKIP test unique_vegas_wins_team ...................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.116166Z [info ] 16:20:49 36 of 72 START test not_null_latest_results_date ............................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.118159Z [info ] 16:20:49 37 of 72 START test not_null_latest_results_game_id ............................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.118898Z [info ] 16:20:49 38 of 72 START test not_null_latest_results_home_team .......................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.120584Z [info ] 16:20:49 39 of 72 START test not_null_latest_results_home_team_score .................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.184789Z [info ] 16:20:49 36 of 72 PASS not_null_latest_results_date ..................................... [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.186749Z [info ] 16:20:49 38 of 72 PASS not_null_latest_results_home_team ................................ [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.190004Z [info ] 16:20:49 39 of 72 PASS not_null_latest_results_home_team_score .......................... [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.190631Z [info ] 16:20:49 37 of 72 PASS not_null_latest_results_game_id .................................. [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.191090Z [info ] 16:20:49 40 of 72 START test not_null_latest_results_losing_team ........................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.193049Z [info ] 16:20:49 41 of 72 START test not_null_latest_results_visiting_team ...................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.194732Z [info ] 16:20:49 42 of 72 START test not_null_latest_results_visiting_team_score ................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.195342Z [info ] 16:20:49 43 of 72 START test not_null_latest_results_winning_team ....................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.261478Z [info ] 16:20:49 40 of 72 PASS not_null_latest_results_losing_team .............................. [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.264991Z [info ] 16:20:49 41 of 72 PASS not_null_latest_results_visiting_team ............................ [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.266937Z [info ] 16:20:49 44 of 72 START test unique_latest_results_game_id .............................. [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.267563Z [info ] 16:20:49 43 of 72 PASS not_null_latest_results_winning_team ............................. [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.268535Z [info ] 16:20:49 42 of 72 PASS not_null_latest_results_visiting_team_score ...................... [PASS in 0.07s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.270979Z [info ] 16:20:49 45 of 72 START test empty_table_prep_latest_ratings_ ........................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.307803Z [info ] 16:20:49 46 of 72 START test unique_prep_latest_ratings_team ............................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.308414Z [info ] 16:20:49 47 of 72 START test not_null_xf_series_to_seed_seed ............................ [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.364114Z [info ] 16:20:49 44 of 72 PASS unique_latest_results_game_id .................................... [PASS in 0.10s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.366259Z [info ] 16:20:49 47 of 72 PASS not_null_xf_series_to_seed_seed .................................. [PASS in 0.06s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.370116Z [info ] 16:20:49 45 of 72 PASS empty_table_prep_latest_ratings_ ................................. [PASS in 0.10s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.370987Z [info ] 16:20:49 48 of 72 START test not_null_xf_series_to_seed_series_id ....................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.371954Z [info ] 16:20:49 46 of 72 PASS unique_prep_latest_ratings_team .................................. [PASS in 0.06s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.373197Z [info ] 16:20:49 49 of 72 START test unique_xf_series_to_seed_series_id ......................... [RUN] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.375596Z [info ] 16:20:49 50 of 72 SKIP relation main.schedules .......................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.381642Z [info ] 16:20:49 51 of 72 SKIP relation main.reg_season_actuals ................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.392369Z [info ] 16:20:49 52 of 72 SKIP test accepted_values_schedules_type__reg_season__playin_r1__playin_r2__playoffs_r1__playoffs_r2__playoffs_r3__playoffs_r4 [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.395438Z [info ] 16:20:49 53 of 72 SKIP test not_null_schedules_game_id .................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.399969Z [info ] 16:20:49 54 of 72 SKIP test not_null_schedules_home_team ................................ [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.400686Z [info ] 16:20:49 55 of 72 SKIP test not_null_schedules_visiting_team ............................ [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.410866Z [info ] 16:20:49 56 of 72 SKIP test unique_schedules_game_id .................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.413827Z [info ] 16:20:49 57 of 72 SKIP relation main.random_num_gen ..................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.417861Z [info ] 16:20:49 58 of 72 SKIP test empty_table_random_num_gen_ ................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.423065Z [info ] 16:20:49 59 of 72 SKIP relation main.reg_season_simulator ............................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.423692Z [info ] 16:20:49 48 of 72 PASS not_null_xf_series_to_seed_series_id ............................. [PASS in 0.05s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.427246Z [info ] 16:20:49 49 of 72 PASS unique_xf_series_to_seed_series_id ............................... [PASS in 0.05s] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.427930Z [info ] 16:20:49 60 of 72 SKIP relation main.reg_season_end ..................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.430653Z [info ] 16:20:49 61 of 72 SKIP relation main.playin_sim_r1 ...................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.431266Z [info ] 16:20:49 62 of 72 SKIP relation main.reg_season_summary ................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.432757Z [info ] 16:20:49 63 of 72 SKIP relation main.playin_sim_r1_end .................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.434050Z [info ] 16:20:49 64 of 72 SKIP relation main.playin_sim_r2 ...................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.435382Z [info ] 16:20:49 65 of 72 SKIP relation main.playin_sim_r2_end .................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.436842Z [info ] 16:20:49 66 of 72 SKIP relation main.initialize_seeding ................................. [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.438203Z [info ] 16:20:49 67 of 72 SKIP relation main.playoff_sim_r1 ..................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.439474Z [info ] 16:20:49 68 of 72 SKIP relation main.playoff_sim_r2 ..................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.440719Z [info ] 16:20:49 69 of 72 SKIP relation main.playoff_sim_r3 ..................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.442156Z [info ] 16:20:49 70 of 72 SKIP relation main.playoff_sim_r4 ..................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.443519Z [info ] 16:20:49 71 of 72 SKIP relation main.playoff_summary .................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.445050Z [info ] 16:20:49 72 of 72 SKIP relation main.season_summary ..................................... [SKIP] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.457619Z [info ] 16:20:49 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.457887Z [info ] 16:20:49 Finished running 22 view models, 41 tests, 9 table models in 0 hours 0 minutes and 2.39 seconds (2.39s). cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.467160Z [info ] 16:20:49 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.467433Z [info ] 16:20:49 Completed with 1 error and 0 warnings: cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.467692Z [info ] 16:20:49 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.467953Z [info ] 16:20:49 Runtime Error in model prep_elo_post (models/prep/prep_elo_post.sql) cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.468205Z [info ] 16:20:49 Catalog Error: Table with name elo_post does not exist! cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.468454Z [info ] 16:20:49 Did you mean "pg_catalog.pg_type"? cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.468776Z [info ] 16:20:49 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.469038Z [info ] 16:20:49 Done. PASS=29 WARN=0 ERROR=1 SKIP=42 TOTAL=72 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.553386Z [info ] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.553794Z [info ] cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.554102Z [info ] error invoking dbt None error_message=dbt invocation failed returncode=1 cmd_type=command name=dbt-duckdb stdio=stderr
2022-11-09T16:20:49.570539Z [error ] Block run completed. block_type=InvokerCommand err=RunnerError('`dbt-duckdb build` failed with exit code: 1') exit_codes={} set_number=1 success=False
Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to
join our friendly Slack community.
Run invocation could not be completed as block failed: `dbt-duckdb build` failed with exit code: 1
@WillDaSilva - Super helpful - thanks!!
Update, per log results below:
meltano schedule run daily-run-all
is failing due to a faileddbt-duckdb build
step.Key error is
Table with name elo_post does not exist
here:Likely cause would be if an additional EL pipeline needs to run before the dbt build can occur.