Connectors
A connection is a named, saved set of settings for one system. Credentials are stored encrypted and never enter a pipeline: a node names the connection, nothing more.
How connections work
- Staging and Production. Every connection has a Staging side, which it needs, and an optional Production side. A run in Production uses the Production side, so a pipeline moves between environments without editing a node.
- Who may use it. A connection has an access list. Using it in a pipeline needs a place on the list, and reaching its Production side needs the list's Production permission too.
- Test. The Test button signs in with the side you are looking at and says what the system answered. Each connector's page says what a pass proves.
Database
Read and write MongoDB collections, including Amazon DocumentDB. Enter a single host: seedlist (mongodb+srv)…
Read and write MySQL or MariaDB: self-hosted, or managed on Amazon RDS and Aurora, Cloud SQL, or Azure Database.…
Read and write any PostgreSQL server: self-hosted, or managed on Amazon RDS and Aurora, Cloud SQL, or Azure Database.…
Read and write Microsoft SQL Server: self-hosted, or managed on Amazon RDS or Azure SQL. Browse to a table or write…
Warehouse
Query data in S3 with Amazon Athena: the tables your data catalog already tracks, with no cluster to run.
Read and write Amazon Redshift: provisioned clusters and Serverless workgroups both speak the PostgreSQL wire…
Read and write Google BigQuery over its REST API. There is no driver to install, and the builder shows a query's…
Read and write ClickHouse over its HTTP interface: columnar all the way, with no driver to install.
Read and write Databricks SQL through a SQL warehouse. Results stream back columnar, with no driver to install. Press…
Read and write Snowflake over its SQL API. There is no driver to install, and picking a table shows its columns in the…
Connect to a Trino or Starburst cluster. The builder shows a query's columns without running it.
Lakehouse
Cloud Storage
Read/write objects in an S3 bucket.
Read and write blobs in Azure Storage, including Azure Government, Azure China and Azure Stack. Signs in…
Read and write objects in a Google Cloud Storage bucket, signing in with a service account key or the…
Read and write files on a Windows network share or a NAS over SMB 2 and 3, signing in with a user name and password…
Read and write files on an SFTP server, with the same folder globbing, Bookmark and per-file fan-out the cloud file…
SaaS & APIs
Read and write Google Sheets. One credential works across many spreadsheets: each node picks the spreadsheet, tab, and…
Read HubSpot CRM objects.
Read Jira issues with JQL.
Call any HTTP/JSON API: read it as a source, enrich rows against it, or push rows to it. Pagination, retries and auth…
Read Salesforce objects with SOQL, and write records back.
Send rows to people: the relay the Send Email node delivers through. Separate from the instance alert relay in…
Read Zendesk Support resources.