--- title: Operational Data Vault on Snowflake: Hybrid Satellite Tables description: Snowflake's hybrid tables, known as HTAP (Hybrid Transactional/Analytical Processing) tables, combine OLTP and OLAP features to provide real-time analytics and... canonical: https://daily.dev/posts/operational-data-vault-on-snowflake-hybrid-satellite-tables-cbj7xnxbp twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Operational Data Vault on Snowflake: Hybrid Satellite Tables | daily.dev og:description: Snowflake's hybrid tables, known as HTAP (Hybrid Transactional/Analytical Processing) tables, combine OLTP and OLAP features to provide real-time analytics and... og:url: https://daily.dev/posts/operational-data-vault-on-snowflake-hybrid-satellite-tables-cbj7xnxbp og:image: https://api.daily.dev/og/posts/cBj7xnXBp.png og:image:alt: Operational Data Vault on Snowflake: Hybrid Satellite Tables og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Operational Data Vault on Snowflake: Hybrid Satellite Tables **[Snowflake Community](https://daily.dev/sources/snowflake_comm)** · 9 min read · 0 upvotes · 0 comments ## Summary Snowflake's hybrid tables, known as HTAP (Hybrid Transactional/Analytical Processing) tables, combine OLTP and OLAP features to provide real-time analytics and historization capabilities. These tables eliminate the need to ship data to another database for OLTP purposes and allow for enriching data with other Snowflake table types. They can be used in a data vault architecture to reduce latency between OLTP and OLAP data, improving performance and enabling further automation. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#olap](https://daily.dev/tags/olap), [#snowflake](https://daily.dev/tags/snowflake) [View this post on daily.dev](https://daily.dev/posts/operational-data-vault-on-snowflake-hybrid-satellite-tables-cbj7xnxbp) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Operational Data Vault on Snowflake: Hybrid Satellite Tables","url":"https://daily.dev/posts/operational-data-vault-on-snowflake-hybrid-satellite-tables-cbj7xnxbp","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/operational-data-vault-on-snowflake-hybrid-satellite-tables-cbj7xnxbp"},"datePublished":"2024-05-10T21:23:39.886Z","dateModified":"2025-09-06T02:43:26.861Z","description":"Snowflake's hybrid tables, known as HTAP (Hybrid Transactional/Analytical Processing) tables, combine OLTP and OLAP features to provide real-time analytics and...","image":"https://miro.medium.com/v2/da:true/resize:fit:1097/1*xfLYKe9hqCaCZjTxzQqc-A.gif","thumbnailUrl":"https://miro.medium.com/v2/da:true/resize:fit:1097/1*xfLYKe9hqCaCZjTxzQqc-A.gif","isAccessibleForFree":true,"articleSection":"Snowflake Community","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Snowflake Community","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/3eb5260f70bb4653be0f9581c0d937c8","url":"https://daily.dev/sources/snowflake_comm"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/operational-data-vault-on-snowflake-hybrid-satellite-tables-cbj7xnxbp","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"olap,snowflake","timeRequired":"PT9M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Snowflake Community","item":"https://daily.dev/sources/snowflake_comm"},{"@type":"ListItem","position":3,"name":"Operational Data Vault on Snowflake: Hybrid Satellite Tables"}]} ```