Query to Snowflake and Processing Data

Question

Hello,I have an easy question for the greater minds on here. I've created a simple https query to test snowflake environment. I'm trying to process the data I receive by iterating through it and I'm having some difficulty with that step.  In detail - 1. The returned results look like this - 2. the data is captured into a module that looks like this 3. Sample of data when passing through this get Data.data module4. This is converted into an Array    5. Then iterated ...  Question - If I only wanted to read the email column in the next module, how do I do that?

D____D · Accepted Answer

Hey - if you're game - can you do this:

Turn off parsing in the HTTP module
send me the module output

I'm not enough of a dev to make my 30days with snowflake useful 😕😕

So it turns out that it was the approach, after all, and the iterator module. I don't think the Adobe rep can actually say that 😄 but the solution presented does not even use an iterator but instead focuses on creating a repeater using the HTTP DATA module output only - not that far from what you suggested but with a slightly different approach.

- get the data

- use the number of rows value from data to set a repeater

- compose a string to use in another string - depth

- compose a string within a get ( ) data function, like what you had suggested to get the value

repeater config

first compose string

final compose string (ignore the double quotes and "+" symbols)

actual configuration looks like this:

results

Sven-iX · Answer

You can doIterator on Data.datathen grab the 4th array element: get( {the value from the iterator} ; 4 )

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded