google-bigquerygoogle-cloud-datapreptrifacta

Does Google Cloud Dataprep support importing Google Drive Sheets as data sources?

I'm importing datasets in Google Cloud Dataprep (by Trifacta) to perform transformations on my data sources. But I can't see Google Drive Sheets in the list after connecting them to Big Query Console. I'm about to use them as rules for my transformations.

I've already created another dataset and the problem persists.

Is it possible to import them or not supported yet?

Thanks,

Solution

  • You are right. According to the documentation Dataprep only supports native BigQuery tables and views as BigQuery sources.

    You could try downloading your Drive sheets as csv and then creating a BigQuery table from it, or maybe you could create a load job from your external table into a new native table using:

    SELECT * FROM my_dataset.my_external_table