Synchronizing file-catalog table with file stage
AssigneeSnowflake Inc.
InventorsPolita Paulus, Aravind Ramarathinam, Saurin Shah, Sukruth Komarla Sukumar
Life of this patent
Estimating the term…
Abstract
Disclosed herein are embodiments of systems and methods for synchronizing file-catalog table with a file stage. In an embodiment, a data platform receives a notification of a modification to one or more files in a file stage. The file stage includes data storage having a storage location. The data platform updates, based on receiving the notification of the modification, a first file-catalog table for the file stage based on the modification. The first file-catalog table includes a row for each file in the file stage, as well as a column for each of one or more metadata properties of the one or more files in the file stage.
Claims20
A method comprising:
- receiving a query for information associated with a user account;
- executing, by at least one hardware processor, one or more database-table commands corresponding to the query by accessing one or more files in a file stage for the user account of a data platform, the file stage comprising data storage having a particular storage location, the file stage containing one or more files at the particular storage location, the user account comprising a file-stage object that corresponds to the file stage and that comprises an indication of the particular storage location, the user account being associated with one or more databases that collectively include one or more tables;
- and
- transmitting data associated with results of the executed one or more database-table commands.
A data platform comprising:
- at least one hardware processor;
- and
- one or more computer-storage media containing instructions that, when executed by the at least one hardware processor, cause the data platform to perform operations including:
- receiving a query for information associated with a user account;
- executing, by at least one hardware processor, one or more database-table commands corresponding to the query by accessing one or more files in a file stage for the user account of a data platform, the file stage comprising data storage having a particular storage location, the file stage containing one or more files at the particular storage location, the user account comprising a file-stage object that corresponds to the file stage and that comprises an indication of the particular storage location, the user account being associated with one or more databases that collectively include one or more tables;
- and
- transmitting data associated with results of the executed one or more database-table commands.
One or more non-transitory computer-storage media containing instructions that, when executed by at least one hardware processor of a data platform, cause the at least one hardware processor to perform operations including:
- receiving a query for information associated with a user account;
- executing, by at least one hardware processor, one or more database-table commands corresponding to the query by accessing one or more files in a file stage for the user account of a data platform, the file stage comprising data storage having a particular storage location, the file stage containing one or more files at the particular storage location, the user account comprising a file-stage object that corresponds to the file stage and that comprises an indication of the particular storage location, the user account being associated with one or more databases that collectively include one or more tables;
- and
- transmitting data associated with results of the executed one or more database-table commands.
Dependencies are inferred from the claim text.