BigQuery Federated Queries for Cloud SQL

BigQuery has a way to connect to external sources and run queries directly on those (called Federated Queries) as if they are native BigQuery tables. Today I would like to focus on Cloud SQL Query Federation and explaining how it works and why it can be very important in your data ecosystem.
Further reading:
- Slides: slides.com/richardhe/bigquery...
- External Data Sources for BigQuery: cloud.google.com/bigquery/doc...

[@marlonbatista4548]

Can I put a parameter inside a federate query to see the data on looker studio? Its too much data and the parameters is the only solution :z

[@Iyanu-eb2eh]

how do you know if the sql table is actually connected?

[@practicalgcp2780]

Sorry it’s been a while since I created this, if it works it is connected right? Am I missing something?

[@user-yb7eq8hb3x]

can i delete from cloudsql? using bigquery

[@practicalgcp2780]

No, table federation is always read only. It’s designed to read real time data from another database but not manipulate data from a different source.