ALTER VDS test_nyc_incr_count_vds SET ENABLE_DEFAULT_REFLECTION = TRUE
gets a VALIDATION ERROR: [test_nyc_incr_count_vds] is not a TABLE.
Default reflection is already enabled on a VDS if the reflection is raw and all columns of the reflection are selected as the DISPLAY columns
Can we get the profile of this failed job?
On giving this alter vds statement, it immediately results in the error:
Run this statement:
ALTER VDS test_nyc_incr_count_vds SET ENABLE_DEFAULT_REFLECTION = TRUE
Immediately receive this error:
gets a VALIDATION ERROR: [test_nyc_incr_count_vds] is not a TABLE
Qery plan attached.
Is “test_nyc_incr_count_vds”, in your home space? If not you need to give fully qualified name of set context vi query window. Either Navigate to the dataset, click the dataset and then run the command, if not use query window context as as shown in below screenshot
Giving full qualified name doesnt work either, same error. Profile attached.
Let us try something different, as I said, default reflection is by default enabled. Create a raw reflection on the VDS with all columns selected. Then run a query on that dataset and see id the query is accelerated. Open the profile, click on acceleration tab and scroll down to the reflection details and see if it says Default Reflection: Yes