Skip to main content
Solved

Unable to select Google BigQuery as a writer

  • September 10, 2024
  • 2 replies
  • 42 views
andybarker
Participant
Forum|alt.badge.img+2

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

 

Best answer by emmaatsafe

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

 

View original
Did this help you find an answer to your question?

2 replies

emmaatsafe
Safer
Forum|alt.badge.img+7
  • emmaatsafeSafer
  • Safer
  • Best Answer
  • September 11, 2024

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

 

andybarker
Participant
Forum|alt.badge.img+2
  • andybarkerParticipant
  • Author
  • Participant
  • September 12, 2024
emmaatsafe wrote:

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!

emmaatsafe
1 person upvoted this
  • emmaatsafe
    emmaatsafe

Reply


Helpful Members This Week

Community Stats

30,921
Posts
117,181
Replies
38,725
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.