Snowflake Export - TypeError preventing export

[huckleberryCalfinn]

Bug description

Please describe.
Hi. We have noticed that, as of 12/15/2022, our Snowflake connector app seems to be malfunctioning. We are seeing a TypeError that seems to be preventing the connector from updating our Snowflake database. Please note the screenshots for additional context, and thank you very much for your help.

If this affects the front-end, screenshots would be of great help.

How to reproduce

1. Go to Browse Apps
2. Snowflake Export
3. observe errors in attempted exports (shown in screenshot)

Environment

• PostHog Cloud
• [x ] self-hosted PostHog, version/commit: "posthog-js": "^1.22.18",

Thank you very much!

Thank you for your bug report – we love squashing them!

[macobo]

cc @fuziontech who has been looking at the snowflake app recently.

[huckleberryCalfinn]

thank you very much - your help is greatly appreciated!

[huckleberryCalfinn]

hi @macobo @fuziontech - just wanted to check in and see if there might be any progress here. thank you again!

[xvello]

Hello @huckleberryCalfinn, this issue is caused by snowflakedb/snowflake-connector-nodejs#349, and we didn't manage to work around it. We are closely monitoring the state of the upstream issue and will release an updated app as soon as the fix is released.

[yevgenypats]

Hey folks! Sorry for the drop-in here. I opened this issue and I think it can help solve this issue as well and reduce burden on maintaining a Snowflake connector while only focusing on PostHog APIs and also enabling users to sync PostHog data to any other DBs (BigQuery, S3, Athena) without any additional code. I'd love to help with an initial CloudQuery/PostHog source plugin if this is something interesting.

[xvello]

Hello @huckleberryCalfinn, I pushed a commit to the snowflake app that uses the workaround they documented, while we wait for a release with the fix.
Feel free to update your app and report here if the issue persists!

[huckleberryCalfinn]

@xvello thank you team! The snowflake app seems to be working again - thank you again for all you help!