Load BLOB data into Snowflake table

[AbhishekBoga]

Hi,

I have a table 'ABC' in Oracle which has a column 'column1' of BLOB datatype. Want to load the data of ABC table into Snowflake table.

Using VARCHAR for BLOB in Snowflake is not working. Even tried with Object/Variant/BINARY type, but no luck.

This is the one time load that I need to perform in Snowflake table.

Is there any way to achieve the above load.

Need an urgent help

[Anonymous]

Hello,

Are you using the snowflake metadata not pure JDBC metadata from DB Connections?

Best regards

Sabrina