i’m trying to create a program that fetch data from a bigquery table in a faster way compared the canonical example given by google.
<code>string projectId = "myoriject";
string credentialFile = "C:\DEV\license.json";
GoogleCredential credential = GoogleCredential.FromFile(credentialFile);
BigQueryClient client = BigQueryClient.Create(projectId, credential);
string sql = "select * from `cloudenergy.data` limit 10000";
BigQueryResults results = client.ExecuteQuery(sql, null);
foreach (BigQueryRow row in results)
{
//read results
}
</code>
<code>string projectId = "myoriject";
string credentialFile = "C:\DEV\license.json";
GoogleCredential credential = GoogleCredential.FromFile(credentialFile);
BigQueryClient client = BigQueryClient.Create(projectId, credential);
string sql = "select * from `cloudenergy.data` limit 10000";
BigQueryResults results = client.ExecuteQuery(sql, null);
foreach (BigQueryRow row in results)
{
//read results
}
</code>
string projectId = "myoriject";
string credentialFile = "C:\DEV\license.json";
GoogleCredential credential = GoogleCredential.FromFile(credentialFile);
BigQueryClient client = BigQueryClient.Create(projectId, credential);
string sql = "select * from `cloudenergy.data` limit 10000";
BigQueryResults results = client.ExecuteQuery(sql, null);
foreach (BigQueryRow row in results)
{
//read results
}
If i use the code above (from google documentation), the cursor take a lot of time to fetch data, about 12 seconds.
I found references about Google.Cloud.BigQuery.Storage.V1.BigQueryReadClient but the only example i found is incomplete.
Could you please post a solution to fetch data with this new method?
Thanks
Fabio
New contributor
Supporto Informatico Energy In is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.