Best way to automate the loading of data daily into google big query from SQL Server
See this Q&amp;A at Stack Overflow: Migrate SQL Server database to BigQuery

SQLCMD is your friend. It dumps the results of a query into a CSV.