Composing data pipelines in an AI-native workflow

Fivetran describes its CLI as a terminal-native interface that lets engineers and AI coding harnesses (Claude Code, Codex, Gemini CLI, dbt Wizard) create connections, configure schemas, trigger syncs, and build custom connectors, with MCP servers supplying context from task trackers and observability stacks. The post walks through a session that lands Stripe data in Snowflake and ships an fct_mrr dbt model, then covers iterating on changed requirements and failed syncs, and offers guidance on scoped API keys, confirmation prompts, and prompt injection.