This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
Elior90
Bronze 3
Bronze 3
Since a week ago
Monday

My Stats

  • 6 Posts
  • 0 Solutions
  • 2 Likes given
  • 0 Likes received

Elior90's Bio

Badges Elior90 Earned

View all badges

Recent Activity

Incremental table for last 120 days - remove data older than that and add current date

a week ago
Hello,I'm trying to create a table which stores all the events from two other table with some aggregations for the past 120 days. I tried to solve the problem with materialized view, but it seems I hit some limitations.Because of the data volume - ea...

Incremental materialized view - can't query more than once workaround

a week ago
I need to create incremental materialized view for reporting purposes having the following source table:productdatesubproductsectorA2024-01-01AAXA2024-01-01AAXA2024-01-01ABYA2024-01-02AAXB2024-01-01AAXB2024-01-01ABXB2024-01-01ABYB2024-01-01ABYB2024-0...