Forum Discussion

kbenzakri-lelp's avatar
kbenzakri-lelp
Frequent Visitor
2 years ago
Solved

BigQuery dataset shown empty

Hi,   I'm having trouble using BigQuery as a data source because it doesn't detect one of my dataset's content. This dataset contains 502 tables, so I figured that's why tables don't appear unlike ...
Need Help
Tutorial Requests
  • kbenzakri-lelp's avatar
    kbenzakri-lelp
    2 years ago

    Despite the fact that I couldn't display the tables through the BigQuery connector, I've managed to reach these tables.

    What I did was importing a radndom table from another BigQuery dataset in the same GCP project. I then entered the model view in order to edit the table (or more precisely the Table Query). I did that by right clicking on the table I imported, clicked on "Edit query", then on the "Advanced Editor" button (which is located in the "Home" tab, in the "Query" part). There, I could change the table name, the dataset name and other parameters.
    everything worked well after that

kbenzakri-lelp's avatar
kbenzakri-lelp
Frequent Visitor
2 years ago

Despite the fact that I couldn't display the tables through the BigQuery connector, I've managed to reach these tables.

What I did was importing a radndom table from another BigQuery dataset in the same GCP project. I then entered the model view in order to edit the table (or more precisely the Table Query). I did that by right clicking on the table I imported, clicked on "Edit query", then on the "Advanced Editor" button (which is located in the "Home" tab, in the "Query" part). There, I could change the table name, the dataset name and other parameters.
everything worked well after that