Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Ability to Refresh Custom Materialized Views in Data Pipeline
Description
It would be nice to have the ability to refresh Custom Materialized Views as part of Data pipelines. This is extremely useful in 2 scenarios
1.) The customer has a reporting requirement which could be met with existing data in ADW and they can create an MV and model it using Extensibility Framework
2.) The customer has long-running Report/SQL which they want to optimize using Materialized.
The ability to have these materialized views refreshed as part of the Data Pipeline will be really helpful and simplify customer's needs to manage them separately.
Use Case and Business Need
1.) The customer has a reporting requirement which could be met with existing data in ADW and they can create an MV and model it using Extensibility Framework
2.) The customer has long-running Report/SQL which they want to optimize using Materialized.
Original Idea Number: 65aab97d6a
Comments
-
Good idea.
0 -
This can now be achieved by a combination of FAW Event Notification and OCI Functions.
0 -
We can also utilize DBT (Limited Availability Feature) to schedule and refresh materialized views or other Database objects.
0
