I'm getting an issue with the "Building a Data Warehouse using Matillion - Bulding a Data Warehouse - Level 1" training. Everything seems fine with the validation, but then the execution fails with error: "software.amazon.awssdk.services.s3.model.NoSuchBucketException: The specified bucket does not exist (Service: S3, Status Code: 404, Request ID: BPYPXQWD0FGKFF5B, Extended Request ID: HHzvdNKh1JPqvIWPItOTlcCG7cqnfxPtf7u2hAot52NtrQtsYZ/+YqQGB3VCHo2o5cCKfT/8gqo=)".
I'm a newb, using the 2 week Matillion trial on the EU region with Snowflake and Matillion Hosted Agent.
Welcome to the Matillion Community and thank you for starting out on our Academy! thanks for your question.
On the page, there is a section that outlines the following:
Stage Platform - when using Matillion Hosted Agent
You will be using the Snowflake Managed option instead of the Existing Amazon S3 Location as part of the Stage Platform property when configuring the RDS Query component
This should help you get past this section, please keep me posted :)
I figured it out just seconds before I saw your response 🙈 and the execution went through successfully.
I set up my HUB account with Snowflake and used the Database Query component.
I also found this "Stage Platform - when using Matillion Hosted Agent
You will be using the Snowflake Managed option instead of the Existing Amazon S3 Location as part of the Stage Platform property when configuring the RDS Query component" in the "Matillion Data Productivity Cloud, Foundations" notes.
