SNOW-832857: Promise based APIs

[bforbis]

Pretty much all of the APIs for the snowflake SDK are callback based, which doesn't play well with a lot of modern NodeJS applications which are moving towards promise based APIs and async/await.

A promise based API can be added in with a non breaking change by checking for the existence of a passed in callback.

[howryu]

Like @smtakeda said, we don't have plan for that yet. However, I do see some other people build a wrapper on top of Snowflake node js driver using promise based apis. However, please be aware that it is not supported by Snowflake currently. Use at your own risk.

https://www.npmjs.com/package/snowflake-promise

[bforbis]

I did see that library, but decided against using it because I don't know how much testing it has had. I would rather see promise APIs in the official SDK here. If you add the source to this github repo, I am sure that users would be happy to make contributions.

[smtakeda]

The code is published.

[natesilva]

@smtakeda Are you saying the SDK now supports Promises?

[smtakeda]

@natesilva no it is not. I meant NodeJS code is on github.

I'm holding off the change for Promise until either I get familiar with NodeJS, we hire an NodeJS dev or somebody steps in the change.

[natesilva]

Oh I see. So now you can take pull requests. That’s good to know, and thanks for the update.

[dylburger]

I thought some of y'all might benefit from some code I wrote to wrap the connection.connect and connection.execute methods with Promises: https://pipedream.com/@dylburger/promise-based-api-wrapper-for-snowflake-node-sdk-p_XNMCRn .

Not a solution for the full library but I happened to only need these two methods in my own code and this worked well for that narrow use case.

[rombat]

@dylburger you're a lifesaver
Seriously, it's really a shame that in 2023, a still updated sdk is still using callbacks

[iamabs2001]

any solution ?

[sfc-gh-anugupta]

Hi All, we plan to add the support for promise based on the NodeJS SDK, and it's in our backlog. I dont have any ETA yet, but we will prioritize it as we do the next quarter planning. We will keep this thread updated. Thanks all for the patience.

[gpierrick]

Any updates on this? The fact that this was announced in Jul 2023 and we're in Feb 2024 now.

[sfc-gh-dszmolka]

I'm afraid there isn't any more concrete timeline for the implementation which can be shared for now but I'm syncing internally with the team and will update this thread once anything interesting becomes available. We know this is the oldest open requirement and required by many, and I can confirm it is on the table for the dev team - what I cannot confirm at this moment is the timeline for implementation.

At the same time I would like to encourage everyone who is waiting for this improvement to be implemented and is already a Snowflake customer: please reach out to your account team and word to them how important this feature would be for you. That could help reprioritize a particular feature's implementation.

Thank you for bearing with us !