Search code examples
google-bigquerydbt

Generating a model in dbt with a connection to bigquery


I am trying to generate a model for a table which I am connecting to in bigquery. Once I click generate model, I'm expecting that dbt picks up the table and populates the columns from big query but it's come up empty. The below is what I get

with 

source as (

    select * from {{ source('staging', 'green_tripdata') }}

),

renamed as (

    select

    from source

)

select * from renamed

Solution

  • This problem was as a result of not properly defining the table name. It is also helpful to look at the logs.