Define initial data for a new table dataset
When you create a new table dataset with Table Views, you start by defining initial data. You have three options for initial data.
- An index and source type combination
- You can populate your new dataset with events associated with a combination of indexes and source types.
- An existing dataset
- You can populate your dataset using a dataset that already exists. The dataset can be a table dataset, a data model dataset, a CSV lookup table, or a CSV lookup definition.
- A search
- You can base your dataset on the results of any search string, as long as it doesn't include transforming commands.
Prerequisites
- To access the data required to create table datasets, you must have a role with the get_metadata capability.
- If you use Splunk Analytics for Hadoop and want to create a dataset based on data from a virtual index, you must get your initial data either from a search that references the virtual index or from an existing dataset that already has the virtual index data.
Identify an index and source type combination for initial data
- In the Search & Reporting app, open the Datasets listing page.
- Click Create Table View to go to the initial data setup screen.
- Choose an index that you want to use for initial data. If you do not want to select a specific index, select All indexes.
- Select a source type that you want to use for initial data. If you do not want to select a specific source type, select All source types.
If you select both '''All indexes''' and '''All source types''', you risk creating an overly broad dataset that contains all of the events indexed by your Splunk platform implementation, with the exception of events in
_internal
and other internal indexes, which you must specify by name. In general, avoid creating overly broad datasets. The datasets feature is designed for creating narrow views of data. - Click Next. A preview of your dataset appears. Rows are events, columns are fields, and cells are field values.
- Select existing fields that you want to see in your dataset.
- (Optional) If you are not seeing a field choice that you are expecting, add the missing field by following these steps:
- At the top of the field list, click Add a missing existing field.
- Enter the field and click Add.
- Select the added field.
- Use the dataset preview pane to verify that this is the initial data that you want. If you do not find the existing fields or field values that you were expecting, you can remove this selection and select another one.
- When you are satisfied that your index, source type, and field selections provide the correct initial data for your dataset, click Start Editing to confirm your index, source type, and field selections.
Use an existing dataset for initial data
The Datasets tab lets you select an existing dataset for your initial data. You can select any dataset that you can otherwise see on the Datasets listing page, including data model datasets, lookup tables, and lookup definitions.
When you create a dataset that uses an existing dataset for initial data, you can choose between cloning and extending the existing dataset.
- In the Search & Reporting app, open the Datasets listing page.
- For the dataset that you want to clone or extend, select either Edit > Clone or Edit > Extend in Table.
Selection Description Clone Creates an identical copy of the original dataset. Only table datasets can be cloned. Extend Creates a dataset that is extended from an existing dataset. Changes made to the original dataset propagate down to the extended dataset. All dataset types can be extended. - If you are working with a lookup table file, select the fields that you want to use in your table.
The fields you select are the only fields that will make up your dataset, along with_raw
and_time
, which are required. You can hover over a field to see field statistics, such as the percentage of events in the dataset that have the field and the top values for the field.
Table datasets, data model datasets, and lookup definitions have fixed fields. When you create a new dataset by cloning or extending a dataset with fixed fields, you can't choose which of those fields you want to start with in your dataset. - (Optional) If you don't see a field choice that you are expecting, add the missing field by following these steps:
- At the top of the field list, click Add a missing existing field.
- Enter the field and click Add.
- Select the added field.
- Use the dataset preview pane to verify that this is the initial data that you want. If you do not find the existing fields or field values that you were expecting, you can remove this selection and select another one.
- When you are satisfied that your index, source type, and field selections provide the correct initial data for your dataset, click Start Editing to confirm your index, source type, and field selections.
Provide a search string for initial data
There are two methods that you can follow to derive the search string for initial data. Once you provide the search string, the other initial data setup steps are the same.
The search string you provide must identify the fields that its search commands operate on. For example, a search that only includes commands like sendemail
, highlight
, or delete
is invalid because those commands do not require that you identify the fields that they operate upon.
Use a search string that you created in the Search view
- In the Search view, create a search that returns events that you want in your table.
- Click Create Table View to use the search as the initial data for a new table dataset.
Table Views opens with the search string you designed in the search field. - (Optional) Add more Splunk SPL commands until you have a search that returns results that you want to use in a dataset.
- Click Save to open the Save As New Table box.
- Enter a Table Title.
- Click Save to save the table.
Start with a search string that extends an existing dataset
This method creates a dataset that is extended from an existing dataset. Changes made to the original dataset propagate down to the extended dataset. All dataset types can be extended.
- In the Search & Reporting app, open the Datasets listing page.
- Click Edit > Extend in Table.
- (Optional) Select the fields you want to see in your dataset. You can select fields whether or not the original dataset type has fixed fields.
- (Optional) Add more Splunk SPL commands until you have a search that returns results that you want to use in a dataset.
- Click Save to open the Save As New Table box.
- Enter a Table Title.
- Click Save to save the table.
Manage table datasets | View and update a 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.1.11, 8.1.12, 8.1.13, 8.1.14, 8.2.0, 8.2.1, 8.2.2, 8.2.3, 8.2.4, 8.2.5, 8.2.6, 8.2.7, 8.2.8, 8.2.9, 8.2.10, 8.2.11, 8.2.12, 9.0.0, 9.0.1, 9.0.2, 9.0.3, 9.0.4, 9.0.5, 9.0.6, 9.0.7, 9.0.8, 9.0.9, 9.0.10, 9.1.0, 9.1.1, 9.1.2, 9.1.3, 9.1.4, 9.1.5, 9.1.6, 9.2.0, 9.2.1, 9.2.2, 9.2.3, 9.3.0, 9.3.1
Feedback submitted, thanks!