Connectors#
Choose a source by the data you need and the credential your source can issue. Every syncing connector below is available in Apps → Connect app. Staff-only and non-syncing entries are deliberately absent.
Connector catalog#
| Source | Authentication | Lake schema | Tables |
|---|---|---|---|
| Airtable | a personal access token and a base id | airtable_<base_name> | Tables discovered from the selected base |
| Amplitude | an API key, secret, and backfill start date | amplitude | 1 fixed table |
| Apple App Store | issuer id, key id, private key, and vendor number | apple_app_store | 1 fixed table |
| Canny | an API key | canny | 8 fixed tables |
| Facebook Ads | a system-user token and ad account | facebook_ads | 42 fixed tables |
| Gainsight | a tenant URL and access key | gainsight | Readable objects discovered from your tenant |
| GCS bucket | a bucket path plus the target schema and file options | {schema_name} | Tables discovered from CSV files |
| Google Ads | Google OAuth plus a customer id and optional manager id | google_ads | 42 fixed tables |
| Google Analytics | Google OAuth and at least one property | google_analytics | 67 fixed tables |
| Google Sheets | Google OAuth and one or more selected spreadsheets | google_sheets | One discovered table per visible sheet tab |
| Help Scout | OAuth using your Help Scout app credentials | helpscout | 6 fixed tables |
| HubSpot | HubSpot OAuth | hubspot | 10 base objects plus custom objects, histories, and associations |
| Intercom | an access token | intercom | 6 base tables plus discovered data attributes |
| Jira | an email address, tenant domain, and API token | jira | 23 core tables plus discovered custom fields |
| Klaviyo | a private API key | klaviyo | 9 fixed tables |
| Microsoft Ads | OAuth, your app credentials, a developer token, and an account id | microsoft_ads | 6 fixed tables |
| Mixpanel | service-account credentials and a project id | mixpanel | 4 fixed tables |
| MySQL | a connection string, optionally through an SSH tunnel | mysql_<database_name> | Tables and columns discovered from the selected database |
| NetSuite | SuiteAnalytics Connect ODBC credentials and token-based authentication details | netsuite | Tables discovered through SuiteAnalytics Connect |
| Pardot | Salesforce OAuth, your app credentials, and a business unit id | pardot | 35 source objects discovered for the business unit |
| Pendo | an integration key | pendo | 13 fixed tables |
| PostgreSQL | a connection string, optionally through an SSH tunnel | {source_schema} | Tables and columns discovered from PostgreSQL |
| Postmark | server and account API tokens | postmark | 5 fixed tables |
| Reddit Ads | OAuth using your app credentials plus an advertiser id | reddit_ads | 6 fixed tables |
| Salesforce | Salesforce OAuth | salesforce | Every queryable object discovered from your organization |
| SendGrid | an API key | sendgrid | 6 fixed tables |
| Shopify | a shop domain and Admin API token | shopify | 19 fixed tables |
| Snapchat Ads | OAuth using your app credentials plus an ad account id | snapchat_ads | 5 fixed tables |
| Stripe | a restricted key with read access to the selected resources | stripe | 17 fixed tables |
| Zendesk | a subdomain, email address, and API token | zendesk | 43 core and child tables plus discovered custom fields |
What every source shares#
A source syncs immediately after setup and then follows its schedule. The default interval is 4 hours. Rows merge by source key, source deletes become _deleted, and every row records _synced_at. See Syncing for the complete lifecycle.