Search code examples
sql-server-2008connectiongoogle-bigquery

Using SQL Server data in Google Big Query

I need some help in using the data that resides in SQL Server to be accessed from Google Big Query for the analytics.

I have all the transaction data in SQL Server and now we want to run some analytics on top of data using Big Query. But I didn't find a way to connect the data from the SQL Server.

Solution

  • You can pull a CSV using sqlcmd, and then upload that to BigQuery