A data source is a database that your pages read from. Insights › Data lists them all. Some are managed by Threaded. The rest are files and integrations you connect.
#Who can use it
- Owners, Editors and View All members see Data. Operators don’t.
- Only Editors and Owners can connect, upload or run a source.
#Sources managed by Threaded
The list starts with sources Threaded keeps up to date for you:
- Threaded Data: your organization’s platform data.
- Threaded Forms: your forms and their responses.
They show Managed by Threaded. Click Create to build one the first time, or Rebuild to refresh it.
#Connect a source
Click Add data source. Choose one of two options.
#Upload a file
Drop a spreadsheet (.xlsx or .csv, up to 25 MB) or a SQLite file (.db or .sqlite).
- Spreadsheet: Threaded uploads and inspects it, then opens the AI panel with the file attached. The AI builds a data source from it and asks you questions if it needs to. Spreadsheet imports need the AI assistant.
- SQLite file: enter a Title and Description and click Create. No AI is needed.
#Connect an integration
Use this to pull data from another system with a saved credential.
- Choose a provider, such as Google Sheets, and click Next.
- Choose a saved credential or add a new one. Credentials are saved to the credential vault, not to the chat.
- Under Configure data source, enter a Title, a Description and the provider’s settings. For Google Sheets, that’s the Spreadsheet ID (you can paste the sheet’s URL) and, optionally, Tab names.
- Click Create. The AI panel opens and the AI finishes connecting the source.
Connecting an integration needs the Integrations add-on and the AI assistant. Owners manage credentials in Admin › Integrations.
#A data source’s page
Click a source to open it.
- Preview opens the data in your browser. Pick a table from Schema, or write SQL and click Run.
- Download saves the data.
- Upload new version replaces a file source’s data.
- Run integration pulls fresh data from an integration. It is turned off until the AI has finished connecting the source. An integration source can also run on a Schedule.
- Linked reports lists the pages that use this source.
- Version history lists each upload of a file source.
To refresh a source, upload a new version, run its integration, or rebuild a managed source. There is no separate refresh button.
A source can also be built from other sources, such as a metrics table computed from a raw export. See Derived Data Sources.
Run’s work orders and records aren’t in Threaded Data yet. To report on them, read them from the API. See What Run Exposes.