Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

'ERROR: row is too big: size 8448, maximum size 8160' & 'ERROR: tables can have at most 1600 columns' #262

Open
mbenbanaste opened this issue Jul 30, 2024 · 0 comments

Comments

@mbenbanaste
Copy link

mbenbanaste commented Jul 30, 2024

Hi, two tables are causing issues; companies and deals. We are using FiveTran but want to move hubspot integration fully to Stitch. Seems we can't. There are no settings or options I can play with, please help.

Here is the error from "companies" table:

ERROR: row is too big: size 8448, maximum size 8160
Where: COPY staging_0_121_ip-10-2-169-97-24091-5fb5ec36-753a-499b-8834-c38d, line 6

Here is the error from "deals" table:

ERROR: tables can have at most 1600 columns

I removed all columns, even with 2-3, I get this error. In FiveTran, I could see staging tables and select or deselect them; I don't see them in Stitch. And, based on documentations and error log, seems staging tables are pulled directly, causing the issue. Not sure if that's the whole story, but is a part of it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant