Hi.
Not sure how many people are using Integration Services with Snowflake. I have setup the Connection and I’m able to run a query and get results from Snowflake, however the fields are returned in a random order and not as per the query.
I have also identified a field that doesn’t get returned in the results. This also occurs if I do Select * instead of selecting individual fields. The only thing I’ve noticed is that the column contains all NULL values, but thought the column should be returned and not excluded from the results.
Thanks
Craig…
Hi @craig.norton, could you please let us know the version of the activity pack you are using? Additionally, sharing the Studio version and the query would be very helpful.
Just to confirm my understanding, are you saying that the same query returns values for the column when executed directly in Snowflake?
Hi @Samrat_Dutta ,
I’m using the following IntegrationService packages along with Studio Enterprise v2023.10.5 and using the Native Search activity:
UiPath.IntegrationService.Activities (v1.9.0)
UiPath.Snowflake.IntegrationService.Activities (v5.0.1)
That is correct. When running the query directly in Snowflake it returns the column and all values were NULL. When it is run via Studio that column doesn’t appear in the results data set. I tweaked the underlying data yesterday and today’s extract now has the column appearing because one of the records has a value.
Its weird that the column isn’t appearing, and my other comment how the order of the results doesn’t match the order of the query is also weird.
This is the query that I ran:
“select nr.PORTFOLIO_CODE, nr.”“Portfolio Name”“, nr.”“Tax Non Res Country”“, nr.”“Tax Non Res Country Description”" , nr.““Primary Contact Person””, nr.SECURITY_CODE, nr.““Asset Class Category””, nr.““Registry Description””, nr.““Case Type”” from EDW_DM_WEALTHPLUS_PRD.PRD_RPT.““rpt_wealthplus_dm_non_residents_ad_hoc_change_of_residency_all_new_changed_rows”” nr"
And this is the order that came out in the results.
@craig.norton , we are looking into this and will get back with an answer very soon.
