How do you build a BI semantic layer using Amazon Redshift?

Question

I know there are marketplace solutions for building a BI semantic layer to simplify reporting, but I was wondering if there's a way to build a semantic layer in an Amazon Redshift database?

Accepted Answer

See [Sharing Amazon Redshift data securely across Amazon Redshift clusters for workload isolation](https://aws.amazon.com/blogs/big-data/sharing-amazon-redshift-data-securely-across-amazon-redshift-clusters-for-workload-isolation/) on the AWS Big Data Blog.

Also, you can use Amazon Quicksight [datasets](https://docs.aws.amazon.com/quicksight/latest/user/working-with-data-sets.html) as limited semantic layers, which can then be shared with other users.

How do you build a BI semantic layer using Amazon Redshift?

Relevant content