how to connect data shuttle to snowflake directly or is it possible through API

Dineshb

how to connect data shuttle to snowflake directly or is it possible through API

Brian_Richardson

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.

Lindsay Whitbread

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