True ETL Tools
If you need more than just to copy data from SmartSuite to Snowflake, you may use Skyvia's powerful ETL functionality for SmartSuite and Snowflake integration. Skyvia's Import tool will correctly extract SmartSuite data, transform it, and load to Snowflake when Snowflake tables have different structure than SmartSuite objects. Besides, if you ever need to load data back from Snowflake to SmartSuite, Skyvia Import allows loading data in any direction, supporting Reverse ETL scenario.
For more complex cases, you can use Data Flow and Control Flow tools. They are designer-based solutions for creating complex data pipelines, involving not only SmartSuite and Snowflake connectors, but any number of connectors in one integration. With these tools you can automate data workflows, involving custom logic, complex multistage transformations, combine data from different sources, load them into multiple destinations at once and many more.