Unsupported Redshift type: binary

[misteliy]

Describe the bug

When using

                wr.redshift.copy_from_files(
                    path=path,
                    con=con,
                    table=file_name.replace(".parquet", ""),
                    schema="staging",
                    parquet_infer_sampling = 1,
                    varchar_lengths_default = 65535
                )

I'm getting following error:

most likely the data type should be mapped to varchar

How to Reproduce

*P.S. Please do not attach files as it's considered a security risk. Add code snippets directly in the message body as much as possible.*

Expected behavior

No response

Your project

No response

Screenshots

No response

OS

Linux

Python version

3.10.12

AWS SDK for pandas version

3.4.2

Additional context

No response

[kukushking]

Hi @misteliy thanks for opening this. There is VARBYTE data type that is missing from type mappings. I will cut a PR to fix this.