How can I pull Google BigQuery Data in FME

Hi ​@vishnuiam thanks for your question. Have you checked out these tutorials?

• https://support.safe.com/hc/en-us/articles/25407653401101-Getting-Started-with-Google-BigQuery
• https://support.safe.com/hc/en-us/articles/25407718223373-How-to-Convert-Microsoft-Excel-to-Esri-Shapefile

Let us know if these work for you and if you have any further questions.

Hello Evie,

Thanks for the reply. I’ve went through the URLs. I’m struck in connecting GoogleBigQuery in FME using Service Account Key file.

My requirement is to pull data from Google BigQuery tables. I’ve been trying with GoogleBigQueryConnector transformer. And I configured for Service Account Key File with system environment variable.  Nothing worked out for me.

After selecting source account and project ID field is not populated automatically.

I finally found the way to pull data from Google BigQuery table using creator transformer with GoogleBigQueryConnector.

And I’m attaching the below post from FME community for public reference. These information not documented along with GoogleBigQueryConnector page.

• Creator transformer