> For the complete documentation index, see [llms.txt](https://resources.unizin.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-lake/synthetic-data/query-synthetic-data-via-client-libraries.md).

# Query Synthetic Data via client libraries

{% tabs %}
{% tab title=".NET" %}

```csharp
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"]}");
}
```

```sh
$ dotnet run
urn:uuid:d75e6fc8-ab88-4f25-accf-a1558ae9de6e
```

See more at <https://cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.V2/latest>
{% endtab %}
{% endtabs %}