Solved: Dataform and BI Engine

Jon_ · 04-12-2024 06:23 AM

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?

yan-hic

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.

View solution in original post

yan-hic

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.

Jon_

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.