![]() ![]() On the Amazon VPC console, choose Endpoints.In the next steps, you configure an Amazon Virtual Private Cloud (Amazon VPC) endpoint for Amazon S3 to allow Lambda to write federated query results to Amazon S3. Subnetids – Use the subnets where Amazon Redshift is running with comma separation.SecurityGroupID – Security group ID where Amazon Redshift is deployed.JDBCConnectorConfig – Redshift://jdbc:Redshift:// :5439/ ?user=sample2&password=sample2.SpillBucket – myworkspace0009/athenafederation.SecretNamePrefix – AthenaJdbcFederation. ![]() Application name – AthenaRedshiftConnector.In the Application settings section, provide the following details:.In the search field, enter athena federation.On the AWS Serverless Application Repository, choose Available applications.To configure Athena federation with Amazon Redshift, complete the following steps: For this post, use the name myworkspace0009/athenafederation.Ĭonfiguring Athena federation with Amazon Redshift On the Amazon S3 console, create a new S3 bucket and subfolder for Lambda to use. Leave the remaining fields at their defaults and choose Next.Use the prefix AthenaJDBCFederation so it’s easy to find. For Secret name, enter a name for your secret. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |