{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Pragun's Data Handbook","colors":{"primary":"#1B4546","light":"#99CA3C","dark":"#1B4546"},"favicon":"/pb-circle-green.svg","logo":{"light":"https://mintcdn.com/pragunbhutani/MWic8cE7avT97Zyi/images/logo/logo-with-wordmark-dark.svg?fit=max\u0026auto=format\u0026n=MWic8cE7avT97Zyi\u0026q=85\u0026s=8d24259e3ad0ec7d48b59e49c41cbc9a","dark":"https://mintcdn.com/pragunbhutani/MWic8cE7avT97Zyi/images/logo/logo-with-wordmark-light.svg?fit=max\u0026auto=format\u0026n=MWic8cE7avT97Zyi\u0026q=85\u0026s=494f7fd9d105ae60ada868da0a77749d"},"background":{"decoration":"grid","color":{"light":"#FEFFFC","dark":null}},"navbar":{"links":[{"label":"About Me","href":"https://pragunbhutani.com"},{"label":"My Blog","href":"https://pragunbhutani.substack.com"}],"primary":null},"footer":{"socials":{"x":"https://x.com/pragunbhutani","github":"https://github.com/pragunbhutani","linkedin":"https://www.linkedin.com/in/pragunbhutani"}},"integrations":{"ga4":{"measurementId":"G-JLRSZJQ7MZ"},"intercom":{"appId":"sz321lh9"}},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"pragunbhutani","hasAudioNarration":false,"actualSubdomain":"pragunbhutani","customDomains":["handbook.pragunbhutani.com"],"gitSource":{"type":"github","owner":"pragunbhutani","repo":"datahandbook-mintlify","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6a21e64b572b750f6b6f9eba","collectionId":"197b76a3-cd8c-4cf3-9be9-0918243de3f6","schemaVersion":"v2"},"feedback":{"thumbs":true,"edits":true},"entitlements":{},"buildId":"6ae921902e86bd0c182fbeb2:success","clientVersion":"0.0.4076","searchFilterCounts":[{"language":"default","tag":"Get Started","count":14},{"language":"default","tag":"Analytics Engineering","count":12},{"language":"default","tag":"Data Infrastructure","count":12},{"language":"default","tag":"Recommended Tools","count":8},{"language":"default","tag":"DBT Modeling Example","count":7},{"language":"default","tag":"Common Data Terms","count":7},{"language":"default","tag":"Startup Data Journey","count":6},{"language":"default","tag":"Product Analytics","count":6},{"language":"default","tag":"Good Conventions","count":3},{"language":"default","tag":"Tracking Plans","count":2}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"comment-mode","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"data-infrastructure/recommended-tools/data-warehouse","slug":"/data-infrastructure/recommended-tools/data-warehouse","pageMetadata":{"title":"Data Warehouse","description":"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.","icon":"database","href":"/data-infrastructure/recommended-tools/data-warehouse"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{jsx:_jsx}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const{Heading}={..._provideComponents(),...props.components};if(!Heading)_missingMdxReference(`Heading`,true);return _jsx(Heading,{level:`3`,id:`coming-soon`,children:`Coming Soon`})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Data Warehouse","description":"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.","icon":"database","href":"/data-infrastructure/recommended-tools/data-warehouse"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Coming Soon","slug":"coming-soon","depth":3,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"pragunbhutani","siteName":"Pragun's Data Handbook","title":"Data Warehouse - Pragun's Data Handbook","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-07T03:42:43.228Z","originalFileLocation":"data-infrastructure/recommended-tools/data-warehouse.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Pragun\u0026#x27;s Data Handbook\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Data Warehouse - Pragun\u0026#x27;s Data Handbook\">\u003cmeta data-mint-head property=\"og:description\" content=\"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Pragun\u0026#x27;s Data Handbook\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://pragunbhutani.mintlify.site/_mintlify/api/og/v2?division=Recommended+Tools\u0026amp;title=Data+Warehouse\u0026amp;description=Data+warehouse+tools+help+you+store+large+volumes+of+data+from+various+sources+and+run+complex+queries+on+it.\u0026amp;theme=2c384ea998a65ab751d4497e\u0026amp;signature=7ff0df60aa4b4fdadb636248649e0a71cf1f681159eed26b80ae9c2278f74672\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Data Warehouse - Pragun\u0026#x27;s Data Handbook\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://pragunbhutani.mintlify.site/_mintlify/api/og/v2?division=Recommended+Tools\u0026amp;title=Data+Warehouse\u0026amp;description=Data+warehouse+tools+help+you+store+large+volumes+of+data+from+various+sources+and+run+complex+queries+on+it.\u0026amp;theme=2c384ea998a65ab751d4497e\u0026amp;signature=7ff0df60aa4b4fdadb636248649e0a71cf1f681159eed26b80ae9c2278f74672\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/pragunbhutani/ez1sX4oh0cXkuUS8/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Pragun\u0026#x27;s Data Handbook\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#1B4546\">\u003clink data-mint-head rel=\"canonical\" href=\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/data-infrastructure/recommended-tools/data-warehouse.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://handbook.pragunbhutani.com/#organization\",\"name\":\"Pragun's Data Handbook\",\"url\":\"https://handbook.pragunbhutani.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/pragunbhutani/MWic8cE7avT97Zyi/images/logo/logo-with-wordmark-dark.svg?fit=max\u0026auto=format\u0026n=MWic8cE7avT97Zyi\u0026q=85\u0026s=8d24259e3ad0ec7d48b59e49c41cbc9a\"}},{\"@type\":\"WebSite\",\"@id\":\"https://handbook.pragunbhutani.com#website\",\"name\":\"Pragun's Data Handbook\",\"url\":\"https://handbook.pragunbhutani.com\",\"publisher\":{\"@id\":\"https://handbook.pragunbhutani.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse#webpage\",\"url\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse\",\"name\":\"Data Warehouse\",\"description\":\"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.\",\"dateModified\":\"2026-01-07T03:42:43.228Z\",\"isPartOf\":{\"@id\":\"https://handbook.pragunbhutani.com#website\"},\"breadcrumb\":{\"@id\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Pragun's Data Handbook\",\"item\":\"https://handbook.pragunbhutani.com\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Warehouse\",\"item\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse#article\",\"headline\":\"Data Warehouse\",\"name\":\"Data Warehouse\",\"description\":\"Data warehouse tools help you store large volumes of data from various sources and run complex queries on it.\",\"url\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse\",\"mainEntityOfPage\":{\"@id\":\"https://handbook.pragunbhutani.com/data-infrastructure/recommended-tools/data-warehouse#webpage\"},\"dateModified\":\"2026-01-07T03:42:43.228Z\",\"publisher\":{\"@id\":\"https://handbook.pragunbhutani.com/#organization\"},\"isPartOf\":{\"@id\":\"https://handbook.pragunbhutani.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Pragun's Data Handbook\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Pragun's Data Handbook","nav":{"global":null,"tabs":[{"tab":"Get Started","pages":[{"title":"Get Started","href":"/home/introduction"}]},{"tab":"Analytics Engineering","pages":[{"title":"Analytics Engineering","href":"/analytics-engineering/introduction"}]},{"tab":"Product Analytics","pages":[{"title":"Product Analytics","href":"/product-analytics/introduction"}]},{"tab":"Data Infrastructure","groups":[{"group":"Data Infrastructure","pages":[{"title":"Introduction","icon":"house","href":"/data-infrastructure/introduction"},{"title":"Starters Guide","icon":"book","description":"A step-by-step guide to help you set up your data infrastructure from scratch.","href":"/data-infrastructure/starters-guide"}]},{"group":"Recommended Tools","pages":[{"title":"Data Warehouse","icon":"database","href":"/data-infrastructure/recommended-tools/data-warehouse"},{"title":"Data Ingestion","description":"Data ingestion tools help you collect data from various sources and load it into your data warehouse.","icon":"download","href":"/data-infrastructure/recommended-tools/ingestion"},{"title":"Data Modeling","icon":"chart-network","href":"/data-infrastructure/recommended-tools/data-modeling"},{"title":"Orchestration","icon":"gears","href":"/data-infrastructure/recommended-tools/orchestration"},{"title":"Business Intelligence","icon":"chart-line","href":"/data-infrastructure/recommended-tools/business-intelligence"},{"title":"Product Analytics","icon":"hand-pointer","href":"/data-infrastructure/recommended-tools/product-analytics"},{"title":"Consumer Data Platform","icon":"users","href":"/data-infrastructure/recommended-tools/consumer-data-platform"},{"title":"Reverse ETL","icon":"upload","href":"/data-infrastructure/recommended-tools/reverse-etl"}]}]}]},"basePath":"","title":"Data Warehouse - Pragun's Data Handbook","buildId":"dpl_8LJbrAiZvr1K98WQNZXCyY5AvT34","deploymentId":"dpl_8LJbrAiZvr1K98WQNZXCyY5AvT34","dynamics":[],"chunks":[]}
