Build dashboards
After a dataset is created
Follow a load, reload, add data, and find your way around a dataset's page.
Once a dataset exists, its own page shows its status, its columns, its data, and its loads. This page covers following a load, reloading, adding data, and each tab of the dataset's page.
Follow a load
Live connect datasets read their table directly, so they have nothing to load. For the others, GOAT starts loading when you create the dataset.
- The dataset's status reads Pending, with "loading" beside it, until the load finishes, then Live.
- Notifications, at the top of the app, lists loads while they run, and any that failed.
- The dataset's Data tab lists every load under Jobs, with its rows and size.
If a load fails, the status reads Failed with a reason, and Notifications links to the Data tab, which has the details.
The dataset's tabs
| Tab | What it shows |
|---|---|
| Overview | The table's size and columns, how GOAT reads it, and what uses it. |
| Columns | Each column's visibility, classification, and description. See Prepare columns. |
| Tenancy | The tenant key and sharing. |
| Data | The latest rows, adding data, and the list of loads. |
| Settings | The dataset's name, how long answers are reused, and the cost cap per query. See Costs. |
As an author, the Data tab's Latest rows shows every tenant's rows.
Reload
To load a dataset's source again, open its Data tab and choose Reload again. A reload replaces the table with what the source holds now. Its progress shows under Jobs.
Loading new data clears the answers GOAT had kept for the dataset, so charts show the new data.
Add or replace data
What you can add depends on where the data comes from:
| Source | What you can do on the Data tab |
|---|---|
| Cloud Storage files | Add another location, remove one, and Reload now. A dataset keeps at least one location. |
| Uploaded files | Upload more files…, to add files with the same columns, or Replace all…, to replace every file uploaded so far. |
| A managed copy of a BigQuery table | Reload again. Its source is the table, so there are no locations to add. |
| Push API | Your application sends rows. See Push data from your application. |
| Live connect | Nothing to load. GOAT reads the table where it is. |
Common problems
| What you see | What to check |
|---|---|
| Status "Failed" with a reason | Open the Data tab for the details. Fix the file or table, then Reload again. |
| "The source file or table was not found." | The file or table moved or was deleted. Check that it still exists. |
| "We do not have permission to read the source." | GOAT lost access to it. See Give GOAT access to your data. |
| Charts still show old data after a reload | Check under Jobs that the reload finished. |