Loading Amazon Ads Data into PostgreSQL with Large Raw Table Size Discrepancy


The user is facing an issue with a significantly large raw table size in the ‘airbyte_internal’ schema when loading Amazon ads data into PostgreSQL. The raw table is 141GB with 63 million rows, while the final table has only 8 million rows and 15GB.


Hey Guys,
i am loading amazon ads data into postgreSQL which is working fine.

The problem is that I have a raw table in the “airbyte_internal” schema which is 141GB (!) big.

This doesn’t make sense to me as the raw table has 63 million rows, while the finale table only has about 8 million rows (and only 15 GB)

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["loading-amazon-ads-data", "postgresql", "raw-table-size", "airbyte-internal-schema"]