Linking Render as a source
This source is currently in alpha. The interface and available tables may change.
The Render connector syncs your services, deploys, one-off jobs, service events, and managed databases into the PostHog Data warehouse, so you can analyze deploy frequency, job outcomes, and infrastructure changes alongside your product data.
Prerequisites
You need a Render account with permission to create an API key. An API key grants access to every workspace your user belongs to.
Adding a data source
- In PostHog, go to the Sources tab of the data pipeline section.
- Click + New source and click Link next to this source.
- Enter your credentials (see Configuration below) and click Next.
- Select the tables you want to sync, choose a sync method and frequency, then click Import.
Once the syncs are complete, you can start querying this data in PostHog.
When linking Render, you'll need:
- API key – create one under Account settings → API keys in the Render Dashboard.
- Workspace ID (optional) – if your user belongs to multiple workspaces and you only want to sync one, enter its workspace ID (starts with
tea-). You can find it in your workspace settings, or by syncing theownerstable first. Leave empty to sync every workspace the key can access.
Sync modes
Each table can be synced in one of several modes, depending on what the source supports:
- Webhook (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
- Incremental – only new or updated rows are synced on each run, using a cursor field (such as an
updated_attimestamp). Cheaper than a full refresh, but deletes aren't captured. - Append only – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
- Full refresh – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.
See sync methods for a full explanation of how each mode works and how to choose between them.
Deploys, jobs, and events are fetched per service, so syncs make one or more requests for each service in your workspace. Use incremental sync for these tables to keep ongoing syncs fast.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Workspace ID (optional) | text | No |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
owners | Workspaces (users and teams) that the API key's user belongs to. Other resources reference their owning workspace via ownerId. | Full refresh | — | — |
projects | Projects that group related services and databases into environments (e.g. production and staging). | Incremental, Full refresh | updatedAt, createdAt | — |
environments | Environments within a project (e.g. production, staging), listing the services, databases, and env groups they contain. | Full refresh | — | — |
services | Services in the workspace: web services, static sites, private services, background workers, and cron jobs. | Incremental, Full refresh | updatedAt, createdAt | — |
deploys | Deploys for each service, with status, trigger, and timing — one row per deploy per service. | Incremental, Full refresh | finishedAt, updatedAt, createdAt | — |
jobs | One-off jobs run against each service: standalone tasks that run to completion using the service's most recent successful build. | Incremental, Full refresh | finishedAt, startedAt, createdAt | — |
events | Operational events for each service: deploys, builds, restarts, suspensions, autoscaling, disk and plan changes, and more. | Append only, Full refresh | timestamp | — |
custom_domains | Custom domains attached to each service, with verification status. | Full refresh | — | — |
env_groups | Environment groups: named sets of environment variables and secret files shared across services. | Incremental, Full refresh | updatedAt, createdAt | — |
postgres | Managed Postgres instances in the workspace, with plan, status, and configuration. | Incremental, Full refresh | updatedAt, createdAt | — |
key_value | Key Value (Redis-compatible) instances in the workspace, with plan, status, and configuration. | Incremental, Full refresh | updatedAt, createdAt | — |
disks | Persistent disks attached to services, with size and mount path. | Incremental, Full refresh | updatedAt, createdAt | — |
Troubleshooting
- If you see an authentication error, your API key is invalid or has been revoked. Create a new key in your Render account settings, then reconnect.
- Render rate limits API requests per user. Syncs back off and retry automatically, but very large workspaces may sync slowly on the first run.
If your sync is failing or data looks wrong, see the Data warehouse troubleshooting guide. If that doesn't help, contact support – we're happy to help.