Hi, I would like to ask about processing unstructured data in the snowflake transformaction. Currently I can work with eg. JSON files as input for Python / R tr. But is it possible to have that kind of input as well in Snwfl tr ?

1 reply

Liked by Leoš Gerlich

Where am I?

In Keboola you can ask and answer questions and share your experience with others!

Answered last year

Hi Tereza,

I am not aware that Snowflake is able to handle different files. However for example, if you are looking to query, for example, JSON (https://docs.snowflake.com/en/sql-reference/functions/parse_json.html177), the JSON will need to fit within a cell of an actual storage table. If you have a JSON file for example, create a CSV out of it and upload it to KBC's table storage. Then you can set it into your input mapping of your Snowflake transformation/workspace.

Hope that makes sense?

4 comments

Hey Guys, I am looking to encrypt all values of a specific column on input into KBC. Extracting thru generic. The ... Any other ideas on how to do that?

Hi, do you have any idea what is the right way to change a version of a package in R transformation? I want to reinstall ... stuff but nothing works for me. 😕

Hi, I would like to ask about processing unstructured data in the snowflake transformaction. Currently I can work with eg. JSON files as input for Python / R tr. But is it possible to have that kind of input as well in Snwfl tr ?

Where am I?

Related Questions

Share Question