Amazon S3 + Snowflake

Execute sqls in Snowflake for new or updated files in Amazon S3

This workflow allows you to manage your Amazon S3 files more efficiently by interacting with Snowflake. When a file in Amazon S3 is updated or newly created, it instantly triggers the execution of an SQL command in Snowflake. This lightens your load of manual work and enhances data analysis, offering a streamlined way to control and respond to changes in your Amazon S3 content.

This workflow allows you to manage your Amazon S3 files more efficiently by interacting with Snowflake. When a file in Amazon S3 is updated or newly created, it instantly triggers the execution of an SQL command in Snowflake. This lightens your load of manual work and enhances data analysis, offering a streamlined way to control and respond to changes in your Amazon S3 content.

  1. When this happens...
    Amazon S3Amazon S3
    New or Updated File

    Triggers when you add or update a file in a specific bucket. The bucket must contain less than 10,000 total files.

    TriggerPolling
  2. automatically do this!
    SnowflakeSnowflake
    Execute SQL

    Execute SQL and output resulting rows of data.

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • BucketRequired

    • Folder

    Trigger
    Polling
    Try It
    • Bucket Name

    • KeyRequired

    • Keep Leading Slash

    • FileRequired

    • Mimetype

    Action
    Write
    • S3 UrlRequired

    Action
    Search
    • SQL StatementRequired

    • Primary Key

    Trigger
    Polling
    Try It
amazon-s3 logo
amazon-s3 logo

About Amazon S3

Amazon Simple Storage Service is a fully redundant data storage system. It makes it easy to store and retrieve any amount of data, anytime, from anywhere.
Learn more

Related categories

  • Amazon
  • File Management & Storage

Similar apps

Dropbox integrationsDropbox integrations

Dropbox

File Management & Storage
Google Drive integrationsGoogle Drive integrations

Google Drive

File Management & Storage, Google
Box integrationsBox integrations

Box

File Management & Storage
snowflake logo
snowflake logo

About Snowflake

Snowflake allows corporate users to store and analyze data using cloud-based hardware and software.
Learn more

Related categories

  • Databases