TL;DR
- SourceMedium data lives in BigQuery, so you can use it in any BI tool that can connect to BigQuery.
- You’ll typically select your Google Cloud project → dataset (commonly
sm_transformed_v2) → table/view (or use a custom SQL query). - Make sure the user or service account you connect with has the right BigQuery permissions for the project/dataset.
Recommended Google docs (best starting points)
- BigQuery data analysis tools overview
- Tableau + BigQuery
- Looker + BigQuery
- Looker Studio + BigQuery
- Third-party integrations
Notes for SourceMedium customers
- For Looker Studio specifically, see Connect BigQuery to Looker Studio.
- For Metabase, see Connect Metabase, which includes a starter executive summary dashboard.
- If you’re building dashboards for a team, prefer connecting with a service account (or a shared/managed identity) so access doesn’t break when an employee leaves.
- To get a service account key file without any Google Cloud setup, an organization admin opens Dashboards & Apps in your SourceMedium workspace, chooses Another BI tool, names the credential after the tool and downloads its key file from the one-time panel.