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 JSON, CSV, or Parquet 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 | 74 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 schedule syncs weekdays at 5am, 10am, 3pm and 8pm and Sundays at 8pm in your organization's timezone, each source within 30 minutes of those times. Rows merge by source key, source deletes become _deleted, and every row records _synced_at. See Syncing for the complete lifecycle.