Pre-Joined Tables are ready-made views that combine multiple base tables (e.g., Person/Contacts, Companies, Insight) so you can query them without writing joins yourself. Use them when you need a single table that already links people, companies, and optional insight data.Documentation Index
Fetch the complete documentation index at: https://docs.revenuebase.ai/llms.txt
Use this file to discover all available pages before exploring further.
Benefits of pre-joined tables
- Fewer joins — Query one table instead of joining tables manually.
- Consistent keys — Join keys and relationships are defined and documented for each pre-joined view.
- Easier analytics — Start with Person + Organization or Person + Organization + Insight and filter or aggregate as needed.
Available pre-joined views
| Table Name | View | Description |
|---|---|---|
VELOCITY_BASE_UNLIMITED_LATEST | Person + Organization | Contacts joined to Organization (one row per contact). |
VELOCITY_ENHANCED_UNLIMITED_LATEST | Person + Organization + Insight | Contacts, Organization, and Insight in one view. |
When to use which
- Person + Organization — When you need contact and organization attributes together (e.g., contact email + organization name) without insight fields.
- Person + Organization + Insight — When you also need insight or score fields on the same row.