Hi All, I have recently set up an airbyte connecto...
# help-connector-developmentb
Benjamin Edwards
04/27/2023, 10:39 AMHi All, I have recently set up an airbyte connector between postgres and snowflake. I have tried to set the destination namespace to 'mirror source structure' and this successfully loads data into a schema with the same name as the schema in the source ostgres database. however it also creates an empty table with the same name in the default destination schema as well as creating an _AIRBYTE_RAW_* table in the default database. This seems like an unnecessary duplication of data. Are there configuration changes that can be made so source data is copied only into the same schema name in the destination or is it recommended to change the default destination schema to the required schema for each source schema?
k
kapa.ai
04/27/2023, 10:39 AMA message from kapa.ai
kapa.ai
04/27/2023, 10:40 AMNew message text here
b
Benjamin Edwards
04/27/2023, 10:41 AMOkay thanks
Benjamin Edwards
04/27/2023, 10:50 AMCould you also elaborate on whether it is possible to configure the snowflake warehouse used for a particular stream, changing it from the default warehouse
Benjamin Edwards
04/27/2023, 10:51 AM@kapa.ai
k
kapa.ai
04/27/2023, 10:51 AMA message from kapa.ai
kapa.ai
04/27/2023, 10:51 AMSorry @Benjamin Edwards, I seem to be having a bit of trouble. Don't worry though, I've pinged my support folks and they will try to fix me up! 🧑💻
Perhaps try again in 5mins?
b
Benjamin Edwards
04/27/2023, 10:53 AM@kapa.ai Could you also elaborate on whether it is possible to configure the snowflake warehouse used for a particular stream, changing it from the default warehouse
k
kapa.ai
04/27/2023, 10:53 AMA message from kapa.ai
kapa.ai
04/27/2023, 10:53 AMHmm, I don't know enough to give you a confident answer yet. However, you can refer to the Airbyte documentation for more information on configuring Snowflake destinations: [Airbyte Snowflake Destination](https://docs.airbyte.com/integrations/destinations/snowflake)