Find Data, Workbooks, and Visualizations
This topic describes how you can search for items such as objects, workbooks, and columns.
How Is Data Indexed?
When you search or visualize data from the Home page, your results are determined by what information has been indexed.
The system runs a process to index your saved objects, workbook content, and dataset column information. The indexing process also updates the index file to reflect any objects, workbooks, or datasets that you deleted from your system so that these items are no longer displayed in your search results.
For all datasets, the column metadata is indexed. For example, column name, the data type used in the column, aggregation type, and so on. Column data is indexed for Excel spreadsheet, CSV, and TXT dataset columns with 1,000 or fewer distinct rows. Note that no database column data is indexed and therefore that data isn’t available in your search results.
Search for Content
Use the search bar on the Home page to find items such as datasets, workbooks, and machine learning scripts.
- On the Home page, locate the search bar.
- Enter your search criteria. Note the following options:
- Click in the search bar for a drop down list of all content types, such as workbook, report, and dataset. Click a content type to add it to the search bar. Or below the search bar, click one of the search tags to add it to the search bar.
- Build or modify a search tag by adding or removing other items.
- Specify the full or partial name of what you're looking for. The search is case-insensitive.
- To clear your search terms, in the search bar click X or select search tags and delete.
- In the search results, click an object to display it.
Search Options
You can enter advanced search commands in the search bar to tailor your search results for exact matches, multi-term matches, and field-level matches.
You can combine multiple search terms with commands to narrow or widen your search. For example, name:(
revenue AND
Analysis)
. Search commands and search terms are case-insensitive.
Search Command | Description | Example |
---|---|---|
|
Enter |
Revenue Revenue Revenue Revenue Forecast |
|
Enter |
Revenue Revenue Revenue |
|
After entering a search term, enter |
Revenue Revenue |
|
Enter the question mark ( |
st |
|
Enter the asterisk ( |
Employ |
|
Enter |
|
|
Enter |
|
|
Enter |
|
|
Enter |
|
|
Enter |
|
|
Enclose a search term with double quotation marks to search for content that includes phrases or stop words which match the search term. |
|
|
Enter the escape character backward
slash (\ ) before each special character (+ - &
| ! ( ) { } [ ] ^ " ~ * ? : \) in a search. For example, to search
for revenue+city enter revenue\+city .
|
|
Search Tips
Use these tips to help you find your content.
- Searching in Non-English Locales - When you enter criteria in the search field, what displays in the drop-down list of suggestions can differ depending upon your locale setting. For example, if you’re using an English locale and enter sales, then the drop-down list of suggestions contains items named sale and sales. However, if you’re using a non-English locale such as Korean and type sales, then the drop-down list of suggestions contains only items that are named sales and items such as sale aren’t included in the drop-down list of suggestions.
- Searching for New Objects and Data - If you create or save a workbook or create a dataset and then immediately try to search for it, then it’s likely that your search results won’t contain matches. If this happens, refresh your browser. If you still can't find the new object or data, then wait a few minutes for the indexing process to run, and retry your search. Users can access only the data they've been given permission to access.