Reflection Refresh

Hi Dremio Team,

Iam using Dremio 13.x community version and I need to know some cases like,

  1. How to load few data(like last 7 days) from a table to incremental reflection insted of total data when reflection creation.
  2. How to delete certain data (like < 7 days old data) from incremental reflection.
  3. Sys tables date columns are in UTC format can change to IST with an configuration.

Thanks,
Ajay Babu Maguluri.

Hi Team,

Waiting for update.

Thanks,
Ajay Babu Maguluri

@AjayBabuM

#1 Create a VDS with a filter clause that has only 7 days of data and then create the incremental reflection on top of the VDS. You need to set the refresh type to incremental on the PDS setting
#2 Currently not supported
#3 Use CONVERT_TIMEZONE function

http://docs.dremio.com/sql-reference/sql-functions/datetime-functions/