'Could not find adapter type bigquery
Having trouble running dbt today... encountered this error message and cannot debug the issue. I did not have this issue yesterday and have not changed anything since.
Installed dbt with Homebrew
Running with dbt=0.18.0
dbt version: 0.18.0
...
Configuration:
profiles.yml file [ERROR invalid]
dbt_project.yml file [OK found and valid]
Profile loading failed for the following reason:
Runtime Error
Credentials in profile "dandelion-bq", target "dev" invalid: Runtime Error
Could not find adapter type bigquery!
Solution 1:[1]
Probably you installed a plugin or another version of dbt-core, try:
dbt --version
It should list the plugins installed, guess in your case there is no bigquery there:
dbt --version
installed version: 0.19.0
latest version: 1.0.0
Your version of dbt is out of date! You can find instructions for upgrading here:
https://docs.getdbt.com/docs/installation
Plugins:
- postgres: 0.19.0
- bigquery: 0.19.0
Install it, with pip or pip3
pip install dbt-bigquery
Same applies for any other plugin/adapter when you get the error Credentials in profile <profile>, target <target> invalid: Runtime Error Could not find adapter type <plugin>!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Marco Medrano |
