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); }