Hi there,
I’ve been using the Snowflake Integration connector activities pretty extensively, but I just noticed that my workflow is claiming no results were returned from a Snowflake query and when I’m looking at the Get Query Execution Results activity the output field seems to have disappeared completely from the activity? I have no idea what the cause might be because I still have the variable QueryResults that was supposed to be assigned the output of the activity and haven’t changed anything else.
@ashokkarale ,
I think you are misunderstanding the issue at hand here, the first thing I checked was the ‘Manage Properties’ button, but the output from the activity has completely disappeared. Attached is a screenshot of the properties that show up when clicking ‘Manage Properties’
The output is a fundamental part of the activity and wouldn’t be an additional field anyways, I just don’t understand how the entire output field can disappear. If I create a new project and put the same ‘Get Query Execution Results’ activity, the Query results output is clear as day in the properties panel there, see below.
It seems for some reason I had to get a new query ID, regenerate the output schema and refresh the results variable before changing the query ID back to a variable to get the query results output field back. Not sure why this was needed.
