Alias materialised table names

Answered

Follow

1

Kenneth Chan

• September 06, 2018 03:22

Allow aliasing materialised table names so that analytical storage data can be queryable via SQL client or third party applications

• Comment actions Permalink

  Official comment

  

  Matthias Korn

  • September 27, 2018 09:36

  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.

• 0

  Comment actions Permalink

  

  Kenneth Chan

  • September 28, 2018 13:16

  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.