Manage table datasets
You can create and manage table datasets using the Datasets listing page for the Splunk platform.
For information about default features of the Datasets listing page, such as accessing Explorer views of datasets, investigating datasets in Search, and visualizing datasets with Pivot, see Manage datasets.
Create table datasets
To create a table dataset, click Datasets in the green Apps bar, and then click Create Table View. This takes you to the Table Views workflow. After you define initial data, you can also edit the dataset with Table Views.
When you create table datasets, always give them unique names. If you have more than one table dataset with the same name in your system you risk experiencing object name collision issues that are difficult to resolve.
For example, say you have two table datasets named Store Sales, and you share one at the global level, but leave the other one private. If you then extend the global Store Sales dataset, the dataset that is created through that extension will display the table from the private Store Sales dataset instead.
Delete a table dataset
You can delete any table dataset that you have write permissions for.
Before deleting a table dataset, verify that it is not extended to one or more child table datasets. Deleting a parent dataset breaks tables and other objects that are extended from it. For example, if table Alpha is extended to table Beta, and table Beta is in turn used to create a Pivot visualization that is used in a dashboard panel, that dashboard panel ceases to function if you delete table Alpha.
- On the Datasets listing page, find the table dataset that you want to delete.
- Select Edit > Delete.
- Click Delete again to confirm.
Extend a dataset as a new table dataset
You can extend any dataset as a new table dataset. The extended dataset is a new dataset that is bound to the original dataset through its reference to that dataset. If the definition of the parent dataset changes, those changes are passed down to any child datasets that are extended from it.
To see from what datasets a table dataset is extended, expand its row in the Datasets listing page by clicking its > symbol in the first column. The parent datasets for that dataset are listed in an Extends line item. If a table dataset does not have an Extends line item, it is not extended from another dataset.
- To understand why you might want to extend a dataset and what you can with an extended dataset, see Dataset extension.
- To access your extended dataset, see View and update a table dataset.
- On the Datasets listing page, find a dataset that you want to extend.
- For that dataset, select Edit > Extend in Table.
- (Optional) Use Table Views to modify the new table.
- Click Save to open the Save As New Table dialog.
- Enter a Table Title.
- Click Save to save the table.
Clone a table dataset
Clone a table dataset to make a new table dataset that is a copy of an existing dataset. Cloning differs from dataset extension in that you can make changes to the original dataset without affecting datasets that are cloned from that dataset.
Table datasets are the only dataset type that can be cloned through the Datasets listing page. You can clone lookup definition datasets through the Lookup Definitions page in Settings.
- On the Datasets listing page, find a table dataset that you want to copy.
- Select Edit > Clone.
- Enter a Table Title.
- (Optional) Enter a Description.
- Click Clone Dataset.
- (Optional) Click Edit to edit your cloned dataset.
- (Optional) Click Pivot to open the cloned dataset in Pivot and create a visualization based on it.
Edit a table dataset
Use the Datasets listing page to edit selected table datasets. You can edit a table description, or you can edit the table with Table Views.
Add or edit a table dataset title or description
Table dataset descriptions are visible in two places:
- The Dataset listing page, when you expand the table dataset row.
- The Explorer view of the table dataset, under the dataset name.
To add or edit a table dataset title or description, follow these steps:
- On the Datasets listing page, find a table dataset whose description you would like to add or edit. Expand the dataset row by clicking the > symbol in the first column to see its current description.
- Select Edit > Edit title or description.
- Add or update the title or description.
- Click Save.
Edit a table dataset in Table Views
Use the Datasets listing page to open and edit a dataset in Table Views.
- On the Datasets listing page, find a table dataset that you want to edit.
- Select Edit > Edit table.
- Edit the table in Table Views.
- Click Save.
For more information about using Table Views, see View and update a table dataset.
Update table dataset permissions
New table datasets are private by default and are available only to the users who created them. If you want other users to be able to view or edit a private table dataset you can change its permissions.
By default, only the Power and Admin roles can set permissions for table datasets.
On the Datasets listing page, select Edit > Edit Permissions for the table whose permissions you want to edit. You can see whether the table is shared with users of a specific app or globally with users of all apps. You can also see which roles have read or write access to the app.
For information about setting permissions, see Manage knowledge object permissions.
If you want to share a private table dataset that you do not own, you can change its permissions through the Data Models management page in Settings. You cannot see private datasets that you do not own in the Datasets listing page.
- Select Settings > Data models.
- Locate the table dataset that you want to share and select Edit > Edit Permissions.
- Share the dataset at the App or All apps level, and set read/write permissions as necessary.
- Click Save.
When you return to the Datasets listing page, verify that the dataset is visible and has the new permissions that you set for it.
Manage table dataset acceleration
Table datasets that contain a large amount of data can be accelerated so that their underlying search completes faster when you view the dataset or visualizations that are backed by it. Table acceleration only applies to table datasets when the
pivot commands are applied to the table datasets.
For more information about enabling and managing table acceleration, including caveats and restrictions related to table acceleration, see Accelerate tables.
Get started with table datasets
Define initial data for a new table dataset
This documentation applies to the following versions of Splunk® Enterprise: 8.1.0, 8.1.1, 8.1.2, 8.1.3, 8.1.4, 8.1.5, 8.1.6, 8.1.7, 8.1.8, 8.1.9, 8.1.10, 8.2.0, 8.2.1, 8.2.2, 8.2.3, 8.2.4, 8.2.5, 8.2.6, 8.2.7, 9.0.0