Unanswered

Snowflake connector - convert result set rows error

(2) Share

Report

Posted on by ajohnson44

Has anyone had this issue with the new Snowflake connector? I'm able to connect, I'm able to query my data and tie it back to Snowflake, but when I try to run the built-in step to convert the data ("Convert result set rows from array to objects), my flow just hangs. It has an Internal Server Error immediately and just sticks.

Categories:

Using connectors

All responses (3)

Answers (0)

Sort by

hamntim 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ajohnson44 - I am starting Power Automate work via the Snowflake connector and am having the exact same issues. Did you find any resolution to this problem?
djworsdell 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ajohnson44 - also have exactly the same problem on my end. Quite frustrating and doesn't seem to be limited by a specific SQL statement, but by anything I try. Has anyone else had experience with this?
Jeff_VS 18 on at

Like
a
(0)

Report
Copy link

Link copied!

I had the same issue but what I have noticed is that the "data" coming over from the "Submit SQL Sstatement for Execution" was bringing some columns with NULL values (more specifically TIMESTAMP_LTZ(9) type).

As soon as I have replaced these NULL values with valid dates in the table and retried same flow, the issue went away.

So my concern is, how would this connector handle NULL values returned going forward, would there be an enhancement or should we find a workaround to replace NULL values to something this action can process?