Skip to main content
Documentation
Feature Requests Trust Center Status Page

Community

Google BigQuery Connector

Answered
Ali Salihoglu User

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.

Please sign in to leave a comment.

Comments

12 comments

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Ali,

    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!

  • Gus Santaella User

    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!!

  • Kevin Kim Fivetranner

    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!

  • Justin Wicks User

    Our business also has a requirement to get Google Big Query data into Snowflake. Use case is for the marketing department.

  • Rohit Khanna User

    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. 

  • Pietro Casella User

    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 

  • Miranda Auhl User

    Hello, 

    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. 

  • Gavin Todes User

    Kevin Kim can you provide an update? It's been over a year since your last comment.

  • avihay Yakobi User

    we are also looking for status on BQ as Data Source Connector

  • Sean Andre User

    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.

  • Chris Lee User

    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.

  • Srini Belide Fivetranner

    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.