in GCP BigQuery id is BIGNUMERIC data,ora is string.
if not use id all work fine.
CODE: using Google.Apis.Auth.OAuth2; using Google.Cloud.BigQuery.V2;
var jsonPath = "acount.json";
var projectId = "Projectname";
var credentials = GoogleCredential.FromFile(jsonPath);
var client = BigQueryClient.Create(projectId, credentials);
string query = @"
SELECT *
FROM `Temp.test`
LIMIT 100";
BigQueryJob job = client.CreateQueryJob(
sql: query,
parameters: null,
options: new QueryOptions { UseQueryCache = false });
// Wait for the job to complete.
job = job.PollUntilCompleted().ThrowOnAnyError();
// Display the results
foreach (BigQueryRow row in client.GetQueryResults(job.Reference))
{
richTextBox1.Text += row["id"] + " | " + row["storeno"] + " | " + row["data"] +"\n";
}
receive this error :
System.ArgumentException: 'Value BIGNUMERIC is undefined in BigQueryDbType Parameter name: name'