/// <inheritdoc />
public override BigQueryResults ExecuteQuery(string sql, ExecuteQueryOptions options = null)
{
GaxPreconditions.CheckNotNull(sql, nameof(sql));
var queryRequest = new QueryRequest {
Query = sql, UseLegacySql = false
};
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
var queryResponse = request.Execute();
return(new BigQueryResults(this, queryResponse, options));
}
/// <inheritdoc />
public override async Task <BigQueryResults> ExecuteQueryAsync(string sql, ExecuteQueryOptions options = null, CancellationToken cancellationToken = default(CancellationToken))
{
GaxPreconditions.CheckNotNull(sql, nameof(sql));
var queryRequest = new QueryRequest {
Query = sql, UseLegacySql = false
};
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
var queryResponse = await request.ExecuteAsync(cancellationToken).ConfigureAwait(false);
return(new BigQueryResults(this, queryResponse, options));
}
/// <inheritdoc />
public override BigQueryResults ExecuteQuery(BigQueryCommand command, ExecuteQueryOptions options = null)
{
GaxPreconditions.CheckNotNull(command, nameof(command));
var queryRequest = new QueryRequest {
UseLegacySql = false
};
command.PopulateQueryRequest(queryRequest);
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
var queryResponse = request.Execute();
return(new BigQueryResults(this, queryResponse, options));
}
/// <inheritdoc />
public override async Task <BigQueryResults> ExecuteQueryAsync(BigQueryCommand command, ExecuteQueryOptions options = null, CancellationToken cancellationToken = default(CancellationToken))
{
GaxPreconditions.CheckNotNull(command, nameof(command));
var queryRequest = new QueryRequest {
UseLegacySql = false
};
command.PopulateQueryRequest(queryRequest);
options?.ModifyRequest(queryRequest);
var request = Service.Jobs.Query(queryRequest, ProjectId);
request.ModifyRequest += _versionHeaderAction;
var queryResponse = await request.ExecuteAsync(cancellationToken).ConfigureAwait(false);
return(new BigQueryResults(this, queryResponse, options));
}
