Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/17/2024 02:14 AM - edited 10/17/2024 02:15 AM
Hello,
We need to run an enhanced query execution job to update the AWS connection type. We've performed this change in our pre-production environment. This is due to the 'Encrypted Connection Attributes' field not containing all the attributes that need to be encrypted. The query we're attempting to run is:
SELECT
EXTERNALCONNECTIONTYPEKEY externalconnectiontype__EXTERNALCONNECTIONTYPEKEY ,concat(ENCRYPTEDATTRIBUTES,',AWS_ACCESS_KEY,AWS_ACCESS_SECRET_PASSWORD') AS externalconnectiontype__ENCRYPTEDATTRIBUTES
FROM
externalconnectiontype
WHERE
EXTERNALCONNECTIONTYPEKEY=<connection_type_key>
When we attempt to save this enhanced query execution job with the above query we see the following pop-up error:
Can you advise?
10/17/2024 02:26 AM
@AT mostly likely the column is restricted you can update it via enhanced query.
10/17/2024 02:30 AM
@NM As I said above, we are trying to run the query via an enhanced query execution job. When we attempt to save the config of the job, we get the above pop-up.
10/17/2024 02:41 AM - edited 10/17/2024 02:42 AM
@AT sorry instead of can I was suppose to write can't
10/17/2024 02:44 AM
@NM Ok, thanks for clarifying that however we have ran this query in pre-prod and it's been successful. Additionally this is a core requirement of our configuration as AWS_Access_Key should be encrypted. As such how can we perform this configuration?
10/17/2024 04:00 AM
@AT prod and preprd version difference?
10/17/2024 04:49 AM
@AT can you share youe table name and primarykey of table column, looks your query is not correct
10/17/2024 06:31 AM
Use below query
SELECT
EXTERNALCONNECTIONTYPEKEY externalconnectiontype__PRIMARYKEY ,concat(ENCRYPTEDATTRIBUTES,',AWS_ACCESS_KEY,AWS_ACCESS_SECRET_PASSWORD') AS externalconnectiontype__ENCRYPTEDATTRIBUTES
FROM
externalconnectiontype
WHERE
EXTERNALCONNECTIONTYPEKEY=<connection_type_key>
Please note after upgrade this will be again removed , Please raise idea for this enhancement