Ingest data from the database directly into QuickSight SPICE, filtering to include only necessary columns using Amazon EMR.

Leverage AWS Glue Studio for data ingestion into S3, enforce column-level access via IAM policies for QuickSight users, with S3 serving as the data source in QuickSight.

Employ AWS Glue Elastic Views to generate a materialized view in S3 from the database, apply an S3 bucket policy for column-level access control, and utilize S3 as the QuickSight data source.

Utilize Lake Formation blueprint for data ingestion into S3 from the database, enforce column-level access control with Lake Formation, and use Amazon Athena as the QuickSight data source.