Dataform and BI Engine

Google Cloud Data Analytics
1

It seems that queries run from Dataform are not able to utilize the BI Engine.

Is there a way to use the BI Engine with Dataform?

9 Likes
2

Interesting. Can you expand a bit i.e. scope of what you cached in the BI engine + SQL you used in BQ that did use the engine, and the SQLX that did not ?

I can think of cases where the wrapping into a procedure may fool the engine but views should work as is.

6 Likes
3

Thank you for the response. You were right, it’s not really a problem with Dataform. As far as I understood, the BI engine can only be used with SELECT statements and not for creating tables.

5 Likes