Change datasource from custom SQL to a table in redshift (same schema) and not lose ananlysis

[Madura_Puri]

Hello,

I have a running dashboard using the amazobi account that uses a custom SQL query on my redshift cluster. The query has been failing since the past few days - I suspect it’s due to data volume/ timeout issues. I have moved the query logic to another program and the same data is now in a redshift table.

I want to plug this redshift table as a datasource into my analyses to retain all the calculations/logic/visuals and not lose all that work. How can I achieve this? Thanks a lot

[Sanjeeb2022]

Hi @Madura_Puri - You can take a copy of a dashboard and test it first. You can always replace the data set by opening the analysis and follow the below steps. Please do a POC before changing all dashboards.

Regards - Sanjeeb

[Madura_Puri]

Thank you for this!! Will do tests and POCs before for sure.