All Collections
Filtering & Time Travel
Searching & configuring filters
Searching & configuring filters

Search your cloud data warehouse using wildcards. Astrato search uses pushdown SQL, which runs ultrafast, super flexible and up to date.

Piers Batchelor avatar
Written by Piers Batchelor
Updated over a week ago


Astrato introduces a unified approach to searching across various elements, including tables, schemas, data views, workbooks, connections, and user information. This functionality spans both frontend and backend operations, facilitating efficient navigation and data manipulation within our system.

Our search uses pushdown SQL, which runs ultrafast, super flexible and always up to date.

Advanced searching - special characters

To enhance search flexibility and precision, we adopt specific conventions for handling special characters and escaping sequences. Below is an overview of these conventions:

  • Backslash (\): Serves as the escape character, allowing special characters to be included in search queries.

  • Slash (/): Reserved for future regex search functionalities.

  • Asterisk (*): Acts as a wildcard for matching any sequence of characters.

  • Question mark (?): Represents a single-character wildcard.

Search Syntax and Interpretations

This search syntax can also be used in the filter tab of the properties panels for charts and other data objects. This syntax is available for use with the Like and not like operators.

End User Filter String


Effective SQL Representation


Finds all elements containing "astrato"



Identical to "astrato" search



Finds elements starting with "astrato"



Matches elements ending with "trato" with two preceding characters



Searches for elements starting with "ast", followed by any two characters, ending with "to"



Finds elements containing "*astrato"



Searches for elements containing "%astrato"

%^%astrato% (with '^' as an escape)


Allows for escaping unnecessary characters, searching for "astrato"



Finds elements containing "\astrato"


Key Rules

Escaping examples


Evaluated as






%^_astrato% ESCAPING '^'

  • Wildcard characters ("*" and "?") are taken literally if escaped.

  • Unescaped search queries automatically append wildcards at both ends, except when special characters are explicitly used.

Implementation Notes

Google Sheets Compatibility

  • The described search functionality is not applicable to Google Sheets integrations.

Development Priorities

  • Case Insensitivity: Ensure search is insensitive to case variations, e.g., "Astrato" vs. "astrato".

  • Special Handling for Data View Editor & Fields: Underscores in table and field names are interpreted as spaces (" ") for improved user experience. This approximation covers most cases, acknowledging minor exceptions.

  • Phased Rollout: Our initial release focuses on data-related searches, including filter bar search, filter object search and chart filters. Other parts of the product will follow.

Coming Soon

  • Enhanced regex search capabilities.

  • Expanded metadata search functionality.

  • Improved integration with Google Sheets.

This documentation outlines the foundational principles of our search functionality, ensuring users can efficiently navigate and utilize the system's features. Further enhancements and updates will be communicated as they become available.

Did this answer your question?