using Google.Cloud.BigQuery.V2;
string projectId = "udp-unizin-prod";
string sql = @"SELECT id FROM `unizin-shared.event_store.expanded`
WHERE event_time BETWEEN DATETIME('2021-02-25') AND DATETIME('2021-02-26')
ORDER BY event_time DESC
LIMIT 1";
BigQueryClient client = BigQueryClient.Create(projectId);
BigQueryParameter[] parameters = null;
BigQueryResults results = client.ExecuteQuery(sql, parameters);
foreach (BigQueryRow row in results)
{
Console.WriteLine($"{row["id"]}");
}
$ dotnet run
urn:uuid:d75e6fc8-ab88-4f25-accf-a1558ae9de6e
