Snowflake Issues with Dataset Creation
We have deployed the proper snowflake drivers and have successfully connected to a hosted warehouse. Initially we had some sporadic failures connecting, but feel it might be related to the "Auto Close" or "Auto Shutdown" options in Snowflake. We increased the timeout value on the connection string and it seems to have addressed those issues.
However, we are now running into some odd behavior when attempting to create datasets. Sometimes the process hangs during the calls against snowflake to obtain the list of columns. We initially believed it was just for one specific table, but now it appears that is happening for a few / several.
We can see the queries being executed on the Snowflake side and see that they are completing successfully, but Aperture doesn't respond afterwards. The log file doesn't seem to shed any light on significant issues but can share if it helps to troubleshoot.
Wondering if anyone has any tips or recommendations regarding Snowflake external systems that might help to resolve.