Hi all,
looking for some advice on how to actually setup a datalake view. Infor help docs lead to circles :)
Any quick tips would be appreciated
ok - managed to figure it out… there is no UI - just have to create it by using SQL query in the compass ui - Create View {viewname} AS {SQL Select command}
For views, the CREATE, ALTER and DROP DDL are supported. These Compass SQL statements can be executed anywhere Compass SQL is allowed (JDBC, UI, API). You can also use Data Fabric Metagraphs to build and publish a view.
If you need those views to power frequent analytics or exports, consider syncing the underlying tables to a SQL ODS.
We use the Syynchronizer tool to automate table creation, handle schema changes, and keep data fresh with incremental loads. That way, you can use native SQL tooling (indexes/materialized logic) for speed and stability.
If you want, I can share a short demo: damir.perkic@syync .nl.
