Mach5 on BigQuery
Get more value out of your BigQuery data warehouse
How it works
Query data through Mach5 using one of the supported languages
Mach5 translates the query from one of the supported languages into the equivalent, underlying BigQuery SQL statement against your table(s). During translation, the compiler automatically transforms query and filter expressions into SQL that leverages the indexes that were built at ingestion time in order to make use of BigSearch optimization capabilities whenever possible.
Ingest and store data directly into BigQuery
Mach5 translates bulk requests into BigQuery streaming write API requests, converts and stores your data in a tabular format within BigQuery. Mach5 adds synthetic fields to your table data that act as an in-place index structure. These synthetic fields contain specific data and tokens that allow us to support the more complex types of queries that are provided by the Elasticsearch Query DSL (e.g. phrase search, typo search)