/// <inheritdoc /> public override BigqueryJob CreateQueryJob(string sql, CreateQueryJobOptions options = null) { GaxRestPreconditions.CheckNotNull(sql, nameof(sql)); var query = new JobConfigurationQuery { Query = sql }; options?.ModifyRequest(query); var job = Service.Jobs.Insert(new Job { Configuration = new JobConfiguration { Query = query }, }, ProjectId).Execute(); return(new BigqueryJob(this, job)); }
/// <inheritdoc /> public override async Task <BigqueryJob> CreateQueryJobAsync(string sql, CreateQueryJobOptions options = null, CancellationToken cancellationToken = default(CancellationToken)) { GaxPreconditions.CheckNotNull(sql, nameof(sql)); var query = new JobConfigurationQuery { Query = sql, UseLegacySql = false }; options?.ModifyRequest(query); var job = await Service.Jobs.Insert(new Job { Configuration = new JobConfiguration { Query = query }, }, ProjectId).ExecuteAsync(cancellationToken).ConfigureAwait(false); return(new BigqueryJob(this, job)); }
/// <inheritdoc /> public override BigqueryJob CreateQueryJob(BigqueryCommand command, CreateQueryJobOptions options = null) { GaxPreconditions.CheckNotNull(command, nameof(command)); var query = new JobConfigurationQuery { UseLegacySql = false }; command.PopulateJobConfigurationQuery(query); options?.ModifyRequest(query); var job = Service.Jobs.Insert(new Job { Configuration = new JobConfiguration { Query = query }, }, ProjectId).Execute(); return(new BigqueryJob(this, job)); }
/// <summary> /// Creates a query job, with more facilities than <see cref="ExecuteQuery"/>, including the option /// to store the results in a persistent table. /// </summary> /// <param name="sql">The query in BigQuery's SQL dialect. 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>The query job created. Use <see cref="GetQueryResults(JobReference,GetQueryResultsOptions)"/> to retrieve /// the results of the query.</returns> public virtual BigqueryJob CreateQueryJob(string sql, CreateQueryJobOptions options = null) { throw new NotImplementedException(); }
/// <summary> /// Creates a job for a query/command, with more facilities than <see cref="ExecuteQuery(BigqueryCommand, ExecuteQueryOptions)"/>, /// including the option to store the results in a persistent table. This overload allows query parameterization, and is preferred over /// <see cref="CreateQueryJob(string, CreateQueryJobOptions)"/> when values need to be passed in. /// </summary> /// <param name="command">The command to execute. 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>The query job created. Use <see cref="GetQueryResults(JobReference,GetQueryResultsOptions)"/> to retrieve /// the results of the query.</returns> public virtual BigqueryJob CreateQueryJob(BigqueryCommand command, CreateQueryJobOptions options = null) { throw new NotImplementedException(); }
/// <summary> /// Asynchronously creates a job for a query/command, with more facilities than <see cref="ExecuteQueryAsync(BigqueryCommand, ExecuteQueryOptions,CancellationToken)"/>, /// including the option to store the results in a persistent table. This overload allows query parameterization, and is preferred over /// <see cref="CreateQueryJobAsync(string, CreateQueryJobOptions,CancellationToken)"/> when values need to be passed in. /// </summary> /// <param name="command">The command to execute. 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 /// the query job created. Use <see cref="GetQueryResultsAsync(JobReference,GetQueryResultsOptions,CancellationToken)"/> to retrieve /// the results of the query.</returns> public virtual Task <BigqueryJob> CreateQueryJobAsync(BigqueryCommand command, CreateQueryJobOptions options = null, CancellationToken cancellationToken = default(CancellationToken)) { throw new NotImplementedException(); }