SFTP + Bruin

Source

Ingest SFTP data into your warehouse with incremental loading, quality checks, and full lineage. Defined in YAML, version-controlled in Git.

For business teams

What you get

Files and events in your warehouse
SFTP data lands in your warehouse with automatic schema detection. No manual parsing, no format guessing.
Schema drift protection
Quality checks catch unexpected format changes, null values, and schema drift from SFTP before it breaks models.
Data lake orchestration
Use SFTP as a staging layer. Bruin handles landing, transforming, and materializing — all in one pipeline.
Multi-cloud flexibility
Move data between SFTP and other storage or warehouses. Bruin manages scheduling, retries, and lineage.

For data & engineering teams

How it works

Automatic schema detection
Bruin detects SFTP data schemas automatically. No manual configuration when formats change.
YAML-defined, Git-versioned
Your SFTP pipeline is a YAML file. Review in PRs, deploy with CI/CD, roll back with git revert.
Format validation
Quality checks catch schema drift, unexpected nulls, and format changes from SFTP at the ingestion layer.
Land, transform, materialize
Use SFTP as staging. Bruin handles the full flow: land raw data, transform, and materialize into your warehouse.

Before you start

SFTP server access

SSH credentials or private key

Step 1

Add your SFTP connection

Connect using SFTP credentials with optional private key authentication. Add this to your Bruin environment file — credentials are stored securely and referenced by name in your pipeline YAML.

Parameters

userSFTP username
passwordSFTP password (if not using key-based auth)
hostSFTP server hostname
portSFTP port (default: 22)
private_key_pathPath to SSH private key file

connections:
  sftp:
    type: sftp
    uri: "sftp://user:password@host:port?private_key_path=<private_key_path>"

Step 2

Create your pipeline

Define a YAML asset that tells Bruin what to pull from SFTP and where to land it. This file lives in your Git repo — reviewable, version-controlled, and deployable with CI/CD.

name: raw.sftp_data
type: ingestr

parameters:
  source_connection: sftp
  source_table: 'data'
  destination: bigquery

Step 3

Add quality checks

Add column-level and custom SQL checks to your SFTP data. If a check fails, the pipeline stops — bad data never reaches downstream models or dashboards.

Catch events with future timestamps

Validate file paths and timestamps are present

Flag schema drift at the ingestion layer

columns:
  - name: file_path
    checks:
      - name: not_null
  - name: event_timestamp
    checks:
      - name: not_null

custom_checks:
  - name: no events from the future
    query: |
      SELECT COUNT(*) = 0
      FROM raw.sftp_data
      WHERE event_timestamp > CURRENT_TIMESTAMP()

Step 4

Run it

One command. Bruin connects to SFTP, pulls data incrementally, runs your quality checks, and lands clean data in your warehouse. If a check fails, the pipeline stops — bad data never reaches downstream.

Backfill historical data with --start-date

Schedule with cron or trigger from CI/CD

Full lineage from SFTP to your dashboards

$ bruin run .

Running pipeline...

  sftp_data
    ✓ Fetched 2,847 new records
    ✓ Quality: campaign_id not_null     PASSED
    ✓ Quality: spend not_null           PASSED
    ✓ Quality: no negative ad spend     PASSED
    ✓ Loaded into bigquery

  Completed in 12s

Other Storage & Streaming integrations

Amazon Kinesis

Amazon S3

Apache Kafka

CSV Files

Dropbox

Google Cloud Storage

Ready to connect SFTP?

Start for free, or book a demo to see how Bruin handles ingestion, quality, lineage, and scheduling for your entire data stack.

Book a demo Read the docs