I've searched StackOverflow and on the web and haven't found any code samples for using the Google BigQuery C# API library
Within Visual Studio, I was successfully able to add the BigQuery NuGet Library:
PM> Install-Package Google.Apis.Bigquery.v2 -Pre I have C# code to authenticate to the Google project ID using OAuth 2.0, and that is working. But it is not clear on how to proceed with the BigQuery API. My goal is to insert data into a BigQuery table.
I was looking around for the same thing. Eventually, i made it work thanks to bunch of posts i came across. I wish I could mention links here but i lost track of it since it was quite a while ago. This code does streaming insert data into BigQuery table using C#.
protected void DoStreamingInsert() { var rowList = new List<TableDataInsertAllRequest.RowsData>(); var row1 = new TableDataInsertAllRequest.RowsData(); var row2 = new TableDataInsertAllRequest.RowsData(); row1.Json = new Dictionary<string, object>(); row1.Json.Add("TextField", "SomeTest"); row1.Json.Add("DataField", "2014-10-31 00:00:00.0000"); //row1.InsertId = DateTime.Now.Ticks.ToString(); Give this ID to prevent duplicate insert row2.Json = new Dictionary<string, object>(); row2.Json.Add("TextField", "SomeTest1"); row2.Json.Add("DataField", "2014-11-30 00:00:00.0000"); rowList.Add(row1); rowList.Add(row2); var content = new TableDataInsertAllRequest(); content.Rows = rowList; content.Kind = "bigquery#tableDataInsertAllRequest"; content.IgnoreUnknownValues = true; content.SkipInvalidRows = true; var insertTask = BQDefs.BQService.Tabledata.InsertAll(content, BQDefs.ProjectID, BQDefs.DataSet, BQDefs.TableName); TableDataInsertAllResponse response = insertTask.Execute(); }