The problem I’m having
I’m trying to test the connection to my data warehouse using the dbt CLI on macOS with version 0.40.3, but the command dbt debug --connection is not recognized.
When I run:
dbt debug --connection
I get the following error:
Error: unknown flag: --connection
Usage:
dbt debug [flags]
Flags:
-h, --help help for debug
--project-paths Display configured project paths
Global Flags:
--log-format LogFormat The log format, either json or plain. (default plain)
--log-level LogLevel The log level, one of debug, info, warning, error or fatal. (default info)
--no-color Disables colorization of the output.
-q, --quiet Suppress all non-error logging to stdout.
--show-all-deprecations By default, each type of a deprecation warning is only shown once. Use this flag to show all deprecation warning instances.
The context of why I’m trying to do this
- I’m using macOS.
- I have a dbt Cloud account with two licenses.
- I’m setting up a **new dbt project ** using the CLI (version
0.40.3). - I want to test the connection between my local dbt and the data warehouse.
When I run just dbt debug, I see output including:
- Local configuration
- Cloud configuration
- Postgres connection details
However, no real confirmation of whether the data warehouse connection is successful.
What I’ve already tried
When I try to open dbt Cloud Studio, I get this error:
“Failed to set up SSH tunnel. Please double check your connection settings.”
There is no detailed log or error message, so I’m not sure how to debug it.
Some example code or error messages
Put code inside backticks
to preserve indentation
which is especially important
for Python and YAML!