SFTP

SFTP

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

Learn more
PostHog Wizard hedgehog

Connect SFTP to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Import CSV and JSON files from an SFTP server. PostHog lists the files in the folder you point it at, including subfolders, and creates one table per file, or one combined table if you prefer. Every sync reads the files in full, so each table matches what's on the server right now.

Configuration

OptionDescription
Host
Type: text
Required: True
Port
Type: number
Required: True
Username
Type: text
Required: True
Authentication type
Type: select
Required: True
Folder
Type: text
Required: True
File pattern (optional)
Type: text
Required: False

A regular expression matched against each file's path inside the folder. Leave it empty to import every file.

File format
Type: select
Required: True
CSV delimiter (optional)
Type: text
Required: False

Use \t for tab-separated files. Defaults to a comma.

Combine every file into one table?
Type: switch-group
Required: False

Turn this on when the folder holds files that share the same columns, such as a daily export. All matching files land in one table instead of one table per file.

Linking SFTP to PostHog

  1. Go to the Data pipeline page in PostHog
  2. Click New source and select SFTP
  3. Fill in the required configuration fields
  4. Click Next, select the tables you want to sync, and then press Import