Quicksight dont refreshing data

Q&A
,
1

The Quicksight do not refresh the data. We are receiving email saying

( “Chaces_KTW4” failed to refresh

A problem occurred during the refresh of your SPICE dataset for the account “amazonbi”. Here are the details:

A general SQL error occurred. This error can be caused by query timeouts, resource constraints, unexpected data definition language (DDL) changes before or during a query, and other database errors. Check your database settings and your query, and try again.)

Can anyone help us please :slight_smile:
Thank you

2

Hi @Ladislav_Tirpak ,

Please check if there was any schema change to the underlying tables used in the query in the dataset?

Thanks,
Prantika

3

Thank you ,

Is there any chance, to cancel all the changes that has been made ?

4

Hi @Ladislav_Tirpak - It is not possible to do any changes or redo changes in Source database via Quicksight. You can only select the data via QuickSight using custom sql or whole data. In case if you are using any custom sql, you can take the sql and execute it in any sql client to verify whether the sql is working or not.

Regards - Sanjeeb

1 Like
5

Hi @Ladislav_Tirpak,
It’s been awhile since we last heard from you. Did you have any additional questions pertaining to your original topic?
If we do not hear back within 3 business days, I’ll go ahead and mark as solved.

Thank you!