arrow left
BACK TO VIDEOS
Next VIDEO
Arrow
Next VIDEO
Arrow
Demos

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