SmartSuggest and EagerSuggest¶
Alation’s extensive search capabilities extend to Compose. Through SmartSuggest and EagerSuggest, Alation helps you find and choose the right data objects to query by providing suggestions as you type. These suggestions are based on the popularity of the data—how frequently it is queried across your organization. Alation learns this from Query Log Ingestion and user behavior over time.
SmartSuggest provides suggestions after you start typing a few characters. EagerSuggest provides suggestions after you enter a space character but before you start typing anything else. EagerSuggest can also provide suggestions right after you use SmartSuggest to insert something into your query.
When SmartSuggest or EagerSuggest are enabled, you will receive suggestions for:
Keywords
Data objects—schemas, tables, and columns
Joins
Filters
Identifiers
Functions for select data sources on native connectors
Note
Functions can be suggested for the following data sources on native connectors: Azure, Hive, PostgreSQL, SQLite, SQL Server, Teradata, and Vertica.
For PostgreSQL, Alation suggests both user-defined and built-in functions, and the functions are brought into Alation during metadata extraction.
If you have given logical (human-readable) titles to your data objects, joins, and filters in Alation, you can enter those titles into your query and SmartSuggest will make relevant suggestions.
Use SmartSuggest and EagerSuggest¶
In the example below, you can see that a user began typing and now is at the letter combination SE. In the SmartSuggest window, Alation suggests a number of options that potentially predict what the user is trying to type.

Use the arrow keys or the mouse to select an item from the list of suggestions. When you select a catalog object, the Preview tab will immediately show information about that object. After selecting a suggestion, use the enter or tab key to insert it into your query.
Disable or Enable SmartSuggest and EagerSuggest¶
You can turn SmartSuggest and EagerSuggest on and off at any time. To disable or enable:
In Compose, click Settings in the upper-right corner of the page. The Settings dialog will open.
Click the SmartSuggest tab.
To disable SmartSuggest, clear the Enable SmartSuggest checkbox. To enable it, select this checkbox.
Note
You must enable SmartSuggest for EagerSuggest to work.
Use the Enable Eager suggestions checkbox to enable or disable EagerSuggest.
Click Apply.
Set the Length of the List of Suggestions¶
Applies from release 2021.3
It is possible to adjust the size of the suggestion window to be 5, 10, or 15 items in a category. If there are more items in the list than the selected number, you will need to scroll up or down to view them all. This setting applies to both SmartSuggest and EagerSuggest.
To set the size of the suggestion list:
In Compose, click Settings in the upper-right corner of the page. The Settings dialog will open.
Under SmartSuggest Modal Size, select the number of items you wish to be visible in the suggestion list for both SmartSuggest and EagerSuggest. The preview area on the right shows what the adjusted list will look like.
Click Apply.