Hi Experts,
We're using SDA/SDI to connect HANA to several Remote Sources (including Snowflake) using DPA and the connection works and we can access the data without issue.
We have noticed that the queries from HANA are being stripped when they reach the remote source system so a SELECT COUNTRY, SUM(AMOUNT) from TABLE WHERE Product = 'HAT' GROUP BY COUNTRY will be interpreted as just SELECT COUNTRY, AMOUNT FROM TABLE
I understand that this is because by default these capabilities (and functions / properties) are switched off by default (Configure Remote Source Capabilities | SAP Help Portal) and must be enabled through the Alter Remote Source command i.e. ALTER REMOTE SOURCE "SourceName" SET PROPERTY 'CAP_WHERE' = 'TRUE';
Unfortunately when I check the output of this, the Remote Source's properties are not being updated and remain FALSE when I check via: CALL GET_REMOTE_SOURCE_PROPERTIES ('SourceName', ?);
I'm not seeing any authorisation errors and have the Object Privilege of ALTER on the Remote Source and System Privilege CREATE REMOTE SOURCE
Can anyone suggest what I may be missing to get this working?
Thanks in advance,
Cal