US 12,436,997 B2
Synchronizing file-catalog table with file stage
Polita Paulus, Kirkland, WA (US); Aravind Ramarathinam, Sammamish, WA (US); Saurin Shah, Kirkland, WA (US); and Sukruth Komarla Sukumar, Bellevue, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Oct. 31, 2024, as Appl. No. 18/933,173.
Application 18/933,173 is a continuation of application No. 18/461,897, filed on Sep. 6, 2023, granted, now 12,135,745.
Application 18/461,897 is a continuation of application No. 18/049,695, filed on Oct. 26, 2022, granted, now 11,797,608.
Application 18/049,695 is a continuation of application No. 17/645,415, filed on Dec. 21, 2021, granted, now 11,494,438.
Application 17/645,415 is a continuation of application No. 17/244,349, filed on Apr. 29, 2021, granted, now 11,222,071.
Application 17/244,349 is a continuation of application No. 16/942,352, filed on Jul. 29, 2020, granted, now 10,997,243.
Claims priority of provisional application 63/046,229, filed on Jun. 30, 2020.
Prior Publication US 2025/0068676 A1, Feb. 27, 2025
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/901 (2019.01); G06F 16/908 (2019.01); G06F 16/955 (2019.01)
CPC G06F 16/9017 (2019.01) [G06F 16/2282 (2019.01); G06F 16/24568 (2019.01); G06F 16/908 (2019.01); G06F 16/955 (2019.01)] 45 Claims
OG exemplary drawing
 
1. A method performed by a data platform executing instructions on at least one hardware processor, the method comprising:
receiving a notification of a modification to one or more files in a file stage for a first user account of the data platform, the file stage comprising one or more files at the particular storage location, the first user account being associated with a file-stage object that corresponds to the file stage and associated with the particular storage location, the first user account being associated with one or more databases that include one or more tables; and
refreshing, 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 comprising a row for each file in the file stage and a column for metadata properties of the one or more files in the file stage.