Connect SFTP to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Have multiple SFTP accounts? Analytics across multiple SFTP accounts →
Everything SFTP exposes, modeled and queryable.
Extracts structured records from files on an SFTP server. You define one or more 'tables' by directory prefixes and filename regex patterns, and the integration streams rows from matching delimited files (e.g., CSV/TSV), adding source file and line metadata. It supports incremental sync using file modification time, custom delimiters/encodings, optional header sanitization and row skipping, and can decrypt GPG-encrypted exports and handle compressed files. This enables centralizing operational exports and file-delivered datasets for downstream analytics.
Tables & streams
A logical dataset defined by an SFTP directory prefix and filename regex, representing a table to be loaded (e.g., orders, customers, events). Enables analysis of dataset freshness, volume trends, schema conformance, and downstream KPI modeling.
Authenticates to your SFTP server with a username and password or an SSH private key; optionally retrieves a GPG decryption key from AWS SSM Parameter Store to decrypt files
Requires a SFTP account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate SFTP in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your SFTP data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
