Convert Base64 to HEX
I am working on a Snaplogic pipeline to copy data from Oracle to Snowflake. A few tables at source have BLOB column which needs to be copied. Snaplogic sees them as “Base64 encoded data” but Snowflak...
Forum Discussion
(minor correction: my name is Patrick, not Peter)
I’m afraid I’m completely unfamiliar with our Snowflake snaps, so I’ll ask one of our devs who’s familiar with Snowflake to respond.
Sorry for misstating your name, Patrick. I am using “SNOWFLAKE - BULK UPSERT” snap.
No worries. The doc for that snap suggests you can use the
File format optionproperty for this. I think you’d set it toBINARY_FORMAT=BASE64. You would need to ensure your binary content is Base64 encoded usingBase64.encode($CONTENT), etc.
