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.

Before you can query an S3 table using Amazon Redshift, you must create a resource link to that table’s namespace in the AWS Glue Data Catalog. After you create the link, you can use Amazon Redshift to query the tables in the linked namespace.

You can run DQL queries on S3 tables using Amazon Redshift.

Querying Amazon S3 tables in Amazon Redshift

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

To run queries using the SELECT statement, use your resource link name as a database. For more information, see Querying the AWS Glue Data Catalog in the Amazon Redshift Management Guide. The following is an example query:

SELECT * FROM awsdatacatalog.resource-link-name.table_name;