search

googledatastudio / community-connectors

This repository contains open source content for Google Data Studio.
https://datastudio.google.com/
Apache License 2.0
556 stars 265 forks source link

Firestore Connector Issue #259

Open fye-cg opened 5 years ago

fye-cg commented 5 years ago

Hi, I am trying to setup the Firestore connector but continually get the following after setting up authorization:

Community Connector Error There was an error caused by the community connector. Please report the issue to the provider of this community connector if this issue persists.

Connector details There was an error caused by this connector.

Does anybody have any pointers for how to get past this? Or how best to debug?

Thanks Campbell

fye-cg commented 5 years ago

I think this might be the same issue as #251 - I'm seeing a similar error in the debug console...

TypeError: Cannot find function getAuthToken in object [object Object]. at Firestore(Firestore:42)

diminishedprime commented 5 years ago

I took a quick glance through the code and don't see why this issue would happen, it looks to me like getAuthToken is defined. If someone wants to take a stab at this issue, feel free. It'd be nice if this connector was a bit simpler and didn't use prototypical inheritance since that makes tracking down these sorts of issues harder.

Bennoo commented 5 years ago

I have a similar issue. 'There was an error caused by this connector.' could we agree on connector authentication process? Is this correct ?

Thanks

infobetternow commented 4 years ago

Same with me.

fye-cg commented 4 years ago

Same with me.

Best off using the new Firebase Extension to sync realtime to BigQuery and then connect BigQuery to Data Studio... https://firebase.google.com/products/extensions/firestore-bigquery-export

jemamena commented 4 years ago

Any luck about how to fix the problem? client_email and private_key (the long one with begin and end private key) of the generated json file don't seem to work...

@fye-campbell that sounds like a solution, however is more pricey apparently. It would be great to connect directly to data studio.

fye-cg commented 4 years ago

No - I looked into it for a while but I couldn't find any logging that would push me in the right direction - needed somebody with far greater knowhow to weigh in!

Obviously depends how much data you're pushing around, but the free tier limits are pretty generous for BigQuery... https://cloud.google.com/bigquery/pricing

trevorlazarus commented 4 years ago

@fye-campbell @diminishedprime

Are there any solutions to this?

penadev commented 4 years ago

Same problem with me... Are there any solutions?

PawelKwiecinski commented 4 years ago

Also here. Same issue.

fye-cg commented 4 years ago

I strongly suggest using the Firebase Extension to realtime export to BigQuery - it's being actively maintained by Google. It's very reliable and, unless you've got a huge dataset, you'll likely stay within free tier limits. You may need to run a scheduled query on BigQuery to extract the data you need into a more readable table (at least, that's what I do). Then connect Data Studio to BigQuery. https://firebase.google.com/products/extensions/firestore-bigquery-export