How can you get additional debug information from ...
# troubleshooting
j
How can you get additional debug information from dbt? I'm getting a
No such file or directory: ''
error. I'm certain it's my own fault but I just can't figure out where from that short message.
Copy code
{"stdio": "stderr", "cmd_type": "command", "name": "dbt-bigquery", "event": "20:33:10  Running with dbt=1.1.2", "level": "info", "timestamp": "2022-09-28T20:33:10.673796Z"}
{"stdio": "stderr", "cmd_type": "command", "name": "dbt-bigquery", "event": "20:33:10  Found 3 models, 0 tests, 0 snapshots, 0 analyses, 191 macros, 0 operations, 0 seed files, 2 sources, 0 exposures, 0 metrics", "level": "info", "timestamp": "2022-09-28T20:33:10.716436Z"}
{"stdio": "stderr", "cmd_type": "command", "name": "dbt-bigquery", "event": "20:33:10", "level": "info", "timestamp": "2022-09-28T20:33:10.717542Z"}
{"stdio": "stderr", "cmd_type": "command", "name": "dbt-bigquery", "event": "20:33:10  Encountered an error:", "level": "info", "timestamp": "2022-09-28T20:33:10.722032Z"}
{"stdio": "stderr", "cmd_type": "command", "name": "dbt-bigquery", "event": "Database Error", "level": "info", "timestamp": "2022-09-28T20:33:10.722335Z"}
{"stdio": "stderr", "cmd_type": "command", "name": "dbt-bigquery", "event": "  [Errno 2] No such file or directory: ''", "level": "info", "timestamp": "2022-09-28T20:33:10.722619Z"}
{"set_number": 1, "block_type": "InvokerCommand", "success": false, "err": "RunnerError('`dbt-bigquery tap_hubspot` failed with exit code: 1')", "exit_codes": {}, "event": "Block run completed.", "level": "error", "timestamp": "2022-09-28T20:33:10.854094Z"}
think I found it. it's because this is interpolated to an empty string:
Copy code
keyfile: "{{ env_var('DBT_BIGQUERY_KEYFILE', '') }}"
p
@jonas_kalderstam I'm not super familiar with BQ but do you not provide a keyfile to authenticate? After a quick look at the default profile thats provided by a meltano install it looks like we default keyfile to an empty string if its not provided, if that causes an error when its not provided then thats probably a bug. I opened an issue to look into it https://github.com/meltano/files-dbt-bigquery/issues/4
j
I do indeed. so I've just changed that line to reference the correct variable and made it required to make any error clearer
added a comment on the issue