I’ve been exploring AWS analytics services again so it’s time for another TIL. This post goes over accessing and querying S3 tables from QuickSight, via Athena, as S3 tables don’t natively work with QuickSight.
Here’s the TL;DR on what you need to do:
Create your S3 Tables bucket, namespace and table. Ensure that your S3 Tables bucket has AWS analytics service integration enabled. Grant your QuickSight user permission to the S3 table via LakeFormation and your QuickSight service role permisisons through IAM. Add Athena as a data source in QuickSight. Add a dataset from the previously created data source and use custom SQL to query your S3 Tables. Verify you can use your table dataset from an analysis. Those are a lot of steps and here are some AWS resources that explain them:
Read more...