No database selected

[hugh-nguyen]

Describe the bug

Hi I've just set up a brand new project using db init and dbt-mysql. I've setup my profiles.yaml and checked that dbt debug connects to my database properly and returns no errors.

When I run dbt run, I get the following error

How do I specify the database in dbt?

[hugh-nguyen]

Still totally stuck on this, below is a copy of my profiles.yml

puddle:
  target: dev
  outputs:
    dev:
      type: mysql5
      server: localhost
      port: 3306  # optional
      database: puddle
      dbname: puddle
      schema: puddle
      username: test
      password: test
      driver: MySQL ODBC 8.0 ANSI Driver
    prod:
      type: mysql5
      server: [server/host]
      port: [port]  # optional
      database: [schema] # optional, should be same as schema
      schema: [schema]
      username: [username]
      password: [password]
      driver: MySQL ODBC 8.0 ANSI Driver

[hugh-nguyen]

I've tried adding database/target_database to dbt_project.yml and schema.yml, and in the config of the model

[vietvudanh]

It looks like you have to provide database in SQL query. e.g: <database>.source_data

[4sushi]

@hugh-nguyen

You need to use ref() or source() inside your model:

For exemple in your case, you need to transform this query:

select * 
from source_data

into something like:

select *
from {{ source('database', 'table') }}

When you will run this model, dbt will compile the model and the SQL output will be something like:

select *
from `database`.`table`

[rafalitos1234]

I also had the same problem. Eventually I realized that I was using a non-MySQL function inside my model. Once I changed that, it worked. I think the error message is misleading