Hey, I’m testing out dagster as an alternative for airflow in my typical stack, and I’m wondering if there’s a typical pattern for using BigQuery external tables with data stored in GCS (often in a hive-partitioned key structure). We’ve used that pattern on https://github.com/cal-itp to pretty good success; it allows us to “pull” data into bigquery via dbt incremental materializations. (Asking because I’m currently attempting to have the io manager use hive-partitioned keys)

here’s a guide to bigquery w/ dagster: https://docs.dagster.io/integrations/bigquery/reference