Hi all, I’m still struggling with the Hubspot tap....
# troubleshooting
s
Hi all, I’m still struggling with the Hubspot tap. The problem is that the extracted columns contain JSON, like in the screenshot. If I however set the data flattening level to “1” for the Postgres loader, I get the error below. I can however not deselect this column as it does not appear when running
meltano select tap-hubspot --list --all
Copy code
2022-04-19T09:21:38.065398Z [error    ] Loading failed                 code=1 job_id=2022-04-19T092131--tap-hubspot--target-postgres message=ValueError: Duplicate column name produced in schema: phtbccadc__value name=meltano run_id=b145a32e-af69-4527-a682-7b6b2401f713