AWS, Cloud Computing, Data Analytics

4 Mins Read

Column-Level Security in Amazon QuickSight


Amazon QuickSight’s column-level security (CLS) is critical for information security-conscious organizations. This cloud-based business service allows administrators to control access to certain information, ensuring that only authorized users can access sensitive information. Using script-level and security policies, CLS provides a security framework that supports data privacy, multi-group access, and resiliency to meet changing business needs.

It facilitates compliance, ensures organizations meet stringent standards and maintains stakeholder trust. Based on the importance of data management, the security system in Amazon QuickSight increases security without compromising data usage.


In the ever-evolving world of data analytics and business intelligence, organizations must balance accessibility and security. Ensuring users have access to accurate information while maintaining tight security is critical to making informed decisions and protecting sensitive information. A powerful solution to this challenge is line-level security, a feature Amazon QuickSight offers.

Pioneers in Cloud Consulting & Migration Services

  • Reduced infrastructural costs
  • Accelerated application deployment
Get Started

Column-Level Security

Column-level security is a granular access control mechanism that allows organizations to restrict access to specific columns in a dataset based on user credentials or permissions. Amazon QuickSight’s column-level security allows administrators to define and implement effective controls over who can view data in the dataset, ensuring that only authorized users can access sensitive or confidential information.

Example for Column Level Security in Amazon QuickSight

  1. Open the Amazon QuickSight in the AWS management console.
  2. Create the dataset by uploading the sample.csv file.
  3. Select the dataset you uploaded and then tap on setup near column level security, as shown in the below image.


  1. The uploaded dataset has 2 columns (name, age). Choose a name column to restrict access, as shown in the image below.


  1. Now, choose the user or group you want to give access to, as shown in the below image.



  1. The image below shows the dashboard that the user sees with access to the name column.


  1. Below is the image that shows the dashboard view for the user with no access to the name column.


Key Components of Column Level Security


Amazon QuickSight relies on data as the foundation for creating visualizations and dashboards. Column-level security allows you to define access rules for columns in this database. This ensures that users only see the information they are authorized to see, even if it includes a broader range of information.

Security Policy:

Amazon QuickSight security policy is a policy that determines which users or groups can access certain channels. Administrators can define these rules by customer, group membership, or other context. For example, the sales team can access revenue-related data, while the human resources department can only see employee-related data.

Advantages of Column Level Security

  • Increase data privacy:

Column Level Security ensures that sensitive information does not fall into unauthorized hands. This is important for organizations that manage private information such as personal details, financial information, or business insights. By restricting access at the line level, organizations can control data privacy and adhere to regulatory standards.

  • Access to different groups:

Different groups within an organization often need access to certain information. Column-level security allows administrators to customize access by job and role. This ensures that all teams can access information relevant to their business without compromising irrelevant information.

  • Keep pace with changing needs:

As business needs evolve, so do security needs. Column-level security provides rapid flexibility for changes. Administrators can easily adjust security policies to accommodate business changes when adding new users, changing access levels, or implementing additional security measures.

  • Easier compliance:

Many businesses have stringent compliance requirements, and data security is important to meeting these standards. column-level security helps organizations stay compliant by providing a robust system for managing data entry. This can help organizations avoid penalties and maintain stakeholder trust.


The security system in Amazon QuickSight is a powerful tool that allows organizations to control their data and ensure that only those with authorization have appropriate access to sensitive information. Administrators can implement effective security measures using level notes, policies, and controls. This improves data privacy and compliance and enables organizations to make the most of their data while reducing security risks. As businesses grapple with complex data management environments, the level of security in Amazon QuickSight is critical to creating a safe and robust data ecosystem.

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

Making IT Networks Enterprise-ready – Cloud Management Services

  • Accelerated cloud migration
  • End-to-end view of the cloud environment
Get Started

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 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 PartnerAWS Migration PartnerAWS Data and Analytics PartnerAWS DevOps Competency PartnerAmazon QuickSight Service Delivery PartnerAmazon EKS Service Delivery PartnerAWS Microsoft Workload PartnersAmazon EC2 Service Delivery Partner, and many more.

To get started, go through our Consultancy page and Managed Services PackageCloudThat’s offerings.


1. Is the column level security(CLS) supported for non-Amazon QuickSight users?

ANS: – CLS is not directly applied to non-Amazon QuickSight users or external users who don’t have access to the Amazon QuickSight platform.

2. Can Column level security(CLS) be applied to all datasets in Amazon QuickSight?

ANS: – Yes, CLS can be applied to various datasets in Amazon QuickSight, providing a granular level of control over column access.

3. How does Column level security(CLS) enhance data privacy?

ANS: – CLS enhances data privacy by restricting access to sensitive information. It ensures that only authorized users or groups can access specific columns, safeguarding personal, financial, or proprietary data from unauthorized access.

WRITTEN BY Lakshmi P Vardhini



    Click to Comment

Get The Most Out Of Us

Our support doesn't end here. We have monthly newsletters, study guides, practice questions, and more to assist you in upgrading your cloud career. Subscribe to get them all!