Smartsheet data to Snowflake

samsolo256

We have a need to import Smartsheet data into Snowflake. Does Smartsheet have a way to save to an S3 bucket so we can download from there (using Glue maybe?), or is there a preferred method for doing that?

Thanks

Andrée Starå

Hi @samsolo256

I hope you're well and safe!

• Have you explored using the premium app, Data Shuttle?
• There also are multiple 3rd party integrations that maybe could work. Is that an option?

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

samsolo256

Thank you @Andrée Starå . I didn't know about Data Shuttle. Unfortunately it looks like it only supports One Drive and Google Docs (https://help.smartsheet.com/learning-track/integrations-and-add-ons/data-shuttle). We need something that works with AWS. Any chance Smartsheets will be able to work with S3 buckets in the near future?

Thanks

ryancoxe

Any feedback on this? AWS integration would help a lot

David Gatto

There is a Smartsheet connector for Amazon AppFlow  https://docs.aws.amazon.com/appflow/latest/userguide/connectors-smartsheet.html that can store your Smartsheet data to Snowflake, S3, Redshift, and other destinations.

Dineshb

We have a need to import Smartsheet data into Snowflake

Can someone from the community can let me know the process of connecting data shulttle with snowflake ..

jbuford04

I'd love a connector that would directly integrate to a table in Snowflake, but for our purposes I built with python some connectivity between the two that basically extracts a sheet, stores it as a dataframe, does a compare with the existing table in Snowflake (assuming a table already exists for the specific process I've got, but for others, you may want to add a step to create if not exists or some other comparative method), then adds new data or appends changes to the table

Lindsay Whitbread

Hi,

I work for InfoSpark, a Platinum level Smartsheet partner that specialises in creating connectors and add-ons for Smartsheet. We've created a direct connector to sync Smartsheet to Snowflake using the APIs (no offloading of data necessary). Because our software team developed the connector, it makes it easy to accommodate any special requests that customers have, including storing attachments and maintaining both "live" syncs as well as archive copies.

The main reason customers use us instead of other third party solutions is that we take care of all of the setup. No need to learn a new tool or waste time getting it working the way you need.

If that's of any interest, please reach out to the team over email at solutions@infospark.com.au.

Cheers,

Lindsay