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 ..