Unified BigQuery/Dataform View

[AKatoch]

Hey everyone,

Was wondering if there was a more streamlined way to look between BigQuery (to see all my projects and lineage) and Dataform (to write Dataform)? As it stands, my Devs switch back and forth, and when starting a new story on an existing repo, have to copy from Dataform into BQ and edit the FROM references to experiment and test again. I hope there are better approaches, does anyone have anything better?

I think something like a mix of plugins in VS Code would also be okay, so long as they are mostly official.

Thanks!
Andrew

[DataEngineer]

It’s not easy or convenient but here’s the only workaround I found.

After you run a sqlx file you you can select ‘View Job In SQL Workspace’. This opens the query in BQ and automatically converts your ref() calls to their BQ qualified table names.