Another example, the stream from API is called "HashedEmailAddress" and that's how we have the column named in our inline schema. However, it appears in the table as "hashed_email_address" and results in a primary key error target-mysql seems to be changing the camel case to snake case automatically which is fine but affecting primary key declaration

We have a workaround using post_process that resolved the error But I don't think this is best practice

def post_process(self, row: dict, context: dict | None = None) -> dict | None:
        """
        We can add created and updated time columns from field column
        """

        try:
            row["title"] = str(row["Title"])
        except:
            pass

        return super().post_process(row, context)

You could do a schema override with your tap and manually add

hashed_email_address

just to get you by, but I wouldn't dive too far down that rabbit hole to get it working I"d just look at the target and try to fix whatever is going on.

Sharing your logs would be helpful too