Snowflake Inc.

Purav B Saraiya

Abdullah Al Mahmood

Xin Huang

Ruta Dhaneshwar

Nithin Mahesh

Ganeshan Ramachandran Iyer

Max Heimel

Jiaxing Liang

Raghav Ramachandran

Yanyi Zhang

Canzhou Qu

Konstantinos Zoumpatianos

A data platform including an error handling framework for loading of input data. The data platform generates input data columns based on an input file and generates result data columns based on the input data columns and evaluating expressions. The data platform detects projection errors during the generating of the result data columns and stores result error indicators in error indicator arrays of the result data columns based on the projection errors. The data platform generates filtered result data columns based on the result data columns and the result error indicator arrays of the result data columns and stores the filtered result data columns in a database of the data platform.

File-based error handling during ingestion with transformation

A data transfer request can be received by each of multiple deployments; however, only a primary deployment can process the request. The data transferred by the primary deployment may be replicated in the secondary deployments. In response to a failover event, one of the secondary deployments can be designated as the new primary development and continue the data transfer based on the data transfer request and the replication information received from the old primary deployment prior to the failover.

Data ingestion replication and disaster recovery

Described herein are techniques for improving disaster recovery, in particular disaster recovery pertaining to data transfer requests. The data transfer request can be received by each of multiple deployments; however, only a primary deployment can process the request. The data transferred by the primary deployment may be replicated in the secondary deployments. In response to a failover event, one of the secondary deployments can be designated as the new primary development and continue the data transfer based on the data transfer request and the replication information received from the old primary deployment prior to the failover.

Growing community of inventors

Kirkland, WA, United States of America

Purav B Saraiya