Search

Using FME and the Snowflake Database Format

Liz Sanderson
Liz Sanderson

FME Version

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

1 comment

Date Votes
  • Comment author
    aanwar96 aanwar96

    Hi, how about executing some SQL code on multiple tables from the same database(Snowflake) inside FME. How would you go about it? The code has multiple CTE's, 100+ variables and a final SELECT * FROM Final_CTE. It works perfect inside Snowflake but how would you go about it inside FME? I believe a tutorial for that should be made.

    0

Please sign in to leave a comment.