Google BigQuery ConnectorAnswered
When using Google Analytics connector, the data we receive is sampled. In order to get raw data, it's possible to sync firebase analytics (which uses google analytics) to Google Big Query. However, the data being synced expires after 60 days and becomes inaccesible. It would be great to have a conenctor which syncs the new tables from Google BigQuery (which are added every day) to our destination to store them for an indefinite amount of time.
Thanks for your feedback! Syncing from data warehouses as sources is definitely on our radar, and something a number of other users have asked for. I will add your comment here to the list of requesters and make note of it.
Thanks for helping us prioritize valuable features!
We have the same use case ^^ GA data sourced in BQ that needs to piped to Snowflake. Would love to be included in any upcoming updates / announcements on this as well as any other DW as a source. Thanks!!
As an update here for everyone following, we still do not have a committed timeframe for this new connector. However, we have made good progress on a design of a potential solution and we are continuing to research use cases for data warehouse syncs!
As we build this out, I will be working with the customer success managers to get more customer feedback, so please share below if you would like to describe your use case!
Our business also has a requirement to get Google Big Query data into Snowflake. Use case is for the marketing department.
Very important for us to get this as a source and also have the ability to do the incremental sync. Would really like it if fivetran can build this out sooner, we have. been forced to look at other tools such as census, hightouch, airbyte.
This is really important, particularly with the increased need to add multiple DW for different usecases:
1. I use snowflake for the datamarketplace, and for DBT
2. I use BQ for AutoML
3. I want some of my DBT exposures from snowflake moved to BQ so that my users can use Sheets BQ connector
4. I want to move some exposures to Clickhouse or Firebolt so that I can provide very fast analytics on top of it
My team also needs a BigQuery connector. We have data in BigQuery (not owned by us) that we need to pull into our PostgreSQL Warehouse for business intelligence purposes. The addition of this feature would potentially keep us from looking at other ETL/data integration tools.
Kevin Kim can you provide an update? It's been over a year since your last comment.
we are also looking for status on BQ as Data Source Connector
We also have a requirement to ingest BigQuery data (not ours) into our postgres database. Any updates on when this is likely to be available.
I'm also looking to use BigQuery as data source since some of our data are only available from BigQuery which is not our primary Data Warehouse due to third-party constraints.
There is an update on this subject.
We now have the BigQuery connector in Private Preview. Setup documentation can be found here --> https://fivetran.com/docs/databases/bigquery/setup-guide#bigquerysetupguide
You can reach out to our support team here for additional information or next steps.
Please sign in to leave a comment.