I tried creating an MV using Incorta SQL as Data Source, but I keep getting below error as shown below. Can you help me understand when to use this particular type in creating MV's.
INC_04030340: Materializing table failed because 109152
This option is for spark sql and it can refer to incorta physical schema tables (no business schema allowed here) . You can paste your sql here and I can check . Pls also log a ticket .
@srini_ch - Not sure if this applies in your case, but a materialized view column cannot reference a column in an Incorta Analyzer table or Incorta SQL table that exists in the same physical schema as the materialized view.
I wanted to follow up here. Were you able to get this working as expected?