posthog icon indicating copy to clipboard operation
posthog copied to clipboard

Published 20 hours ago • verified publisher icon PostHog

Snowflake Export - TypeError preventing export

Open huckleberryCalfinn opened this issue 2 years ago • 2 comments

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.
image image

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!

huckleberryCalfinn avatar Jan 10 '23 18:01 huckleberryCalfinn

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

macobo avatar Jan 11 '23 11:01 macobo

thank you very much - your help is greatly appreciated!

huckleberryCalfinn avatar Jan 11 '23 20:01 huckleberryCalfinn

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

huckleberryCalfinn avatar Jan 21 '23 16:01 huckleberryCalfinn

Hello @huckleberryCalfinn, this issue is caused by https://github.com/snowflakedb/snowflake-connector-nodejs/issues/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.

xvello avatar Jan 24 '23 10:01 xvello

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.

yevgenypats avatar Jan 26 '23 07:01 yevgenypats

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!

xvello avatar Jan 27 '23 10:01 xvello

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

huckleberryCalfinn avatar Feb 01 '23 14:02 huckleberryCalfinn