S3 Data Lake and SFTP integrations and automations

Seamlessly connect S3 Data Lake and SFTP. Automate workflows, and boost efficiency with Workato.

Rating

4.9

Pre-built

150+

integrations

Total

100+

active users

avg

2 min

to connect

Custom Connections

Available

via HTTP connector

Market leaders run on Workato

  • monday.svg
  • box.svg
  • hp-2.svg
  • atlassian.svg
  • cisco.png

Build Powerful Workflows, fast

Triggers

When this happens…

SFTP
  • New/updated CSV file in directory Batch
    New/updated CSV file in directory on SFTP server
  • New/updated file in directory
    New/updated file in directory on SFTP server

    • Any other trigger you can think up

Actions

Do this…

S3 Data Lake
  • Create table
    Create an Iceberg table through AWS Glue data catalog in S3 Data Lake
  • Custom action
    Custom action in S3 Data Lake
  • Get table definitions
    Get table definitions by table name in S3 Data Lake
  • Import data
    Import data into an Iceberg table in S3 Data Lake
  • List tables
    Lists all tables from a database in S3 Data Lake
  • Query data
    Query data from a table in S3 Data Lake

    • Any other action you can think up

SFTP
  • List folder Batch
    List folder in SFTP server
  • Create folder
    Create folder in SFTP server
  • Delete file
    Delete file in SFTP server
  • Delete folder
    Delete folder in SFTP server
  • Rename/move file
    Rename/move file in SFTP server
  • Search files/folders Batch
    Search files or folders in SFTP server
  • Change permission of a file or a folder
    Change permission of a file or a folder in SFTP Server
  • Get file information
    Get file information from SFTP server
  • Download file
    Download file from SFTP server
  • Upload file
    Upload file to SFTP server

    • Any other action you can think up

One platform

  • Power
  • Agility
  • Speed
  • Innovation