Query as "All Variations" in Birst Connect from Data Lake

Deborah Bell · 2025-04-17T17:38:08+00:00

There was an error rendering this rich post.

Is it possible to use a QBO in Birst Connect to pull all variations from the data lake? Similar to how in Compass you can query using "from infor.AllVariations('table') to pull all variations that exist in the data lake, including deleted rows and overwritten rows? We are currently keeping a separate table for historical variations on a specific table and it looks like the data lake is already keeping this for us, if I just had the appropriate syntax to pull in the data.

Find more posts tagged with

Accepted answers

Diane McElhiney

Yes, by using Infor Data Lake connection, the query that you create in Compass can be pasted into the QBO. The infor.AllVariations('object') syntax is the same. The Birst Infor Data Lake connector uses the Compass driver.

All comments

Diane McElhiney

Deborah Bell

Thanks! That worked.

Enrico Menotti

Be aware that Data Lake tables may be purged, so possibly keeping a separate table for historical variations directly in your source ERP system may be anyway a good idea.