Redshift Serverless - Create a Firehose Stream

Open the Amazon Data Firehose console.

Click Create Firehose Stream.

Under Source, select Direct PUT.

Under Destination, select Amazon Redshift.

Change or take a note of the default stream name as it will be required later during Metarouter UI setup.

Select the Redshift Serverless workgroup you created earlier.

Enter the custom Redshift database name you created earlier.

As part of the Redshift Authentication make sure to enter the redshift username and password you cerated earlier during redshift setup.

Enter a staging table name (e.g. staging_firehose, data will be loaded here before being distributed to target tables).

Select the S3 bucket you created earlier as the intermediary storage.

Configure COPY command options as follows:

json 'auto ignorecase'

Keep the buffer configuration at default (adjust as needed).

Click Create Firehose Stream.

Open the Configuration tab.

Scroll down and click Edit for Service Access.

Under IAM Role, select Choose Existing IAM Role and attach the IAM role you created earlier (same role used for Redshift).

Click Save Changes.