Snowflake Inc.

Yiming Kang

Benoit Dageville

Nithin Mahesh

Lin Chan

Eric Robinson

Jun Luo

Brian Smith

Tianyi Chen

Subramanian Muralidhar

Yi Fang

Vikram Wakade

Rishabh Singh Ahluwalia

As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.

Metadata search via N-gram index

Described herein are techniques for compact representation of table columns via templatization. Column templates can model the collection of columns in a table as a logical entity. The logical entity can be split into two objects. A first object can contain a subset of column attributes (e.g., fields) that can be shared with other tables, such as name and data type. A second object can contain another subset of column attributes that are unique to a table, such as time stamps and created-on information.

Compact representation of table columns via templatization

Metadata search via N-Gram index

Growing community of inventors

Seattle, WA, United States of America

Yiming Kang