Getting data in to GBQ (google big query)

[Adam_Abbott]

We have a use case that involves getting goal level data into GBQ so we can blend those with campaign data to build monitoring dashboards.

Has anyone successfully gotten their data into GBQ and if so via which connector/ingestion service did you use?

We have work arounds that involved exporting to a google sheet and then into GBQ but just wanted to check if there was a less round about method.

Thanks!

[drassi]

I’m unsure about GBQ specifically, however for getting Airtable data into the Google ecosystem, we use the Railsware Airtable Importer which syncs data periodically over to GSheets. It’s worked flawlessly for us for over a year now, it’s extremely simple and robust. For you, it could cut out the first export step of your process and keep data synced.

[MichaelTomar]

Skyvia offers a cloud data integration platform that allows for easy connection between BigQuery and Airtable without the need for coding. This platform operates on a freemium model, providing users with a range of features at no initial cost.