This topic describes how you can search for items such as objects, projects, 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.
Every two minutes, the system runs a process to index your saved objects, project content, and data set column information. The indexing process also updates the index file to reflect any objects, projects, or data sets that you deleted from your system so that these items are no longer displayed in your search results.
For all data sets, 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 data set 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 data sets, projects, 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 project, report, and data set. 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.
- Enter an asterisk (*) in the search string to perform a wildcard search. The asterisk specifies zero or more alphanumeric characters within the name. For example, to search for all objects that have the word "brand" in their name, specify
- 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.
Use these tips to help you find your content.
|Wildcard Searches||You can use the asterisk (*) as a wildcard when searching. For example, you can specify *forecast to find all items that contain the word “forecast”. However, using two wildcards to further limit a search returns no results (for example, *forecast*).|
|Meaningful Keywords||When you search, use meaningful keywords. If you search with keywords such as by, the, and in it returns no results. For example, if you want to enter by in the search field to locate two projects called “Forecasted Monthly Sales by Product Category” and “Forecasted Monthly Sales by Product Name,” then it returns no results.|
|Items Containing Commas||If you use a comma in your search criteria the search returns no results. For example, if you want to search for quarterly sales equal to $665,399 and enter 665,399 in the search field, then no results are returned. However, entering 655399 does return results.|
|Date Search||If you want to search for a date attribute, you search using the year-month-date format. Searching with the month/date/year format (for example, 8/6/2016) doesn’t produce any direct matches. Instead, your search results contain entries containing 8 and entries containing 2016.|
|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 project or create a data set 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. The system automatically runs the indexing process every two minutes.
Users can access only the data they've been given permission to access.
|Indexed Data||All Excel, CSV, and TXT-based data sets with 1,000 or less distinct rows are indexed and are returned in your search results. Note that database data set data values aren’t indexed and won’t be included in your search results.|