// Creates a new empty table in Google BigQuery
public void CreateBigQueryTable(string projectName, string dataSetName, string tableName)
{
if (_DataTypeMap == null)
{
throw new Exception("DataTypeMap can not be null. Call UploadTableToStorage() or MapColumnTypes() method first");
}
BigqueryClient client = BigqueryClient.Create(projectName, _GoogleAPICredential);
// Build the schema with Google's schema object and our DataTypeMap
TableSchemaBuilder sBuilder = new TableSchemaBuilder();
for (int i = 0; i < _DataTypeMap.Keys.Count; i++)
{
sBuilder.Add(_DataTypeMap[i].ColumnName, _DataTypeMap[i].BQColumnType);
}
// Create the dataset if it doesn't exist.
BigqueryDataset dataset = client.GetOrCreateDataset(dataSetName);
BigqueryTable table = dataset.GetOrCreateTable(tableName, sBuilder.Build());
}
// [START create_dataset]
public void CreateDataset(string datasetId, BigqueryClient client)
{
var dataset = client.GetOrCreateDataset(datasetId);
}
