Alias materialised table names
AnsweredAllow aliasing materialised table names so that analytical storage data can be queryable via SQL client or third party applications
-
Comment actionsOfficial comment
Hi Kenneth, as you are using your BI Frontend directly with the DWH, we agreed on using replication instead of materialization to have named tables that can be conveniently used.
A general note here: The direct usage of mat_table_x_st_y is not recommended, as the table name will change with each materialization. Please only use the DV views or DV tables and have DV Server as a datasource if you want to use materialized data.
-
Agree, and being able to write to other DBs definitely helps! https://support.datavirtuality.com/hc/en-us/community/posts/360023830491-Replicating-to-non-DWH-datasources
Please sign in to leave a comment.
Comments
2 comments