Could not find adapter type bigquery

8.1k Views Asked by At

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!
1

There are 1 best solutions below

0
On

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>!