US 11,899,646 B2
Providing table data access in user-specified formats on user-managed storage
Selcuk Aya, Izmir (TR); Thierry Cruanes, San Mateo, CA (US); Istvan Cseri, Seattle, WA (US); Benoit Dageville, San Mateo, CA (US); Marcia Feitel, Sunnyvale, CA (US); Steven P. Herbert, Woodinville, WA (US); Xinglian Liu, Redmond, WA (US); James Malone, Seattle, WA (US); Subramanian Muralidhar, Mercer Island, WA (US); Muthunagappan Muthuraman, Sunnyvale, CA (US); Polita Paulus, Kirkland, WA (US); Marianne Shaw, Bothell, WA (US); Nileema Shingte, San Mateo, CA (US); Wai Sing Wong, Bellevue, WA (US); and Jiaqi Yan, Menlo Park, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Mar. 30, 2023, as Appl. No. 18/193,069.
Claims priority of provisional application 63/366,217, filed on Jun. 10, 2022.
Prior Publication US 2023/0401193 A1, Dec. 14, 2023
Int. Cl. G06F 16/22 (2019.01); G06F 16/25 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 16/2379 (2019.01); G06F 16/258 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A network-based database system comprising:
at least one hardware processor; and
a memory storing instructions that cause the at least one hardware processor to perform operations comprising:
receiving a command to commit a table in a different table format on an external volume, the external volume provided by a storage platform of a cloud storage provider system, the different table format being different than a first table format utilized for storing a set of tables in internal storage;
generating a first snapshot of the table on the internal storage, the table being stored in the first table format different than the different table format;
generating a first list of metadata files on the internal storage;
generating, based on the first list of metadata files, a first set of metadata files on the internal storage, the first set of metadata files being stored in a metadata database on the internal storage;
generating a second snapshot of the table on the external volume;
generating a second list of metadata files on the external volume;
generating, based on the second list of metadata files, a second set of metadata files on the external volume;
generating a first set of data files in a different file format on the external volume; and
sending an indication that the command to commit the table has completed.