Hi,
I am new to CloudQuery. I am trying to set up BigQuery as a source from my private VM by using a service account, but there is no clear design of the YAML file to set up BigQuery as a source.
Can someone please help me? How can I configure my service account here?
Hi @whole-meerkat,
CloudQuery does not officially support BigQuery as a source plugin right now, though some other databases are supported as sources (like Postgres and MySQL). You can see the full list of officially supported sources here.
It is possible to write your own source plugin or find a community plugin as well, but I’m not aware of a BigQuery source plugin out there yet.
I’m curious: what is your use case for moving data out of BigQuery?
Actually, my use case is to move data from MySQL to BigQuery, but I was blocked due to some permission error. So, I tried to check that with BigQuery. What privileges do I need to have to read from MySQL instance?
The permissions would be just SELECT (information_schema.tables + the schema/tables you want to sync).