Granted Patent B2

US 12,399,900 · App. 18/392,327 · Granted Aug 26, 2025

Inventors: Tyler Arthur Akidau (Seattle, WA); Istvan Cseri (Seattle, WA); Tyler Jones (Redwood City, CA); Daniel E. Sotolongo (Seattle, WA); Zhuo Zhang (Kirkland, WA)

Assignee: Snowflake Inc.

G06F16/24568G06F16/2219G06F16/24544G06F16/2456G06F16/258

Abstract

Claims (62)

1. A method comprising:

receiving, by a data system, a registration request for a group of files in a first format to be ingested in one or more source tables in a second format;

committing the group of files in the data system;

generating a hybrid table for intermittent query processing, the hybrid table comprising the committed data in the first format and data from the one or more source tables in the second format, the hybrid table presenting a unified view of the committed data in the first format and the data from the one or more source tables in the second format;

receiving a query prior to the group of files being ingested;

converting the committed data from the first format into a common format;

converting data from the one or more source tables from the second format into the common format;

joining the committed data in the common format and the data from the one or more source tables in the common format to generate joined data;

executing the query based on the joined data; and

ingesting the group of files into the one or more source tables in the second format after the query is executed.

2. The method of claim 1 , wherein the group of files is per-account group of files, and wherein the registration request including identification information for the per-account group of files and a storage location of the per-account group of files.

3. The method of claim 2 , further comprising:

accessing the per-account group of files based on the registration request, the per-account group of files being stored in the first format;

deduping and validating the per-account group of files using sequencing information included in the per-account group of files.

4. The method of claim 3 , wherein ordering of the received data is maintained based on the sequencing information.

5. The method of claim 1 , wherein the committed data is organized into per-table sets, data in each set belonging to a single source table.

6. The method of claim, 5 wherein per-table sets are organized into a per-account group, data in the per-account group belonging to a single account.

7. The method of claim 1 , further comprising:

retrieving expression properties of the committed data; and

pruning the committed data based on the expression properties and the query.

8. A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

receiving, by a data system, a registration request for a group of files in a first format to be ingested in one or more source tables in a second format;

committing the group of files in the data system;

generating a hybrid table for intermittent query processing, the hybrid table comprising the committed data in the first format and data from the one or more source tables in the second format, the hybrid table presenting a unified view of the committed data in the first format and the data from the one or more source tables in the second format;

receiving a query prior to the group of files being ingested;

converting the committed data from the first format into a common format;

converting data from the one or more source tables from the second format into the common format;

joining the committed data in the common format and the data from the one or more source tables in the common format to generate joined data;

executing the query based on the joined data; and

ingesting the group of files into the one or more source tables in the second format after the query is executed.

9. The machine-storage medium of claim 8 , wherein the group of files is per-account group of files, and wherein the registration request including identification information for the per-account group of files and a storage location of the per-account group of files.

10. The machine-storage medium of claim 9 , further comprising:

accessing the per-account group of files based on the registration request, the per-account group of files being stored in the first format;

deduping and validating the per-account group of files using sequencing information included in the per-account group of files.

11. The machine-storage medium of claim 10 , wherein ordering of the received data is maintained based on the sequencing information.

12. The machine-storage medium of claim 8 , wherein the committed data is organized into per-table sets, data in each set belonging to a single source table.

13. The machine-storage medium of claim 12 , wherein per-table sets are organized into a per-account group, data in the per-account group belonging to a single account.

14. The machine-storage medium of claim 8 , further comprising:

retrieving expression properties of the committed data; and

pruning the committed data based on the expression properties and the query.

15. A system comprising:

at least one hardware processor; and

at least one memory storing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:

receiving, by a data system, a registration request for a group of files in a first format to be ingested in one or more source tables in a second format;

committing the group of files in the data system;

generating a hybrid table for intermittent query processing, the hybrid table comprising the committed data in the first format and data from the one or more source tables in the second format, the hybrid table presenting a unified view of the committed data in the first format and the data from the one or more source tables in the second format;

receiving a query prior to the group of files being ingested;

converting the committed data from the first format into a common format;

converting data from the one or more source tables from the second format into the common format;

joining the committed data in the common format and the data from the one or more source tables in the common format to generate joined data;

executing the query based on the joined data; and

ingesting the group of files into the one or more source tables in the second format after the query is executed.

16. The system of claim 15 , wherein the group of files is per-account group of files, and wherein the registration request including identification information for the per-account group of files and a storage location of the per-account group of files.

17. The system of claim 16 , the operations further comprising:

accessing the per-account group of files based on the registration request, the per-account group of files being stored in the first format;

deduping and validating the per-account group of files using sequencing information included in the per-account group of files.

18. The system of claim 17 , wherein ordering of the received data is maintained based on the sequencing information.

19. The system of claim 15 , wherein the committed data is organized into per-table sets, data in each set belonging to a single source table.

20. The system of claim 19 , wherein per-table sets are organized into a per-account group, data in the per-account group belonging to a single account.

21. The system of claim 15 , the operations further comprising:

retrieving expression properties of the committed data; and

pruning the committed data based on the expression properties and the query.

Assignments (1)

Continuity (5)

References Cited (90)