Hey everyone, I've been trying out Freeplay for a few weeks now, mostly for prototyping some internal dashboards. I saw the announcement about the new native BigQuery integration and just finished setting it up.
My main use case is pulling cleaned data from our BQ project into Freeplay to build charts and shareable decks. Previously, I was exporting CSVs from BQ and uploading them, which was a bit of a pain. The setup was mostly straightforward—I followed the docs to create a service account in GCP with BigQuery User permissions and added the JSON key to Freeplay.
The connection seems stable, but I'm wondering about performance. When I run a query on a moderately large table (say, ~5 million rows), it can take a minute or two to reflect in the Freeplay dataset. Is that expected? My query looks pretty standard:
```sql
SELECT
date,
region,
SUM(revenue) as daily_rev
FROM
`my-project.prod.transactions`
WHERE
date >= '2024-01-01'
GROUP BY
1, 2
```
For those who've used it: are there any specific pitfalls with JOINs or complex CTEs? Also, does the integration handle partitioned tables efficiently, or should I be optimizing my queries differently for this pipeline?
More broadly, does this integration make Freeplay a more compelling choice compared to connecting something like Looker Studio directly to BigQuery? I like Freeplay's design and collaboration features, but I'm weighing if the added layer is worth it for my team's workflow. Curious to hear your experiences!