Connectors¶
Choose a connector by starting with the system that owns the records and the business action you need next: read, reshape, update, or deliver a file. You do not need to provision any of these systems to explore the documentation.
All connectors below support pipeline source and sink roles. Actual access depends on the configured connection, provider permissions, and operation. Support for a system does not imply support for every feature of that system.
| Connector | Typical use |
|---|---|
| PostgreSQL | SQL reads, inserts, updates, and upserts |
| MySQL | SQL reads and database-native writes |
| BigQuery | Warehouse query jobs and row appends |
| Snowflake | Parameterized warehouse reads and INSERT sinks |
| MongoDB | Document queries and writes |
| HTTP | Explicit API requests and response payloads |
| HubSpot | CRM search/list and unique-key upserts |
| FTP | Plain FTP file reads and writes |
| Git | Manually authenticated repository files |
| GitHub | Repository files through a GitHub App installation |
| GitLab | Repository files through OAuth or a project token |
| S3 | Structured objects and raw file transfers |
Each guide includes connection settings, authentication and permissions, connection testing, metadata discovery, read/write examples, operation fields, pipeline behavior, and troubleshooting. The examples use synthetic data and state which provider resources must already exist.
Understand the capabilities¶
Connection testing checks access to the configured system. Schema refresh retrieves metadata, such as columns, CRM properties, file fields, or API operations. The type and completeness of that metadata depend on the connector. A successful connection test does not prove that every query or write will work.
An operation is the specific query, request, or file action a step performs. Its payload must match the next step. SQL transforms require row-normalized inputs; arbitrary JSON transformations and implicit file conversions are not available.
Some sources support incremental checkpoints: SQL databases, BigQuery, Snowflake, and MongoDB use watermarks; HTTP and HubSpot use cursors. The operation must apply the corresponding filter or cursor. FTP, Git, and S3 use full reads for now. Checkpoints are not change-data-capture or automatic synchronization.
Start with Connect a system when you are ready to configure a connection in your workspace.