public Task DeleteTableAsync(string datasetId, string tableId, CancellationToken cancellationToken)
{
BigQueryClient client = GetBiqQueryClient();
return(client.DeleteTableAsync(
datasetId,
tableId,
null,
cancellationToken));
}
private async Task <BigQueryTable> GetOrCreateTable(BigQueryClient client)
{
var dataset = await client.GetOrCreateDatasetAsync(DatasetId);
try
{
await client.DeleteTableAsync(DatasetId, _tableId); // Start fresh each time
}
catch (Exception)
{
// Ignore. The table probably did not exist.
}
var table = await dataset.CreateTableAsync(_tableId, new TableSchemaBuilder
{
{ "date", BigQueryDbType.Date },
{ "num_reports", BigQueryDbType.Int64 },
}.Build());
return(table);
}
private async Task <BigQueryTable> GetOrCreateTable(BigQueryClient client, ILogger <Startup> logger)
{
logger.LogInformation($"Getting/creating destination dataset: {DatasetId}");
var dataset = await client.GetOrCreateDatasetAsync(DatasetId);
try
{
await client.DeleteTableAsync(DatasetId, _tableId); // Start fresh each time
}
catch (Exception e)
{
// Ignore. The table probably did not exist.
logger.LogError($"Table {_tableId} deletion failed: {e.Message}");
}
logger.LogInformation($"Getting/creation destination table: {_tableId}");
var table = await dataset.GetOrCreateTableAsync(_tableId, new TableSchemaBuilder
{
{ "date", BigQueryDbType.Date },
{ "num_reports", BigQueryDbType.Int64 },
}.Build());
return(table);
}
