Optimizing Data Preparation with Unique Keys in Amazon QuickSight

Overview

Amazon QuickSight provides a comprehensive data visualization and analysis platform, empowering users to make data-driven decisions easily. One powerful feature available during dataset preparation is configuring a unique key column. This feature acts as a global sorting key for the dataset, optimizing query generation for table visuals and ensuring consistent sorting behavior. In this blog, we will delve into the significance of unique keys, their limitations, and the steps to designate one in Amazon QuickSight.

What is a Unique Key in QuickSight?

A unique key in Amazon QuickSight serves as a global sorting key for a dataset. When a table visual includes the unique key column in its value field well, QuickSight sorts the data left to right, up to the unique key column. Any columns positioned to the right of the unique key are excluded from the sort order. In cases where no unique key is set, tables are sorted based on the natural order of columns as they appear in the dataset.

This capability can significantly enhance the performance of table visuals by reducing query complexity and ensuring predictable sorting. Unique keys are particularly valuable for datasets used in dashboards and analyses, where consistent and optimized sorting can improve user experience.

Limitations of Unique Keys

While unique keys provide several benefits, it is essential to understand their limitations:

1. No Support for Unaggregated Tables: Unique keys do not apply to unaggregated tables. Ensure your table visual meets the aggregation requirements before configuring a unique key.
2. Incompatibility with Column Level Security (CLS): If a dataset column is being used for column-level security, it cannot also serve as the unique key. This restriction ensures that security configurations remain unaffected by sorting optimizations.

How to Set Up a Unique Key in Amazon QuickSight

Follow these steps to designate a unique key for a dataset in Amazon QuickSight:

Step 1: Open the Amazon QuickSight Console

Log in to your Amazon QuickSight account and navigate to the Datasets section.

Step 2: Select or Create a Dataset

You can either choose an existing dataset or create a new one. Perform one of the following actions:

• Navigate to the dataset you want to modify, click the ellipsis (three dots) next to it, and select Edit.
• To create a new dataset, click new dataset, select the appropriate data source, and choose Edit data source. For more details on creating datasets, refer to the Amazon QuickSight documentation on creating datasets.

Step 3: Access the Data Preparation Page

The dataset’s data preparation page will open. Here, you can manage the fields within the dataset.

Step 4: Locate the Desired Field

In the Fields pane, identify the field you wish to set as the unique key.

Step 5: Set the Unique Key

Click the ellipsis (three dots) next to the field name and select Set as a unique key. Once selected, a key icon will appear next to the field name, indicating that it is now the unique key for the dataset.

Step 6: Save and Publish the Dataset

After configuring the unique key, save and publish the dataset. The unique key setting will automatically apply to all dashboards and analyses that use this dataset.

How to Remove or Change a Unique Key

If you need to modify the unique key:

1. Navigate back to the data preparation page for the dataset.
2. Click the ellipsis next to the current unique key field and select Remove as a unique key.
3. Once the unique key is removed, you can designate another field as the unique key by following the steps outlined above.

Why Use Unique Keys?

Designating a unique key offers several advantages:

• Optimized Query Generation: Reduces the complexity of queries generated for table visuals, improving performance.
• Consistent Sorting: Ensures predictable sorting behavior in table visuals, enhancing data presentation.
• Improved User Experience: Provides clarity and consistency across dashboards, making it easier for users to interpret data.

By leveraging unique keys, Amazon QuickSight authors can ensure datasets perform efficiently and deliver high-quality insights to stakeholders.

Conclusion

The ability to configure a unique key in Amazon QuickSight is a powerful feature that simplifies sorting and optimizes query performance for table visuals.

Whether creating a new dataset or refining an existing one, utilizing unique keys can play a pivotal role in improving the efficiency and clarity of your data visualizations. Explore this feature today and unlock new possibilities for your business intelligence solutions.

Drop a query if you have any questions regarding Amazon QuickSight and we will get back to you quickly.

About CloudThat

CloudThat is a leading provider of Cloud Training and Consulting services with a global presence in India, the USA, Asia, Europe, and Africa. Specializing in AWS, Microsoft Azure, GCP, VMware, Databricks, and more, the company serves mid-market and enterprise clients, offering comprehensive expertise in Cloud Migration, Data Platforms, DevOps, IoT, AI/ML, and more.

CloudThat is the first Indian Company to win the prestigious Microsoft Partner 2024 Award and is recognized as a top-tier partner with AWS and Microsoft, including the prestigious ‘Think Big’ partner award from AWS and the Microsoft Superstars FY 2023 award in Asia & India. Having trained 650k+ professionals in 500+ cloud certifications and completed 300+ consulting projects globally, CloudThat is an official AWS Advanced Consulting Partner, Microsoft Gold Partner, AWS Training Partner, AWS Migration Partner, AWS Data and Analytics Partner, AWS DevOps Competency Partner, AWS GenAI Competency Partner, Amazon QuickSight Service Delivery Partner, Amazon EKS Service Delivery Partner,  AWS Microsoft Workload Partners, Amazon EC2 Service Delivery Partner, Amazon ECS Service Delivery Partner, AWS Glue Service Delivery Partner, Amazon Redshift Service Delivery Partner, AWS Control Tower Service Delivery Partner, AWS WAF Service Delivery Partner, Amazon CloudFront, Amazon OpenSearch, AWS DMS and many more.