Skip to main content

I’m working through a test case to pull a table data from one of our MS SQL databases into Google BigQuery. I’ve downloaded and installed the BigQuery package from FME Hub and setup the needed Clientid and secret to have it connect to our Google Cloud project. It tests successfully in the services setup, and if I use the GoogleBigQueryConnector, I’m able to select our cloud project and dataset for reading, so I know the connectivity part of it is working. The issue is trying to write something to BigQuery.

If I go to create a writer and choose “Google BigQuery” as the format, the Format selection stays red, like it’s an invalid selection. What am I missing?

Unable to select Google BigQuery as a Writer format

 

Hey @andybarker

It's interesting that the GoogleBigQueryConnector works, but the Google BigQuery writer does not. You may have already tried this, but just to cover all bases—have you tried searching for and adding it from the FME Writer Gallery (see attached photo)? Does it appear in the Writer Gallery for you? Also check in Quick Add menu.

If you’ve already tried that and the Google BigQuery writer doesn’t appear, could you try removing the package and reinstalling it? You can do this by navigating to Tools > FME Options > FME Packages > Google BigQuery > Remove.

If that still doesn't work, could you let me know which build of FME you're running? You can find this under Help > About FME Workbench. Also, let me know which machine you're using (Windows, Mac (Intel or M1/M2)).

Emma

 


If you’ve already tried that and the Google BigQuery writer doesn’t appear, could you try removing the package and reinstalling it? You can do this by navigating to Tools > FME Options > FME Packages > Google BigQuery > Remove.

 

It was available as an option in the Writer Gallery, but upon selecting it, it still wouldn’t populate it in the Format selection for the “Add Writer” dialog. I went into the package manager and saw that an update was available for the Google BigQuery package. After installing the update, selecting Google BigQuery from the gallery actually populated the selection correctly, so it may have been something wrong with my version and install of it that the update/reinstall fixed. Thanks!


Reply