Dustin Basil , thanks for the info, but i am using incorta cloud appication, what are the requirements for Creating MV's, I mean what are the components i need to use to create mv. I have a sample Query here, how do i create mv and create a report in incorta. Please check the attached file.
Anil Kumar Katari You need Spark enabled for your Incorta cloud application. Once that is done, you can create an MV in the Incorta application UI within a Schema that you have defined. Note that the SQL query you have here will need to be modified to query the Incorta tables you have already extracted e.g. SELECT col1 FROM Schema.Table.
Anil Kumar Katari You can enable Spark from CMC tenant configuration by entering the spark master URI. Under <incorta home>/IncortaNode in the server, run ./startSpark.sh to start spark master and spark worker processes.
To create a MV, from the schema, add a object and select Materailzied View. The simplest way to to use SQL.
MV is a derived object that use the data are already extracted into Incorta as the source. The from clause of the SQL will refer to these extracted data using <Schema Name>.<Table Name>.