Snowflake Data into Smartsheet?
Hey everyone,
Do you know if there is a way to connect Snowflake data into Smartsheet using the API? I have found many resources on getting Smartsheet data into Snowflake but nothing on the other way around. We are trying to either do something native within Smartsheet or use an open-source software such as Airbyte.
Best Answer
-
Yea it definitely wouldn't be cheap if you needed to update lots of rows.
Do you have any people on your team who are comfortable programming?
Since both Snowflake and Smartsheet have an API, you could write your own script and then host it for pretty cheap on something like DigitalOcean.
You could get the price down to $1-30 per month depending on how much data you needed to sync and how frequently.
If you have a Smartsheet addon like Smartsheet Bridge, then you could implement it there using the API call module, but this wouldn't be easy. It would probably be easier to write the code directly than to use Bridge, for this particular use case.
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
Answers
-
Hi @rbrice,
Zapier has a bi-directional integration between Smartsheet and Snowflake:
It will detect when new columns, rows, or tables are added into Snowflake, and then you can configure it to update specific sheets with that new data.
Zapier does this by checking the data every 5-15 minutes and seeing if new data exists in your Snowflake instance.
Hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
-
Hey @SSFeatures,
Due to the nature of what we are trying to do with this bi-directional integration Zapier could become very expensive very fast. Do you know of any other tools?
-
Yea it definitely wouldn't be cheap if you needed to update lots of rows.
Do you have any people on your team who are comfortable programming?
Since both Snowflake and Smartsheet have an API, you could write your own script and then host it for pretty cheap on something like DigitalOcean.
You could get the price down to $1-30 per month depending on how much data you needed to sync and how frequently.
If you have a Smartsheet addon like Smartsheet Bridge, then you could implement it there using the API call module, but this wouldn't be easy. It would probably be easier to write the code directly than to use Bridge, for this particular use case.
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.