Generating a model in dbt with a connection to bigquery

18 Views Asked by At

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
1

There are 1 best solutions below

1
Ayomide On BEST ANSWER

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