Data is often scattered in many places. You may store a customer table in BigQuery, while storing a sales table in Cloud SQL, and want to join the two tables in a single query. You can create a connection to the external database with the BigQuery Connection API and use federated queries to do this.
To learn more about how to set up a connection, see Working with connections.
To learn more about federated queries, see Federated queries.