Snowflake Inc.

Kedar Nitin Shah

Polita Paulus

Yi Fang

Nemanja Matkovic

Yantao Song

Gaurav Saxena

Provided herein are systems and methods for configuring data recovery. A method includes decoding, by at least one hardware processor, a request to recover historical table data. The request is received from an account of a data provider. The historical table data includes a plurality of partition files. Each of the plurality of partition files includes a deleted file designation. Based on the request, a recovery process of the plurality of partition files is performed to obtain recovered partition files. A schema associated with the historical table data is retrieved. Metadata corresponding to the retrieved schema is generated. The metadata is associated with the recovered partition files to recover the historical table data.

Automated failsafe data recovery

A data platform that performs a file existence check is provided. The data platform creates a bounded page and selects a set of selected metadata files from a set of metadata files, where each selected metadata file includes a set of data file metadata files. Each member of the set of data file metadata files includes a file name of a respective data file. The data platform stores the set of data file metadata files of each selected metadata file in a first sorted list in the bounded page. The data platform retrieves a second sorted list of file names of a set of data files stored on a data storage system. The data platform determines the existence of each respective data file of each member of the set of data file metadata files on the data storage system by comparing the first sorted list to the second sorted list.

Growing community of inventors

Sammamish, WA, United States of America

Kedar Nitin Shah