How long it takes to index the dataset in topics?

[neelay]

Hi there,

Does anyone know how long QS needs to index the data?
the dataset has only 14K rows and 12 columns, and it has been going on for almost 3 hours.

tagging @DylanM @Kristin

[Kristin]

Hey @neelay. Thanks for reaching out!

@apjvinod can you look into this on Monday when you are back in the office and on call? @neelay is one of our Experts. Thx!

cc: @madihs for visibility.

[neelay]

@Kristin thanks

just an update

it still showing in progress.

[neelay]

another update

It is still in progress after 24 hours.

[apjvinod]

Hi @neelay

Thanks for raising it up , looks like index creation step got stuck . Index creation will take additional time on high cardinality columns and Direct Query datasets. Please find more details in the below post on optimizing index creation time.

How to improve QuickSight Q topic indexing time

This post covers some best practices to reduce the time it takes for a QuickSight Q topic to index. First, let’s define what a QuickSight Q topic index is. When you create a topic, Amazon QuickSight Q creates, stores, and maintains an index with definitions for data in that topic. The topic index is an index of unique string values for fields included in a topic. Q uses this index to generate correct answers when there are cell values mentioned for filters, e.g. “sales for Amazon” implying a fi…

But in this case of smaller dataset (14K) would recommend filing a case with AWS Support where we can dive into the details so that we can help you further.
Here are the steps to open a support case - Creating support cases and case management - AWS Support 1. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account.
They should be able to open an AWS Support case on your behalf.

If you could ping me Account Id , Topic Id & region separately will also check with internal team and to check the logs & analyze it further.

Thanks
Vinod

[Kristin]

Thanks @apjvinod.

@neelay, I am assuming you may already have this, but just in case, here is the link with info on creating a Support Case. Our Customer Support team can dive into details – and review logs which the Community Team does not have access to.

Creating support cases and case management - AWS Support

Hope this helps and that this issue gets resolved soon.

Kristin

[neelay]

Thanks

technical support is not available under the basic support plan.

[EnriqueS]

hello @neelay , you can still contact support for QuickSight if you select Account and billing and then QuickSight (End User) as category you should be able to log the case.

Also if you haven’t tried yet I recommend you to cancel the import and try again to see if the operation succeeds.

Thank you for posting into the QS community!