Using FME and the Snowflake Database Format

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2020.0

Introduction

The purpose of this article is to give users a high-level introduction to using FME with the Snowflake Database. 

 

Requirements

FME Desktop 2020.0 or above and an account at YourCompany.snowflakecomputing.com. See the Snowflake Doc here for more examples.
 

Video





 

Advanced Tips

Did you know you can use the SQLCreator and SQLExecuter to interact with your Snowflake database? This allows you to upload CSV files (PUT) and then load (COPY) that data to an existing database table. (article coming soon)

You can also use the SQL transformers to run the MERGE command against any new refresh data and the existing data to do all the necessary insert, updates, and deletes. (article coming soon)

You can use FME to send data files to Amazon S3 buckets and then make use of SQLExecutor to pull that data from the external stage into your Snowflake Database.

 

Articles

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.