https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
n

Nathan Atkins

05/28/2021, 5:19 PM
Just fired up Airbyte this morning. Eventually I want to replicate Mongo DB to Postgres. I started with Postgres to Postgres with the DVD Rental database. I got the source and destination setup and the connector working to replicate from one database to another. I had expected the table schema in the new database to match the source database, but I wound up with all the data in a jsonb blob. This matches the Postgres Destination Documentation, but is different than my expectations. Is this the expected behavior or do I need to configure something differently?
1
u

[DEPRECATED] Marcos Marx

05/28/2021, 5:21 PM
@Nathan Atkins did you enable
Basic normalization
in the pstgres destination?
n

Nathan Atkins

05/28/2021, 5:23 PM
Let me see if I can find that.
That did the trick. Now to fire up a Mongo DB and see what happens. Thanks for the quick response.
4 Views