Before you start
- Live data sources enabled for your organization. See Live data sources.
- Admin role in the Lightdash project.
- A Pylon API token. A Pylon admin creates it in Settings → API Tokens. The token decides which workspace the source reads.
Connect Pylon
- On the nav bar, click Browse → Semantic Layer.
- In the sidebar, select Live data sources, then click Add.
- Select Pylon.
- Enter a Name, such as
Pylon. People see this name in Explore and agents use it to refer to the source. - Enter the API token, then click Test access.
- Click Add source.
Dimensions
Each table lists records, one row per issue, account or contact.
Dates are UTC days. Assignee and Owner are teammates’ email addresses. Tags are comma separated, and Is keeps records with any of the values. State is
new, waiting_on_you, waiting_on_customer, on_hold, closed or a custom status.
None of the tables has metrics, so a query can’t count or average records.
Supported features
Account and assignee filters match by name and email. Lightdash looks the IDs up in Pylon first, which adds a call.
Limits
When a query matches more than 9,999 records, Lightdash shows an error rather than a partial result. Narrow the date range or add a filter.
Example questions
- “Open issues assigned to me, oldest first.”
- “Issues from the last 7 days that are still open.”
- “Accounts with no customer activity this quarter.”