how to connect data shuttle to snowflake directly or is it possible through API
how to connect data shuttle to snowflake directly or is it possible through API
Answers
-
I don't know what Snowflake is, but no Data Shuttle only works with OneDrive, Sharepoint, Google Drive, Box, and attachments to Smartsheet sheets. That's not something you can change.
You can use the Bridge tool to connect with Snowflake's API, providing they have a HTTP REST API that's publically accessible and uses tokens or basic auth (no Oauth). For Oauth you need Smartsheet technical engineers to build a custom module for you, which costs.
If you don't have Bridge, you can use any other integration tool that can leverage Smartsheet API and Snowflake API to move data around.
Finally, if Snowflake can use the ODBC connector, Smartsheet provides that. Google for instructions.
-
Your best bet to get Smartsheet and Snowflake connected would be through the API. Smartsheet have a Platinum partner, InfoSpark (who I work with) that has a connector for Snowflake so reach out to InfoSpark through the website and have a chat with the team to get sorted out with the connector.
By the way - the Snowflake connector can push data from Smartsheet to Snowflake, as well as moving data in the opposite direction if you need - so you're going to be sorted no matter what you need to do!Cheers,
Lindsay
Smartsheet Lead @ InfoSpark
Asia Pacific Smartsheet Partner of the Year (2023)
Platinum Smartsheet Partner | www.infospark.com.au
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives