Do I need a separate data warehouse for my SFTP data?

No. Definite includes a built-in lakehouse, so you don't need to pay for a separate warehouse like Snowflake, BigQuery, or Redshift. Your SFTP data syncs into open Parquet storage and is queried by a DuckDB-powered engine for high-performance analytics. Definite handles encrypted, persistent storage behind the scenes with enterprise-grade security, automatic syncing, and backups. You get lightning-fast queries, built-in business intelligence tools, and SOC 2 compliant security, all without the overhead or complexity of running a separate warehouse.

Can I analyze my SFTP data with other data sources?

Yes. Definite lets you connect and analyze data across all your tools: app databases, CRMs, marketing automation, analytics, and customer support platforms. Our built-in Sync Engine supports 500+ data sources, with options for daily, hourly, or near real-time syncs. You can select metrics and dimensions from your SFTP data alongside other sources to explore insights, build dashboards, and share results (no SQL needed, unless you want to). Or simply ask Fi, our AI analyst, to find answers, uncover patterns, and instantly create charts and reports for you.

Can Definite connect SFTP data to tools like Python, SQL, Google Sheets, or Slack?

Yes. Definite integrates seamlessly with the tools you already use. You can run Python scripts for advanced analysis, query your data directly with SQL, or sync results to Google Sheets and Slack for easy sharing. Data can be exported in CSV, Excel, or JSON, accessed via the Metrics API, or embedded directly into your product or internal dashboards. Definite makes it simple to connect, automate, and share insights wherever your team works.

How does Definite's AI actually work?

Definite includes Fi, our AI data analyst that understands your business data and speaks your language. Fi can explore your connected sources, write SQL, and build charts or dashboards in minutes, turning plain-English questions into real analysis. Under the hood, Fi uses Definite's semantic models and query engine to interpret context, generate accurate queries, and explain results clearly. The result: faster insights, fewer bottlenecks, and analytics that finally deliver ROI.

Can I use Definite for free?

Yes. Definite offers a free plan for qualifying startups that includes core analytics, dashboards, and AI insights: everything you need to get started. You can upgrade anytime for more data sources, faster syncs, and advanced automations.

Definite runs as a private deployment in your own cloud (AWS, GCP, Azure, or anywhere with Kubernetes); you keep control of data, compute, and networking. Request a demo →

Explore with AI

← All connectors/Data Integration

§ Connector

SFTP

Analyze your SFTP data with AI today.

Build dashboards, automate reports, and ask questions in plain English — all from your SFTP data, no complex infrastructure to maintain.

See SFTP in Definite →Try it free

Have multiple SFTP accounts? Analytics across multiple SFTP accounts →

Want it to watch your SFTP data and act on its own? Meet the SFTP agent →

§ Live with

§ What you get

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.

Standard on every Definite connector

Sync cadence

Hourly or faster

CDC

Native where supported

Auth

OAuth / API key

Row-level security

Yes

Tables & streams

1 object

◆Stream (Dataset/Table)

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.

general_data_storage

Authentication

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

Requirements

Requires a SFTP account to connect.

§ How it works

Three steps. One afternoon.

Connect

Authenticate SFTP in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.

definite connect sftp

Sync

We pull every stream into your warehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.

→ sftp.raw (synced hourly)

Query

SQL, dashboards, or ask Fi in plain English. Your SFTP data lives next to every other source — ready to join.

SELECT * FROM sftp.*

See SFTP data flowing in 30 minutes

We'll set up a live sync and answer your first questions — on the call.

Book a demo →

Don't see yours?

Any API becomes a Definite connector.

Build your own with the Definite SDK, or request it. Most go live in days.

Request a connector →