How can I specify database schema name for externa...
# replication-ask-ai
m
How can I specify database schema name for external database when I don't want to use public schema @kapa.ai
k
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.
m
But this is not for the destination nor the source. It is for airbyte open source deployment internal database.