ManojkMohan
Honored Contributor II

Inbound Flow Design
Enable SFTP on the ADLS Gen2 (or Azure Blob Storage) account;

Generate and register an SSH public/private key pair with Airship, enter your SFTP endpoint credentials (username, host, port, key) in Airship’s settings to authenticate uploads.

Configure Airship to push files (CSV or other supported formats) to the specific SFTP directory in your ADLS Gen2 account, designated for inbound data.

Trigger Azure Data Factory (ADF) or Databricks jobs using storage events (e.g., SFTP commit events, which ensure files are fully uploaded before processing) to ingest these files, transforming them into Delta tables

View solution in original post