public void UploadCsv_JobLabels() { var client = BigQueryClient.Create(_fixture.ProjectId); var tableReference = client.GetTableReference(_fixture.DatasetId, _fixture.CreateTableId()); string[] csvRows = { "Name,GameStarted", "Ben,2014-08-19T12:41:35.220Z", "Lucy,2014-08-20T12:41:35.220Z", "Rohit,2014-08-21T12:41:35.220Z" }; var bytes = Encoding.UTF8.GetBytes(string.Join("\n", csvRows)); TableSchema schema = null; var job = client.UploadCsv(tableReference, schema, new MemoryStream(bytes), new UploadCsvOptions { Autodetect = true, Labels = JobsTest.JobLabels }); JobsTest.VerifyJobLabels(job?.Resource?.Configuration?.Labels); job = job.PollUntilCompleted().ThrowOnAnyError(); JobsTest.VerifyJobLabels(job?.Resource?.Configuration?.Labels); }
public void SynchronousTemporaryQuery_JobLabels() { var projectId = _fixture.ProjectId; var client = BigQueryClient.Create(projectId); var table = client.GetTable(PublicDatasetsProject, PublicDatasetsDataset, ShakespeareTable); var sql = $"SELECT corpus as title, COUNT(word) as unique_words FROM {table} GROUP BY title ORDER BY unique_words DESC LIMIT 10"; var options = new QueryOptions { Labels = JobsTest.JobLabels }; var queryJob = client.CreateQueryJob(sql, null, options); JobsTest.VerifyJobLabels(queryJob?.Resource?.Configuration?.Labels); queryJob.PollUntilCompleted().ThrowOnAnyError(); JobsTest.VerifyJobLabels(queryJob?.Resource?.Configuration?.Labels); }