How to update the new password in the data base

Q&A
, ,
1

Hello Experts,

The error came in the dashboard:
Refresh error details
Error details:
FATAL: password authentication failed for user

To my understanding I need to update the redshift password in the datasets that has been created and used in the dashboard. Where can I open the settings for the created dataset to change the password ? (if it is an issue)

I tried to right click on the dataset and open the options, but it was like “create analysis”, “add to folder” etc., but no option to update the password.

thank you.

2

Hi @olgashi ,

Welcome back to the community!

For the password change, you may need to make changes to the data source used in the dataset.

To change password in data source, Navigate to create new dataset option and choose the existing data source sourcing your datasets. Instead of creating new dataset, you will find option to edit data source. Validate and update data source once changes are done.

Thanks,
Prantika

3

Hi @olgashi - As correctly mentioned by @prantika_sinha , the password is refer to the data source not the data set. you can open the data source and double click and change the password.

Regards - Sanjeeb

4

hello @sanjeeb2022, @prantika_sinha
thank you for your reply, I still got an error:

1.Open Quick Sight, select new, open Redshift (auto-discovered)
2. new redshift data source window appears
3. entered data source name
4. under Instance ID field I see the error: " Quick Sight doesn’t have permissions to access that database. Follow the instructions atManaging Amazon Quick Sight Permissions to AWS Resources to grant Quick Sight permissions to that Amazon database."
I do not understand which changes should be done: Accessing data sources - Amazon QuickSight
if you know what should be done, please let me know.
thank you!

5

Hi @olgashi - Looks like you do not have permission to update the data source. You can request your admin or you can try to update the permission of the data source using boto3 API. Please find the sample documentation for the same.

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/update_data_source_permissions.html

Regards - Sanjeeb

6

Hi @olgashi, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!