Datasets updating with the wrong source on S3

Question & Answer
, ,
1

It appears that existing datasets are updating with the wrong datasource. I have a dataset that uses several datasources and datasets all of which are updated on S3 using manifest files. When I refresh some of them, the data it loads is from the wrong source.

For a given dataset how can I see what S3 file the data is coming from and what manifest file it is using?

2

Hi @jm_fen. You can see what datasource a dataset is using by going to the Datasets tab

image

Then clicking on the 3 dots shown below and clicking Edit

image
image1106×367 20.5 KB

Next, click the 3 dots as shown below and click View details

image

This will show you the following information about your dataset
image

I am not as familiar with Manifest files but I will look into that and get back to you.

3

Hi @jm_fen. You can see what datasource a dataset is using by going to the Datasets tab

image

Then clicking on the 3 dots shown below and clicking Edit

image
image1106×367 20.5 KB

Next, click the 3 dots as shown below and click View details

image

This will show you the following information about your dataset
image

4

Thank you. When I follow those steps I am not able to see the details - just the name I gave it.

image
image714×466 35.4 KB

1 Like
5

Hi @jm_fen! For additional details on the data source you can run describe-data-source API call. Please refer to below documentation link.
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/describe_data_source.html
Below is a sample of response from describe-data-source API call for a S3 based data source.

image
image956×305 35.7 KB

Regards,
Karthik

6

Thanks. That works. Would be easier if you could see graphically though instead of using the boto3