Once a reflection has been created using following
ALTER TABLE <TABLE_PATH> ADD RAW REFLECTION
DISPLAY (
field1,
field2,
field3
)
PARTITION BY (field1)
LOCALSORT BY (field2)
AS <REFLECTION_NAME>
What is the SQL syntax for managing the refresh policy, create new or change existing, drop existing policy and add new etc
Hi @pradeep, currently refresh policy configuration is supported only in the UI. You can configure this per source or source file/dataset. All the reflections on this source/dataset and their child datasets will use the specified refresh policy. API support for source configuration, among other things, is on our short-term roadmap – this is as a part of our initiative to minimize UI dependencies for administrative/management tasks.
Is there any SQL command to change the incremental update column? rather than doing it from GUI
Just like we define following, is there a syntax to define the incremental column
PARTITION BY (field1)
LOCALSORT BY (field2)
AS <REFLECTION_NAME>
This is also currently only supported in the UI.