Snowflake Inc.

Brian Smith

Thierry Cruanes

Subramanian Muralidhar

Damien Carru

Nicola Dan Onose

Ryan Michael Thomas Shelly

Jaeyun Noh

Benoit Dageville

Eric Robinson

Nithin Mahesh

Jun Luo

Lin Chan

Tianyi Chen

Yiming Kang

Unmesh Jagtap

William A Pugh

Xu Xu

Jeremy Yujui Chen

A data platform for developing and deploying a user application within a unified security context. The data platform authorizes a first user to use an editor to access source code of a user application based on security policies of a security context and authorizes the first user to use an application and data manager to set usage privileges for a second user to use the user application based on the security policies of the security context. To provide the user application to the second user, the data platform deploys the user application by instantiating a User Defined Function (UDF) server and an application engine of the UDF server within the security context, instantiating the user application as an application of the application engine within the security context, and authorizing access by the user application to databased on the security policies of the security context.

Data platform with unified privileges

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

Techniques described herein can allow users to share cached results of an original query with other users while protecting sensitive information. The techniques described herein can check whether the other users have access to the underlying data queried before allowing those users to see the stored query results. That is, the system may perform privilege checks on the shared users before giving them access to the stored query results but without having to re-run the original query.

Privilege based access checks for query results

Metadata search via N-Gram index

Growing community of inventors

Hillsborough, CA, United States of America

Brian Smith