Requirements
Before configuring AI Search, confirm the following:- Snowflake Cortex provider configured with an embedding service — see Snowflake Cortex Setup
- Standard Snowflake table — other table types are not supported
- Change tracking enabled on all underlying Snowflake tables — this can be enabled at any time, even after connecting an Element to Elementum. Run
ALTER TABLE <table_name> SET CHANGE_TRACKING = TRUE;if it is not already on. - A text field containing the content you want to search
- A unique identifier field (primary key) on each record
For automation triggers like “Record is updated” on Snowflake tables, change tracking must be enabled before configuring the trigger.
How It Works
- Content processing — Your text data is converted into high-dimensional vectors (embeddings) that represent semantic meaning.
- Query understanding — When you search, your query is converted into an embedding using the same model.
- Similarity matching — The system finds content whose embeddings are closest to your query, regardless of exact word overlap.
- Results ranking — Results are ordered by semantic similarity so the most relevant records appear first.
Setting Up AI Search
Select your table and fields
- Field to Search — Choose the primary text field containing searchable content
- Standard Table — Select a Standard Snowflake table
- Unique Identifier — Specify the field that uniquely identifies each record
Configure search parameters
- Attribute Fields — Select additional fields to return alongside search results (e.g., category, status, date)
- Service — Choose your configured Snowflake Cortex embedding service
- Archival Service — Select the Snowflake Cortex service to use when running search queries
- Target Lag — Set how frequently the search index updates (
1= daily)
Using the Search Interface
Once a search table is configured, you can query it directly from the AI Search interface. Natural language queries — Type questions in plain language. AI Search understands meaning, so queries like “issues with payment processing” or “customer complaints about delivery” return semantically relevant results even when records use different phrasing. Filtering — Combine semantic search with attribute filters to narrow results by field values, date ranges, or categories. Results — Each result includes the matched text, a similarity score indicating how closely it relates to your query, and any attribute fields you configured during setup.AI Search in Other Features
AI Search integrates with automations, agents, and Tables. Rather than configuring AI Search differently in each context, you set it up once (as described above) and then reference the search table where needed.Automations
Use the AI Search action in an automation to run a semantic query as part of a workflow. Select a configured AI Search table as the source and pass a dynamic query using value references from earlier in the automation (e.g.,{{trigger.description}}).
For full configuration details and output variables, see AI Search in the Automation Actions Reference. For broader guidance on using AI within automations, see AI in Automations.
Agents
AI Search can be configured as a tool that agents call at runtime to look up relevant records during a conversation. When adding AI Search as an agent tool, you can define input value references with descriptions and use them in filters so the agent passes values dynamically for context-aware search. For details on configuring agent tools, see Agent Skills. For building and managing agents, see Building Agents.Tables
Table admins can enable AI Search on any Table. The setup follows the same process described above. For details on enabling AI Search within the Tables interface, see the AI Search section on the Tables page.Tips for Better Results
- Choose a descriptive text field. The field you index should contain meaningful, readable content — not codes or IDs. Fields with complete sentences or descriptions produce better semantic matches.
- Keep content at a reasonable length. Embedding models work best with content in the 512–1,024 token range. Very short or very long text can reduce match quality.
- Use consistent language. Consistent terminology and formatting across records improves how well the embedding model captures your domain’s semantics.
- Set appropriate result limits. For most use cases, 10–50 results strikes the right balance between coverage and relevance. In automation workflows, start with a smaller limit and increase if needed.
- Update your index regularly. The Target Lag setting controls how often new or changed records are indexed. Daily updates (Target Lag =
1) work well for most cases; adjust if your data changes more frequently.
Troubleshooting
Change tracking errors
Change tracking errors
Symptoms: AI Search fails to create or index properly, or you receive errors about change tracking.Solutions:
- Enable change tracking on the source Snowflake table:
- Verify change tracking is active:
Check the
change_trackingcolumn in the output. - For “Record is updated” automation triggers, change tracking must be enabled before configuring the trigger.
Cannot configure AI Search on a table
Cannot configure AI Search on a table
Symptoms: The setup dialog does not allow you to create a search configuration.Solutions:
- Confirm the table is a Standard Snowflake table — other types are not supported.
- Verify that a Snowflake Cortex embedding service is configured under AI Services.
- Check that change tracking is enabled on the underlying table.
- Ensure you have the necessary permissions to configure search.
Poor or irrelevant search results
Poor or irrelevant search results
Symptoms: Searches return results that don’t match the intent of your query.Solutions:
- Review the content in your indexed text field — short, vague, or code-like values produce weaker embeddings.
- Try rephrasing your query to be more specific.
- Check that the correct embedding service is selected in the search configuration.
- If the indexed content has changed significantly since the last index update, wait for the next index refresh or reduce the Target Lag setting.
Slow search responses
Slow search responses
Symptoms: Search queries take longer than expected to return results.Solutions:
- Reduce the number of attribute fields returned with results.
- Lower the result limit if it is set high.
- Ensure your Snowflake warehouse is appropriately sized for the data volume.
- Check Snowflake Cortex service status for any provider-side latency.
Next Steps
AI Services
Create and manage the embedding services that power AI Search
AI in Automations
Learn how AI actions — including AI Search — fit into automation workflows
Building Agents
Create agents that use AI Search as a runtime tool
Automation Actions Reference
Full configuration details for the AI Search automation action