Explore with AI
ChatGPTClaudeGeminiPerplexity
All connectors/Data Pipeline
Meltano
§ Connector
Meltano

Connect Meltano 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 Meltano accounts? Analytics across multiple Meltano accounts →

§ What you get

Everything Meltano exposes, modeled and queryable.

Extracts operational metadata from the Meltano system database, including pipeline run history (runs/job), Singer state snapshots, plugin configuration (plugin_settings), OAuth credential records, users and RBAC mappings (user, role, role_permissions, roles_users), subscriptions, embed tokens, and database migration version. This enables analysis of pipeline reliability and performance (run outcomes, durations, failure trends), configuration auditing and drift, access control and user activity oversight, and environment/state lineage across orchestrations.

Sync cadence
Hourly or faster
CDC
Native where supported
Auth
OAuth / API key
Row-level security
Yes

Tables & streams

8 objects
Pipeline Run

Represents individual Meltano pipeline executions, including status, timings, and associated job; enables analysis of reliability and performance such as success rates, runtimes, failure trends, and SLA attainment.

Job

Defines scheduled or ad-hoc orchestration units that group runs; supports analysis of job health, schedule adherence, run frequency, and per-job failure hotspots.

State Snapshot

Captures Singer state checkpoints per stream and environment; used to measure data freshness, last successful sync positions, lag, and lineage across orchestrations.

Plugin Configuration

Stores configuration for extractors, loaders, and transformers; enables configuration auditing, drift detection across environments, and impact analysis of config changes on run outcomes.

Access Control

Models users, roles, and permission mappings; supports governance metrics like privileged access counts, segregation-of-duties checks, and audits of role changes over time.

Credential

Holds OAuth credentials for connectors; enables security posture monitoring such as credential age, expiry risk, and correlation between credential issues and pipeline failures.

Subscription

Represents notification and alert subscriptions; supports analysis of alert coverage and alignment of alerts with critical jobs and owners.

Embed Token

Contains tokens used for embedded analytics access; enables oversight of embed footprint, token expiry risk, and mapping tokens to consumers or applications.

Authentication

Connects using a database connection string (SQLAlchemy URI); for the default local SQLite database, no login is required

Requirements

Requires a Meltano account to connect.

Analyze with Fi

Operational data, performance metrics, and business insights.

§ How it works

Three steps. One afternoon.

01
Connect

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

definite connect meltano
02
Sync

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

→ meltano.raw (synced hourly)
03
Query

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

SELECT * FROM meltano.*
*
Don't see yours?
Any API becomes a Definite connector in minutes.

Build your own with the Definite SDK, or ask us — we add new connectors every week.

Request a connector

Your answer engine
is one afternoon away.

Book a 30-minute call. We'll build your first dashboard on the call — or you can stop paying us.