Read a Bauplan Table from BigQuery with External Iceberg Tables

Query Bauplan-managed tables from BigQuery without moving or copying data. This walkthrough sets up an external Iceberg table in BigQuery that points directly at your Bauplan tables in S3. You deploy and evolve tables in Bauplan. Your analysts stay in BigQuery. The data stays in one place. What we cover: - Creating an IAM policy in AWS that grants a Google user read access to your S3 bucket - Creating an IAM role with web identity federation and attaching the policy - Creating a BigLake on AWS data connection in BigQuery - Adding the trust relationship back in AWS with the BigQuery Google identity - Creating and querying a read-only external Iceberg table in BigQuery Chapters: 00:00 - What we're building and when to use it 02:07 - Creating the IAM policy and role in AWS 03:14 - Creating the BigQuery data connection 04:49 - Trust relationship and querying the table Try Bauplan: https://app.bauplanlabs.com/ Helpful Links: 📚 Official Documentation: https://docs.bauplanlabs.com 💻 GitHub Repo: https://github.com/BauplanLabs/ 🌐 Bauplan Homepage: https://bauplanlabs.com 📄 Technical Blog: https://www.bauplanlabs.com/blog 📣 Follow Us: Twitter: https://x.com/Bauplan_labs LinkedIn: https://www.linkedin.com/company/bauplanlabs/ #bigquery #dataengineering #bauplan