Accessing Amazon S3 tables with Amazon Redshift

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. Redshift Serverless lets you access and analyze data without all of the configurations of a provisioned data warehouse. For more information, see Get started with serverless data warehouses in the Amazon Redshift Getting Started Guide.

Query Amazon S3 tables with Amazon Redshift

Prerequisites

• Integrate your table buckets with AWS analytics services.

  • Create a namespace.

  • Create a table.

• Granting Lake Formation permissions on your table resources.

After you complete the prerequisites, you can begin using Amazon Redshift to query tables in one of the following ways:

• Using the Amazon Redshift query editor v2

• Connecting to an Amazon Redshift data warehouse using SQL client tools

• Using the Amazon Redshift Data API