Hi all, is it possible to create a materialized view from an existing table in a dashboard, I want to do this because I want to create some statistics with python using the layout and data that is present in the dashboard. The table I want to use is a listing table, as I figured that an aggregate table would be more complex
Solved! Go to Solution.
With dashboard tables not referencable, you could leverage any of the objects as outlined in the above article.
Another option is to extract the SQL logic generated by the table insight, then drop that SQL into my MV to read in data via SQL statement.
Retrieve the SQL from the insight table here:
Read it into the MV using the incorta_sql() function:
df = incorta_sql("SELECT * FROM DS_Orders.Order_Source_Analyzer_Monthly WHERE (DS_Orders.Order_Source_Analyzer_Monthly.ORGANIZATION_CODE = 'M2' AND DS_Orders.Order_Source_Analyzer_Monthly.INVENTORY_ITEM_ID = 11923) AND DS_Orders.Order_Source_Analyzer_Monthly.MONTH>'2008-01-01' SORT BY DS_Orders.Order_Source_Analyzer_Monthly.MONTH ASC ") incorta.show(df)