/// <summary> /// Uploads a stream of CSV data to this table. /// This method just creates a <see cref="TableReference"/> and delegates to <see cref="BigQueryClient.UploadCsv(TableReference, TableSchema, Stream, UploadCsvOptions)"/>. /// </summary> /// <param name="input">The stream of input data. Must not be null.</param> /// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param> /// <returns>A data upload job.</returns> public BigQueryJob UploadCsv(Stream input, UploadCsvOptions options = null) => _client.UploadCsv(Reference, Schema, input, options);
/// <summary> /// Asynchronously uploads a stream of CSV data to this table. /// This method just creates a <see cref="TableReference"/> and delegates to <see cref="BigQueryClient.UploadCsvAsync(TableReference, TableSchema, Stream, UploadCsvOptions, CancellationToken)"/>. /// </summary> /// <param name="input">The stream of input data. Must not be null.</param> /// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param> /// <param name="cancellationToken">The token to monitor for cancellation requests.</param> /// <returns>A task representing the asynchronous operation. When complete, the result is /// a data upload job.</returns> public Task <BigQueryJob> UploadCsvAsync(Stream input, UploadCsvOptions options = null, CancellationToken cancellationToken = default) => _client.UploadCsvAsync(Reference, Schema, input, options, cancellationToken);
/// <summary> /// Uploads a stream of CSV data to a table. /// This method just creates a <see cref="TableReference"/> and delegates to <see cref="BigQueryClient.UploadCsv(TableReference, TableSchema, Stream, UploadCsvOptions)"/>. /// </summary> /// <param name="tableId">The table ID. Must not be null.</param> /// <param name="schema">The schema of the data. May be null if the table already exists, in which case the table schema will be fetched and used.</param> /// <param name="input">The stream of input data. Must not be null.</param> /// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param> /// <returns>A data upload job.</returns> public BigQueryJob UploadCsv(string tableId, TableSchema schema, Stream input, UploadCsvOptions options = null) => _client.UploadCsv(GetTableReference(tableId), schema, input, options);
/// <summary> /// Asynchronously uploads a stream of CSV data to a table. /// This method just creates a <see cref="TableReference"/> and delegates to <see cref="BigQueryClient.UploadCsvAsync(TableReference, TableSchema, Stream, UploadCsvOptions, CancellationToken)"/>. /// </summary> /// <param name="tableId">The table ID. Must not be null.</param> /// <param name="schema">The schema of the data. May be null if the table already exists, in which case the table schema will be fetched and used.</param> /// <param name="input">The stream of input data. Must not be null.</param> /// <param name="options">The options for the operation. May be null, in which case defaults will be supplied.</param> /// <param name="cancellationToken">The token to monitor for cancellation requests.</param> /// <returns>A task representing the asynchronous operation. When complete, the result is /// a data upload job.</returns> public Task <BigQueryJob> UploadCsvAsync(string tableId, TableSchema schema, Stream input, UploadCsvOptions options = null, CancellationToken cancellationToken = default) => _client.UploadCsvAsync(GetTableReference(tableId), schema, input, options, cancellationToken);
// TODO: Allow JSON and CSV to be loaded from a TextReader? Tricky, but useful.
/// <inheritdoc />
public override BigQueryJob UploadCsv(TableReference tableReference, TableSchema schema, Stream input, UploadCsvOptions options = null)
{
GaxPreconditions.CheckNotNull(tableReference, nameof(tableReference));
GaxPreconditions.CheckNotNull(input, nameof(input));
schema = schema ?? (options?.Autodetect == true ? null : GetSchema(tableReference));
var configuration = new JobConfigurationLoad
{
DestinationTable = tableReference,
SourceFormat = "CSV",
Schema = schema,
};
options?.ModifyConfiguration(configuration);
return UploadData(configuration, input, "text/csv", options);
}
/// <inheritdoc />
public override async Task<BigQueryJob> UploadCsvAsync(TableReference tableReference, TableSchema schema, Stream input, UploadCsvOptions options = null, CancellationToken cancellationToken = default)
{
GaxPreconditions.CheckNotNull(tableReference, nameof(tableReference));
GaxPreconditions.CheckNotNull(input, nameof(input));
schema = schema ?? (options?.Autodetect == true ? null : await GetSchemaAsync(tableReference, cancellationToken).ConfigureAwait(false));
var configuration = new JobConfigurationLoad
{
DestinationTable = tableReference,
SourceFormat = "CSV",
Schema = schema,
};
options?.ModifyConfiguration(configuration);
return await UploadDataAsync(configuration, input, "text/csv", options, cancellationToken).ConfigureAwait(false);
}