{"id":"https://openalex.org/W2430301697","doi":"https://doi.org/10.1145/2882903.2903741","title":"The Snowflake Elastic Data Warehouse","display_name":"The Snowflake Elastic Data Warehouse","publication_year":2016,"publication_date":"2016-06-14","ids":{"openalex":"https://openalex.org/W2430301697","doi":"https://doi.org/10.1145/2882903.2903741","mag":"2430301697"},"language":"en","primary_location":{"id":"doi:10.1145/2882903.2903741","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2882903.2903741","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5004037878","display_name":"Beno\u00eet Dageville","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Benoit Dageville","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084497894","display_name":"Thierry Cruanes","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Thierry Cruanes","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061001401","display_name":"Marcin \u017bukowski","orcid":"https://orcid.org/0009-0001-1366-6958"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Marcin Zukowski","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027915213","display_name":"\u0412. \u0410. \u0410\u043d\u0442\u043e\u043d\u043e\u0432","orcid":"https://orcid.org/0009-0004-5965-0777"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Vadim Antonov","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034483445","display_name":"Artin Avanes","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Artin Avanes","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109323373","display_name":"Jon Bock","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jon Bock","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065700889","display_name":"Jonathan Claybaugh","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jonathan Claybaugh","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064699729","display_name":"Daniel Engovatov","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Daniel Engovatov","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027200254","display_name":"Martin Hentschel","orcid":"https://orcid.org/0009-0004-8528-4168"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Martin Hentschel","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101930649","display_name":"Jiansheng Huang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jiansheng Huang","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036326090","display_name":"Allison W. Lee","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Allison W. Lee","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047692520","display_name":"Ashish Motivala","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ashish Motivala","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071195732","display_name":"Abdul Q. Munir","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Abdul Q. Munir","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053454549","display_name":"Steven Pelley","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Steven Pelley","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084876382","display_name":"Peter Povinec","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Peter Povinec","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011987775","display_name":"Greg Rahn","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Greg Rahn","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089203437","display_name":"Spyridon Triantafyllis","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Spyridon Triantafyllis","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057096772","display_name":"Philipp Unterbrunner","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Philipp Unterbrunner","raw_affiliation_strings":["Snowflake Computing, San Mateo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing, San Mateo, CA, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":18,"corresponding_author_ids":["https://openalex.org/A5004037878"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":21.4889,"has_fulltext":false,"cited_by_count":297,"citation_normalized_percentile":{"value":0.99298549,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"215","last_page":"226"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11614","display_name":"Cloud Data Security Solutions","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.77163165807724},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7281368970870972},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5590582489967346},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5490052700042725},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.5190666317939758},{"id":"https://openalex.org/keywords/software-as-a-service","display_name":"Software as a service","score":0.48794978857040405},{"id":"https://openalex.org/keywords/elasticity","display_name":"Elasticity (physics)","score":0.4801006615161896},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.34851565957069397},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3355383574962616},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.2584787905216217},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.25668296217918396},{"id":"https://openalex.org/keywords/software-development","display_name":"Software development","score":0.1529974341392517}],"concepts":[{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.77163165807724},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7281368970870972},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5590582489967346},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5490052700042725},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.5190666317939758},{"id":"https://openalex.org/C175133352","wikidata":"https://www.wikidata.org/wiki/Q1254596","display_name":"Software as a service","level":4,"score":0.48794978857040405},{"id":"https://openalex.org/C121854251","wikidata":"https://www.wikidata.org/wiki/Q62932","display_name":"Elasticity (physics)","level":2,"score":0.4801006615161896},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.34851565957069397},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3355383574962616},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.2584787905216217},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.25668296217918396},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.1529974341392517},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2882903.2903741","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2882903.2903741","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5899999737739563,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W135863099","https://openalex.org/W1494049834","https://openalex.org/W1585029481","https://openalex.org/W1605782097","https://openalex.org/W1873909800","https://openalex.org/W1967091776","https://openalex.org/W1981988185","https://openalex.org/W1987358714","https://openalex.org/W2005112390","https://openalex.org/W2020765652","https://openalex.org/W2029467255","https://openalex.org/W2074935284","https://openalex.org/W2091765165","https://openalex.org/W2098445298","https://openalex.org/W2103317919","https://openalex.org/W2106771621","https://openalex.org/W2114303224","https://openalex.org/W2119738171","https://openalex.org/W2124851765","https://openalex.org/W2130642985","https://openalex.org/W2139445852","https://openalex.org/W2146183750","https://openalex.org/W2159726625","https://openalex.org/W2265297126","https://openalex.org/W2621530037","https://openalex.org/W6605485969","https://openalex.org/W6678708722","https://openalex.org/W6679817081"],"related_works":["https://openalex.org/W2799973158","https://openalex.org/W2419153746","https://openalex.org/W3089119258","https://openalex.org/W2923327995","https://openalex.org/W2518340158","https://openalex.org/W1521050857","https://openalex.org/W3209916128","https://openalex.org/W2005967224","https://openalex.org/W2774614504","https://openalex.org/W2127148983"],"abstract_inverted_index":{"We":[0,113],"live":[1],"in":[2,119,177,202,218],"the":[3,23,26,77,96,102,132,137,178,186],"golden":[4],"age":[5],"of":[6,101,106,224,241],"distributed":[7],"computing.":[8],"Public":[9],"cloud":[10,187],"platforms":[11],"now":[12],"offer":[13],"virtually":[14],"unlimited":[15],"compute":[16],"and":[17,46,71,89,98,109,154,161,166,188,192,198,205,226],"storage":[18],"resources":[19,70],"on":[20,85],"demand.":[21],"At":[22],"same":[24],"time,":[25],"Software-as-a-Service":[27],"(SaaS)":[28],"model":[29],"brings":[30],"enterprise-class":[31],"systems":[32,41,52],"to":[33,43,55,75,124,185],"users":[34],"who":[35],"previously":[36],"could":[37],"not":[38],"afford":[39],"such":[40],"due":[42],"their":[44,83,183],"cost":[45],"complexity.":[47],"Alas,":[48],"traditional":[49],"data":[50,108,128,184],"warehousing":[51,129],"are":[53,72],"struggling":[54],"fit":[56],"into":[57],"this":[58],"new":[59,104],"environment.":[60],"For":[61,80],"one":[62],"thing,":[63,82],"they":[64],"have":[65],"been":[66,208],"designed":[67],"for":[68,131,144,164],"fixed":[69],"thus":[73],"unable":[74],"leverage":[76],"cloud's":[78,103],"elasticity.":[79],"another":[81],"dependence":[84],"complex":[86],"ETL":[87],"pipelines":[88],"physical":[90],"tuning":[91],"is":[92,136,147,171,216],"at":[93],"odds":[94],"with":[95,157],"flexibility":[97],"freshness":[99],"requirements":[100],"types":[105],"semi-structured":[107,165],"rapidly":[110],"evolving":[111],"workloads.":[112],"decided":[114],"a":[115,148,174,221],"fundamental":[116],"redesign":[117],"was":[118,123],"order.":[120],"Our":[121],"mission":[122],"build":[125],"an":[126],"enterprise-ready":[127],"solution":[130],"cloud.":[133,180],"The":[134,169,230],"result":[135],"Snowflake":[138,146,206,215],"Elastic":[139],"Data":[140],"Warehouse,":[141],"or":[142],"\"Snowflake\"":[143],"short.":[145],"multi-tenant,":[149],"transactional,":[150],"secure,":[151],"highly":[152],"scalable":[153],"elastic":[155],"system":[156,170,231],"full":[158],"SQL":[159],"support":[160],"built-in":[162],"extensions":[163],"schema-less":[167],"data.":[168,242],"offered":[172],"as":[173],"pay-as-you-go":[175],"service":[176],"Amazon":[179],"Users":[181],"upload":[182],"can":[189],"immediately":[190],"manage":[191],"query":[193],"it":[194],"using":[195],"familiar":[196],"tools":[197],"interfaces.":[199],"Implementation":[200],"began":[201],"late":[203],"2012":[204],"has":[207],"generally":[209],"available":[210],"since":[211],"June":[212],"2015.":[213],"Today,":[214],"used":[217],"production":[219],"by":[220],"growing":[222],"number":[223],"small":[225],"large":[227],"organizations":[228],"alike.":[229],"runs":[232],"several":[233],"million":[234],"queries":[235],"per":[236],"day":[237],"over":[238],"multiple":[239],"petabytes":[240]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":62},{"year":2024,"cited_by_count":52},{"year":2023,"cited_by_count":42},{"year":2022,"cited_by_count":39},{"year":2021,"cited_by_count":44},{"year":2020,"cited_by_count":23},{"year":2019,"cited_by_count":14},{"year":2018,"cited_by_count":10},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":1}],"updated_date":"2026-03-28T08:17:26.163206","created_date":"2025-10-10T00:00:00"}