Based on the information provided in the extracts, you can specify the schema name for an external database in Airbyte during the destination setup process. Here are the steps: 1. Log into your Airbyte Cloud account. 2. In the left navigation bar, click
Destinations. In the top-right corner, click
new destination. 3. On the Set up the destination page, enter the name for the connector and select the appropriate Destination type from the dropdown. 4. Enter a name for your source. 5. For the
Host,
Port, and
DB Name, enter the hostname, port number, and name for your database. 6. List the
Default Schemas. The schema names are case sensitive. Multiple schemas may be used at one time. If no schemas are set explicitly, it will sync all of the existing ones. 7. For
User and
Password, enter the username and password for your database. Please note that the 'public' schema is set by default. If you want to use a different schema, you can specify it in the
Default Schemas field. For more details, you can refer to the [Postgres destination setup guide](
https://docs.airbyte.com/integrations/destinations/postgres). However, it's important to note that based on a [previous support conversation](
https://airbytehq.slack.com/archives/C021JANJ6TY/p1675584224950079), currently, it's not possible to specify separate schemas for raw and normalized data in Airbyte. You might need to create some external post-operation to move the tables to another schema using dbt or other tools.