Load BLOB data into Snowflake table

AbhishekBoga — Sat, 16 Nov 2024 00:43:01 GMT

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

Re: Load BLOB data into Snowflake table

Anonymous — Tue, 02 Feb 2021 09:20:24 GMT

Hello,

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

Best regards

Sabrina