Setting the file. One moment.
Skill 103 · Querying PostHog Data
Subchapter 103.49
references/models-integrations.mdMarkdown3 KBView on GitHub
Third-party service connections configured per project. Each integration represents a connection to an external service like Slack, GitHub, Salesforce, or an ad platform.
| Column | Type | Nullable | Description |
|---|---|---|---|
id | integer | NOT NULL | Primary key (auto-generated) |
team_id | integer | NOT NULL | Team this integration belongs to |
kind | varchar(32) | NOT NULL | Integration type identifier (see below) |
integration_id | text | NULL | Identifier in the external system (e.g. Slack workspace ID, GitHub installation ID) |
config | jsonb | NOT NULL | Non-sensitive, kind-specific configuration |
errors | text | NOT NULL | Error message if the integration has issues, empty string otherwise |
created_at | timestamp with tz | NOT NULL | Creation timestamp |
created_by_id | integer | NULL | Creator user ID |
slack, salesforce, hubspot, google-pubsub, google-cloud-storage, google-ads, google-sheets, google-cloud-service-account, snapchat, linkedin-ads, reddit-ads, tiktok-ads, bing-ads, intercom, email, linear, github, gitlab, meta-ads, twilio, clickup, vercel, databricks, azure-blob, firebase, jira, pinterest-ads
team_id)sensitive_config (encrypted credentials, tokens) is deliberately not exposed in this tableconfig structure varies by integration kind and may include account names, workspace IDs, or other non-secret metadatateam_id, kind, integration_id) combination is unique