In this Aug EDW ASIN Selection datasets (which was created through custom SQL), we want to add a new column to be added - https://us-east-1.quicksight.aws.amazon.com/sn/data-sets/2a339b76-69d5-4c91-9c51-4d7cb99f1eca/view - “Case when asin in (select distinct asin from f3rbi.vw_mdl_instock_exclusion_asins) then ‘ExcludeUwiForCircularCheck’ else ‘IncludeUWIForCircularCheck’ end as UWIFlag” but the dataset doesn’t refresh/update properly.
I have tried in hubble and the query worked, however not in Quicksight. Our temporary solve is hardcoding the asins that we want to inlcude in the dataset, but this is not scalable as new ASINs will be added in to the table, and we want this reference to be dynamic.
The community will not be ably to access you Quicksight via that link.
When you say that the dataset doesn’t refresh or update properly, does Quicksight provide an error message or any kind or are there problems with the resulting dataset?
I believe that error is originating from Redshift. My main thought here is that it’s possibly something to do with an issue with data types of the key values during the joins.
Also, when you are trying to import this are you doing it via Spice or Direct query?
It’s been a few days since we have heard from you but we would still like to help find a solution. If we do not hear from you in 3 days this topic will be archived.
