데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다
현대적인 데이터 웨어하우스는 더 이상 스토리지와 컴퓨트를 긴밀하게 결합하지 않습니다. 대신 스토리지, 거버넌스, 쿼리 처리용으로 분리되어 있으면서도 서로 연결된 계층을 통해 워크플로에 적합한 도구를 유연하게 선택할 수 있습니다.클라우드 객체 스토리지에 오픈 테이블 포맷과 ClickHouse 같은 고성능 쿼리 엔진을 추가하면 데이터 레이크의 개방성을 유지하면서도 ACID 트랜잭션, 스키마 강제 적용, 빠른 분석 쿼리와 같은 데이터베이스 수준의 기능을 확보할 수 있습니다. 이러한 조합은 상호 운용 가능하고 비용 효율적인 스토리지와 고성능을 함께 제공하여 기존 분석 워크로드와 최신 AI/ML 워크로드를 모두 지원합니다.
이 아키텍처가 제공하는 이점
개방형 객체 스토리지와 오픈 테이블 포맷을 ClickHouse 쿼리 엔진과 결합하면 다음과 같은 이점을 얻을 수 있습니다.
이점
설명
일관된 테이블 업데이트
테이블 상태에 대한 원자적 커밋으로 인해 동시 쓰기가 손상되거나 일부만 기록된 데이터를 만들지 않습니다. 이는 원시 데이터 레이크의 가장 큰 문제 중 하나를 해결합니다.
스키마 관리
강제 검증과 추적되는 스키마 진화로 인해 스키마 불일치 때문에 데이터를 사용할 수 없게 되는 “데이터 늪” 문제를 방지합니다.
쿼리 성능
인덱싱, 통계, 데이터 스키핑 및 클러스터링과 같은 데이터 레이아웃 최적화를 통해 SQL 쿼리를 전용 데이터 웨어하우스에 버금가는 속도로 실행할 수 있습니다. 여기에 ClickHouse의 열 지향 엔진이 결합되면 객체 스토리지에 저장된 데이터에서도 이러한 성능이 유지됩니다.
거버넌스
카탈로그와 테이블 포맷은 행 및 컬럼 수준에서 세분화된 접근 제어와 감사를 제공하여, 기본적인 데이터 레이크에서 제한적인 보안 제어 문제를 보완합니다.
스토리지와 컴퓨트의 분리
스토리지와 컴퓨트는 범용 객체 스토리지에서 서로 독립적으로 확장되며, 이는 독점적 웨어하우스 스토리지보다 훨씬 저렴합니다. 이러한 분리는 최신 Cloud 웨어하우스에서 표준이지만, 개방형 포맷을 사용하면 데이터와 함께 확장할 컴퓨트 엔진을 어떤 것으로 할지 선택할 수 있습니다.
ClickHouse가 데이터 웨어하우징을 지원하는 방식
데이터는 스트리밍 플랫폼과 기존 웨어하우스에서 객체 스토리지를 거쳐 ClickHouse로 유입되며, 여기에서 변환 및 최적화를 거친 뒤 BI/AI 도구에 제공됩니다.
하이브리드 아키텍처: 두 세계의 장점을 모두 갖춘 방식
데이터 레이크를 쿼리하는 것에 더해, 실시간 대시보드, 운영 분석, 대화형 애플리케이션처럼 매우 낮은 지연 시간이 중요한 사용 사례를 위해 성능에 민감한 데이터를 ClickHouse의 네이티브 MergeTree 스토리지로 수집할 수 있습니다.이를 통해 계층형 데이터 전략을 구현할 수 있습니다. 자주 액세스되는 핫 데이터는 ClickHouse의 최적화된 스토리지에 저장되어 1초 미만의 쿼리 응답을 제공하고, 전체 데이터 이력은 레이크에 남아 계속 쿼리할 수 있습니다. 또한 ClickHouse 구체화된 뷰(Materialized View)를 사용해 레이크 데이터를 최적화된 테이블로 지속적으로 변환하고 집계함으로써, 두 계층을 자동으로 연결할 수 있습니다.기술적 제약이 아니라 성능 요구 사항에 따라 데이터의 저장 위치를 선택할 수 있습니다.
{"docsConfig":{"theme":"maple","$schema":"https://mintlify.com/docs.json","name":"ClickHouse Documentation","colors":{"primary":"#1c1c1c","light":"#333431","dark":"#fdff75"},"logo":{"light":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/light.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=b8a838f982def2b530a95016300bc7ec","dark":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/dark.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=563dcf3fc5bb3694597dec207c9b4ecf"},"favicon":"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/favicon.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=9a2d9de19e9259c4b5260fa5bfa26851","appearance":{"default":"dark"},"background":{"color":{"light":"#FFFFFF","dark":"#151515"}},"navbar":{},"fonts":{"family":"Inter"},"styling":{"eyebrows":"breadcrumbs","latex":true},"integrations":{"clarity":{"projectId":"xgummrwgj9"},"gtm":{"tagId":"GTM-WTNTDT7W"}},"contextual":{"options":["copy","view","download-pdf",{"title":"Set up the ClickHouse documentation MCP server","description":"Setup instructions for the ClickHouse documentation MCP server","icon":"/images/icons/icon-mcp.svg","href":"https://clickhouse.com/docs/resources/support-center/knowledge-base/setup-installation/set-up-clickhouse-documentation-mcp-server"}],"display":"toc"},"interaction":{"drilldown":false},"metadata":{"timestamp":true},"variables":{"airgap_server_tag":"26.6.1.2455","airgap_keeper_tag":"26.2.1.918","airgap_operator_tag":"1.23255.1","airgap_cr_helm_tag":"1.14.3","airgap_api_tag":"1.175.4","airgap_api_helm_tag":"1.175.4","airgap_preflight_chart_tag":"1.38.7","airgap_support_bundle_tag":"1.12.0"},"navigation":{"languages":[{"language":"en","href":""},{"language":"ar","href":"ar"},{"language":"es","href":"es"},{"language":"fr","href":"fr"},{"language":"ja","href":"ja"},{"language":"ko","href":"ko"},{"language":"pt-BR","href":"pt-BR"},{"language":"ru","href":"ru"},{"language":"zh","href":"zh"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"private-7c7dfe99","hasAudioNarration":false,"actualSubdomain":"private-7c7dfe99","customDomains":["clickhouse.com"],"gitSource":{"_id":"6ad7fa91692c7c940ff17a19","type":"github","owner":"clickhouse","repo":"clickhouse","deployBranch":"master","contentDirectory":"docs","isPrivate":false,"mountPath":"","label":""},"feedback":{"thumbs":true,"edits":true,"issues":true,"contextualFeedback":{"allowEmail":false},"agentFeedback":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED","enabled":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6afca8a72e77bcc5e00dc048","clientVersion":"0.0.4177","searchFilterCounts":[{"language":"en","tag":"Databases","count":1813},{"language":"ja","tag":"データベース","count":1792},{"language":"pt-BR","tag":"Bancos de dados","count":1792},{"language":"zh","tag":"数据库","count":1792},{"language":"ar","tag":"قواعد البيانات","count":1791},{"language":"es","tag":"Bases de datos","count":1791},{"language":"fr","tag":"Bases de données","count":1791},{"language":"ko","tag":"데이터베이스","count":1791},{"language":"ru","tag":"Базы данных","count":1791},{"language":"en","tag":"Reference","count":1582},{"language":"ar","tag":"المرجع","count":1565},{"language":"es","tag":"Referencia","count":1565},{"language":"fr","tag":"Référence","count":1565},{"language":"ja","tag":"リファレンス","count":1565},{"language":"ko","tag":"참고","count":1565},{"language":"pt-BR","tag":"Referência","count":1565},{"language":"ru","tag":"Справочник","count":1565},{"language":"zh","tag":"参考文档","count":1565},{"language":"en","tag":"Products","count":653},{"language":"es","tag":"Configuración","count":531},{"language":"ja","tag":"設定","count":531},{"language":"en","tag":"Settings","count":512},{"language":"ar","tag":"الإعدادات","count":505},{"language":"fr","tag":"Paramètres","count":505},{"language":"ko","tag":"설정","count":505},{"language":"pt-BR","tag":"Configurações","count":505},{"language":"ru","tag":"Настройки","count":505},{"language":"zh","tag":"设置","count":505},{"language":"ar","tag":"المنتجات","count":494},{"language":"es","tag":"Productos","count":494},{"language":"fr","tag":"Produits","count":494},{"language":"ja","tag":"製品","count":494},{"language":"ko","tag":"제품","count":494},{"language":"pt-BR","tag":"Produtos","count":494},{"language":"ru","tag":"Продукты","count":494},{"language":"zh","tag":"产品","count":494},{"language":"en","tag":"ClickHouse Observability","count":487},{"language":"en","tag":"Functions","count":330},{"language":"ar","tag":"الدوال","count":328},{"language":"es","tag":"Funciones","count":328},{"language":"fr","tag":"Fonctions","count":328},{"language":"ja","tag":"関数","count":328},{"language":"ko","tag":"함수","count":328},{"language":"pt-BR","tag":"Funções","count":328},{"language":"ru","tag":"Функции","count":328},{"language":"zh","tag":"函数","count":328},{"language":"en","tag":"Integrations","count":322},{"language":"ko","tag":"통합","count":296},{"language":"zh","tag":"集成","count":296},{"language":"ar","tag":"التكاملات","count":293},{"language":"es","tag":"Integraciones","count":293},{"language":"fr","tag":"Intégrations","count":293},{"language":"pt-BR","tag":"Integrações","count":293},{"language":"ru","tag":"Интеграции","count":293},{"language":"pt-BR","tag":"Recursos","count":291},{"language":"ja","tag":"インテグレーション","count":268},{"language":"en","tag":"Guides","count":265},{"language":"en","tag":"Session Settings","count":261},{"language":"ar","tag":"إعدادات session","count":260},{"language":"es","tag":"Configuración de sesión","count":260},{"language":"fr","tag":"Paramètres de session","count":260},{"language":"ja","tag":"session 設定","count":260},{"language":"ko","tag":"세션 설정","count":260},{"language":"pt-BR","tag":"Configurações de sessão","count":260},{"language":"ru","tag":"Настройки сеанса","count":260},{"language":"zh","tag":"会话设置","count":260},{"language":"en","tag":"ClickHouse Cloud","count":243},{"language":"ar","tag":"ClickHouse Cloud","count":236},{"language":"es","tag":"ClickHouse Cloud","count":236},{"language":"fr","tag":"ClickHouse Cloud","count":236},{"language":"ja","tag":"ClickHouse Cloud","count":236},{"language":"ko","tag":"ClickHouse Cloud","count":236},{"language":"pt-BR","tag":"ClickHouse Cloud","count":236},{"language":"ru","tag":"ClickHouse Cloud","count":236},{"language":"zh","tag":"ClickHouse Cloud","count":236},{"language":"ar","tag":"أدلة إرشادية","count":219},{"language":"es","tag":"Guías","count":219},{"language":"fr","tag":"Guides","count":219},{"language":"ja","tag":"ガイド","count":219},{"language":"ko","tag":"가이드","count":219},{"language":"pt-BR","tag":"Guias","count":219},{"language":"ru","tag":"Руководства","count":219},{"language":"zh","tag":"指南","count":219},{"language":"ar","tag":"الموارد","count":213},{"language":"es","tag":"Recursos","count":213},{"language":"fr","tag":"Ressources","count":213},{"language":"ja","tag":"リソース","count":213},{"language":"ko","tag":"자료","count":213},{"language":"ru","tag":"Ресурсы","count":213},{"language":"zh","tag":"资源","count":213},{"language":"default","tag":"Products","count":140},{"language":"default","tag":"ClickHouse Cloud","count":140},{"language":"default","tag":"Cloud API","count":94},{"language":"default","tag":"API reference","count":94},{"language":"default","tag":"ClickHouse Private","count":46},{"language":"default","tag":"Service","count":34},{"language":"default","tag":"Organization","count":31},{"language":"default","tag":"ClickStack","count":31},{"language":"default","tag":"How-To Guides","count":20},{"language":"default","tag":"Postgres","count":18}],"searchSettings":{"maxResults":1}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","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":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"github-push-net-diff","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":"editor-metadata","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":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"autopilot-knowledge-base","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"_site/styles.css","href":"/docs/_mintlify/custom/private-7c7dfe99/97254ae80c460cb6/_site/styles.css"},{"filePath":"snippets/components/Badges/badges_styles.css","content":".betaBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.betaBadge::before{content:\"β\";flex:0 0 auto;margin-right:8px;font-size:1rem;font-weight:600;line-height:1}a.betaBadge{color:#1D4ED8!important;text-decoration:none!important}.dark .betaBadge{background-color:#1E3A6B;color:#93C5FD}.dark a.betaBadge{color:#93C5FD!important;text-decoration:none!important}.ClickHouseSupportedBadge{background-color:#faff69;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#161517;display:inline-flex;margin-right:5px;font-size:0.875rem}.ClickHouseSupportedIcon{margin-right:8px}.ClickHouseSupportedIcon svg path{fill:#282828}.ClickHouseSupportedBadge a{color:black}.dark .ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.dark .ClickHouseSupportedBadge a{color:#161517}.dark .ClickHouseSupportedIcon svg path{fill:#161517}.cloudNotSupportedBadge{background-color:#F6E5FF;color:#660099;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.cloudNotSupportedIcon{margin-right:8px}a.cloudNotSupportedBadge{color:#660099!important;text-decoration:none!important}.cloudNotSupportedIcon svg path{stroke:#660099}.dark .cloudNotSupportedBadge{background-color:#33004D;color:#EECCFF}.dark a.cloudNotSupportedBadge{color:#EECCFF!important;text-decoration:none!important}.dark .cloudNotSupportedIcon svg path{stroke:#EECCFF}.cloudBadge{background-color:#DAE6FC;color:#061D48;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .cloudBadge{background-color:#061D48;color:#DAE6FC}.cloudIcon{margin-right:8px}.cloudIcon svg path{stroke:#061D48}.dark .cloudIcon svg path{stroke:#DAE6FC}.CommunityMaintainedBadge{background-color:#69afff;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.CommunityMaintainedIcon{margin-right:8px}.CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.CommunityMaintainedBadge a{color:#69afff}.CommunityMaintainedBadge svg path{color:#69afff}.dark .CommunityMaintainedBadge{background-color:#69afff;color:#ffffff}.dark .CommunityMaintainedBadge a{color:#ffffff}.dark .CommunityMaintainedIcon svg path{fill:#ffffff;stroke:none}.deprecatedBadge{background-color:#DFDFDF;color:#53575F;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.deprecatedIcon{margin-right:8px}.deprecatedBadge a{color:inherit}.dark .deprecatedBadge{background-color:#414141;color:#E6E7E9}.dark .deprecatedBadge a{color:inherit}.deprecatedIcon svg path{stroke:#53575F}.dark .deprecatedIcon svg path{stroke:#E6E7E9}.enterprisePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.enterprisePlanFeatureContainer p{margin:0;padding:0}.enterprisePlanFeatureBadge{background-color:#008A0B;border-style:solid;border:1px;border-color:#437EEF;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .enterprisePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .enterprisePlanFeatureBadge{background-color:#99FFA1;color:#1F1F1C}.experimentalBadge{background-color:#F3E8FF;border-radius:16px;color:#6D28D9;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.experimentalIcon{margin-right:8px}a.experimentalBadge{color:#6D28D9!important;text-decoration:none!important}.dark .experimentalBadge{background-color:#3B1D6B;color:#D8B4FE}.dark a.experimentalBadge{color:#D8B4FE!important;text-decoration:none!important}.experimentalIcon svg path{stroke:#6D28D9}.dark .experimentalIcon svg path{stroke:#D8B4FE}.PartnerBadge{background-color:#990073;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#ffffff;display:inline-flex;margin-right:5px;font-size:0.875rem}.PartnerBadgeIcon{margin-right:8px}.PartnerBadgeIcon svg path{fill:#fbc9ef;stroke:#990073}.PartnerBadge a{color:#990073}.PartnerBadge svg path{color:#990073}.dark .PartnerBadge{background-color:#990073;color:#fbeff8}.dark .PartnerBadge a{color:#fbeff8}.dark .PartnerBadgeIcon svg path{fill:#990073;stroke:#fbeff8}.privatePreviewBadge{background-color:#FEF3C7;color:#B45309;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .privatePreviewBadge{background-color:#4B3410;color:#FCD34D}.privatePreviewIcon{margin-right:8px}.privatePreviewIcon svg path{stroke:#B45309}.dark .privatePreviewIcon svg path{stroke:#FCD34D}.publicPreviewBadge{background-color:#DBEAFE;border-radius:16px;display:flex;align-items:center;padding:5px 12px;color:#1D4ED8;display:inline-flex;margin-right:5px;font-size:0.875rem}.dark .publicPreviewBadge{background-color:#1E3A6B;color:#93C5FD}.scalePlanFeatureContainer{background-color:#F6F7FA;border-radius:4px;border:1px solid #E6E7E9;padding:12px 16px;margin-bottom:8px;font-size:0.875rem}.scalePlanFeatureContainer p{margin:0;padding:0}.scalePlanFeatureBadge{background-color:#1D64EC;border-radius:16px;display:flex;align-items:center;color:#FFFFFF;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:0.875rem}.dark .scalePlanFeatureContainer{background-color:#1F1F1C;border:1px solid #414141}.dark .scalePlanFeatureBadge{background-color:#1D64EC;color:#FFFFFF}"},{"filePath":"snippets/components/ClickStackAnimation/ClickStackAnimation.css","content":".clickstack-animation-wrapper{width:100%;max-width:max-content;transition:opacity 0.3s ease}.clickstack-animation-inner{transform-origin:top left}.clickstack-grid{display:grid;width:537px;height:537px;grid-template-columns:repeat(3, 1fr);grid-template-rows:repeat(3, 1fr)}.clickstack-grid-item{position:relative;display:flex;align-items:center;justify-content:center}.clickstack-grid-column{display:flex;flex-direction:column;align-items:center}.clickstack-icon-box{display:flex;width:4rem;height:4rem;align-items:center;justify-content:center;border-radius:0.375rem;padding:1rem;flex-shrink:0;border:1px solid rgba(113, 113, 122, 0.8);background-color:#171717}.clickstack-svg-absolute{position:absolute}.clickstack-svg-left-center{left:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-right-center{right:50%;top:50%;transform:translateY(2rem)}.clickstack-svg-bottom-left{bottom:50%;left:50%;transform:translateY(-2rem)}.clickstack-svg-bottom-right{bottom:50%;right:50%;transform:translateY(-2rem)}.clickstack-logo-container{position:relative}.clickstack-logo-glow{position:absolute;inset:0;z-index:0;animation:fadeInOut 3s ease-in-out infinite;background-color:rgba(250, 255, 105, 0.6);filter:blur(40px)}.clickstack-logo-box{position:absolute;inset:0;z-index:10;display:flex;border-radius:0.5rem;border:2px solid #faff69;background-color:#262626;background-image:linear-gradient(to bottom right, rgba(250, 255, 105, 0.2), rgba(250, 255, 105, 0.4))}.clickstack-logo-svg{margin:auto}@keyframes fadeInOut{0%,100%{opacity:0.3}50%{opacity:0.8}}:is(.light) .clickstack-logo-glow{display:none}:is(.light) .clickstack-logo-box{border-color:#faff69;background-color:#000000;background-image:none}.clickstack-line-bg{stroke:#414141}.clickstack-line-animated{stroke:#faff69}:is(.light) .clickstack-line-bg{stroke:#d4d4d8}:is(.light) .clickstack-line-animated{stroke:#a1a1aa}@media (max-width: 767px){.clickstack-animation-wrapper{max-width:400px}.clickstack-grid{width:400px;height:400px}}"}],"page":{"pagePath":"ko/get-started/use-cases/data-warehousing","slug":"/ko/get-started/use-cases/data-warehousing","pageMetadata":{"slug":"/cloud/get-started/cloud/use-cases/data_lake_and_warehouse","title":"데이터 웨어하우징","description":"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다","keywords":["데이터 웨어하우스","데이터 레이크","레이크하우스","Iceberg","Delta Lake","Hudi","Parquet","오픈 테이블 포맷","하이브리드 아키텍처","사용 사례"],"sidebarTitle":"데이터 웨어하우징","doc_type":"guide","href":"/ko/get-started/use-cases/data-warehousing"},"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: \"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다\"\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{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];const ExclusiveGroup=({name,children})=>{useEffect(()=>{document.querySelectorAll(`[data-eg=\"${name}\"] details`).forEach(d=>d.setAttribute(`name`,name))});return _jsx(`div`,{\"data-eg\":name,children})};function _createMdxContent(props){const _components={a:`a`,em:`em`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Accordion,AccordionGroup,Columns,Frame,Heading,OptimizedImage,Table,Tip,_MdxComponentBoundary}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!AccordionGroup)_missingMdxReference(`AccordionGroup`,true);if(!Columns)_missingMdxReference(`Columns`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!_MdxComponentBoundary)_missingMdxReference(`_MdxComponentBoundary`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`현대적인 데이터 웨어하우스는 더 이상 스토리지와 컴퓨트를 긴밀하게 결합하지 않습니다. 대신 스토리지, 거버넌스, 쿼리 처리용으로 분리되어 있으면서도 서로 연결된 계층을 통해 워크플로에 적합한 도구를 유연하게 선택할 수 있습니다.`}),`\n`,_jsx(_components.p,{children:`클라우드 객체 스토리지에 오픈 테이블 포맷과 ClickHouse 같은 고성능 쿼리 엔진을 추가하면 데이터 레이크의 개방성을 유지하면서도 ACID 트랜잭션, 스키마 강제 적용, 빠른 분석 쿼리와 같은 데이터베이스 수준의 기능을 확보할 수 있습니다. 이러한 조합은 상호 운용 가능하고 비용 효율적인 스토리지와 고성능을 함께 제공하여 기존 분석 워크로드와 최신 AI/ML 워크로드를 모두 지원합니다.`}),`\n`,_jsx(`div`,{id:`benefits`,children:_jsx(Heading,{level:`2`,id:`이-아키텍처가-제공하는-이점`,children:`이 아키텍처가 제공하는 이점`})}),`\n`,_jsx(_components.p,{children:`개방형 객체 스토리지와 오픈 테이블 포맷을 ClickHouse 쿼리 엔진과 결합하면 다음과 같은 이점을 얻을 수 있습니다.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`이점`}),_jsx(_components.th,{children:`설명`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`일관된 테이블 업데이트`})}),_jsx(_components.td,{children:`테이블 상태에 대한 원자적 커밋으로 인해 동시 쓰기가 손상되거나 일부만 기록된 데이터를 만들지 않습니다. 이는 원시 데이터 레이크의 가장 큰 문제 중 하나를 해결합니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`스키마 관리`})}),_jsx(_components.td,{children:`강제 검증과 추적되는 스키마 진화로 인해 스키마 불일치 때문에 데이터를 사용할 수 없게 되는 “데이터 늪” 문제를 방지합니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`쿼리 성능`})}),_jsx(_components.td,{children:`인덱싱, 통계, 데이터 스키핑 및 클러스터링과 같은 데이터 레이아웃 최적화를 통해 SQL 쿼리를 전용 데이터 웨어하우스에 버금가는 속도로 실행할 수 있습니다. 여기에 ClickHouse의 열 지향 엔진이 결합되면 객체 스토리지에 저장된 데이터에서도 이러한 성능이 유지됩니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`거버넌스`})}),_jsx(_components.td,{children:`카탈로그와 테이블 포맷은 행 및 컬럼 수준에서 세분화된 접근 제어와 감사를 제공하여, 기본적인 데이터 레이크에서 제한적인 보안 제어 문제를 보완합니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`스토리지와 컴퓨트의 분리`})}),_jsxs(_components.td,{children:[`스토리지와 컴퓨트는 범용 객체 스토리지에서 서로 독립적으로 확장되며, 이는 독점적 웨어하우스 스토리지보다 훨씬 저렴합니다. 이러한 분리는 최신 Cloud 웨어하우스에서 표준이지만, 개방형 포맷을 사용하면 데이터와 함께 확장할 컴퓨트 엔진을 `,_jsx(_components.em,{children:`어떤 것`}),`으로 할지 선택할 수 있습니다.`]})]})]})]}),`\n`,_jsx(`div`,{id:`architecture`,children:_jsx(Heading,{level:`2`,id:`clickhouse가-데이터-웨어하우징을-지원하는-방식`,children:`ClickHouse가 데이터 웨어하우징을 지원하는 방식`})}),`\n`,_jsx(_components.p,{children:`데이터는 스트리밍 플랫폼과 기존 웨어하우스에서 객체 스토리지를 거쳐 ClickHouse로 유입되며, 여기에서 변환 및 최적화를 거친 뒤 BI/AI 도구에 제공됩니다.`}),`\n`,_jsxs(Columns,{cols:2,children:[_jsx(`div`,{children:_jsx(`div`,{className:`ch-image-lg`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/private-7c7dfe99/7QTz4y2EBwz3jSxR/images/cloud/onboard/discover/use_cases/data-warehousing.webp?fit=max\u0026auto=format\u0026n=7QTz4y2EBwz3jSxR\u0026q=85\u0026s=ef834c8443bb25c42e09ae4a129c03f6`,alt:`ClickHouse 데이터 웨어하우징 아키텍처`,\"data-og-width\":`2340`,width:`2340`,\"data-og-height\":`4348`,height:`4348`,\"data-path\":`images/cloud/onboard/discover/use_cases/data-warehousing.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/private-7c7dfe99/7QTz4y2EBwz3jSxR/images/cloud/onboard/discover/use_cases/data-warehousing.webp?w=280\u0026fit=max\u0026auto=format\u0026n=7QTz4y2EBwz3jSxR\u0026q=85\u0026s=1b82951f0197c31628388e6204649c6c 280w, https://mintcdn.com/private-7c7dfe99/7QTz4y2EBwz3jSxR/images/cloud/onboard/discover/use_cases/data-warehousing.webp?w=560\u0026fit=max\u0026auto=format\u0026n=7QTz4y2EBwz3jSxR\u0026q=85\u0026s=66f1b0919474980159c8f47e58bbb395 560w, https://mintcdn.com/private-7c7dfe99/7QTz4y2EBwz3jSxR/images/cloud/onboard/discover/use_cases/data-warehousing.webp?w=840\u0026fit=max\u0026auto=format\u0026n=7QTz4y2EBwz3jSxR\u0026q=85\u0026s=62932e10fb4d5ff0046e4729ca3de924 840w, https://mintcdn.com/private-7c7dfe99/7QTz4y2EBwz3jSxR/images/cloud/onboard/discover/use_cases/data-warehousing.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=7QTz4y2EBwz3jSxR\u0026q=85\u0026s=5cfc4aa4bf43b3945958a354a499a661 1100w, https://mintcdn.com/private-7c7dfe99/7QTz4y2EBwz3jSxR/images/cloud/onboard/discover/use_cases/data-warehousing.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=7QTz4y2EBwz3jSxR\u0026q=85\u0026s=102977fb73c1e6c7034fd105434854d5 1650w, https://mintcdn.com/private-7c7dfe99/7QTz4y2EBwz3jSxR/images/cloud/onboard/discover/use_cases/data-warehousing.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=7QTz4y2EBwz3jSxR\u0026q=85\u0026s=4d4345e1988ed4d1aa0dd9a865782956 2500w`})})})}),_jsx(_MdxComponentBoundary,{name:`ExclusiveGroup`,children:_jsx(ExclusiveGroup,{name:`dw-arch`,children:_jsxs(AccordionGroup,{children:[_jsxs(Accordion,{title:`데이터 수집`,defaultOpen:true,id:`%EB%8C%80%EB%9F%89-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%A1%9C%EB%93%9C%EC%97%90%EB%8A%94-%EC%9D%BC%EB%B0%98%EC%A0%81%EC%9C%BC%EB%A1%9C-s3-%EB%98%90%EB%8A%94-gcs%EC%99%80-%EA%B0%99%EC%9D%80-%EA%B0%9D%EC%B2%B4-%EC%8A%A4%ED%86%A0%EB%A6%AC%EC%A7%80%EB%A5%BC-%EC%A4%91%EA%B0%84-%EC%A0%80%EC%9E%A5%EC%86%8C%EB%A1%9C-%EC%82%AC%EC%9A%A9%ED%95%A9%EB%8B%88%EB%8B%A4.-clickhouse%EB%8A%94-parquet-%EC%9D%BD%EA%B8%B0-%EC%84%B1%EB%8A%A5%EC%9D%B4-%EB%9B%B0%EC%96%B4%EB%82%98-s3-table-engine%EC%9D%84-%EC%82%AC%EC%9A%A9%ED%95%B4-%EC%B4%88%EB%8B%B9-%EC%88%98%EC%96%B5-%ED%96%89%EC%9D%84-%EB%A1%9C%EB%93%9C%ED%95%A0-%EC%88%98-%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.-%EC%8B%A4%EC%8B%9C%EA%B0%84-%EC%8A%A4%ED%8A%B8%EB%A6%AC%EB%B0%8D%EC%9D%98-%EA%B2%BD%EC%9A%B0-clickpipes%EA%B0%80-kafka-%EB%B0%8F-confluent%EC%99%80-%EA%B0%99%EC%9D%80-%ED%94%8C%EB%9E%AB%ED%8F%BC%EC%97%90-%EC%A7%81%EC%A0%91-%EC%97%B0%EA%B2%B0%EB%90%A9%EB%8B%88%EB%8B%A4.%EB%98%90%ED%95%9C-snowflake%2C-bigquery%2C-databricks%EC%99%80-%EA%B0%99%EC%9D%80-%EA%B8%B0%EC%A1%B4-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EC%9B%A8%EC%96%B4%ED%95%98%EC%9A%B0%EC%8A%A4%EC%97%90%EC%84%9C-%EA%B0%9D%EC%B2%B4-%EC%8A%A4%ED%86%A0%EB%A6%AC%EC%A7%80%EB%A1%9C-%EB%82%B4%EB%B3%B4%EB%82%B8-%EB%92%A4-%ED%85%8C%EC%9D%B4%EB%B8%94-%EC%97%94%EC%A7%84%EC%9D%84-%ED%86%B5%ED%95%B4-clickhouse%EB%A1%9C-%EB%A1%9C%EB%93%9C%ED%95%98%EB%8A%94-%EB%B0%A9%EC%8B%9D%EC%9C%BC%EB%A1%9C-%EB%A7%88%EC%9D%B4%EA%B7%B8%EB%A0%88%EC%9D%B4%EC%85%98%ED%95%A0-%EC%88%98%EB%8F%84-%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.`,children:[_jsxs(_components.p,{children:[`대량 데이터 로드에는 일반적으로 S3 또는 GCS와 같은 객체 스토리지를 중간 저장소로 사용합니다. ClickHouse는 `,_jsx(_components.a,{href:`/ko/guides/clickhouse/data-formats/parquet`,children:`Parquet`}),` 읽기 성능이 뛰어나 `,_jsx(_components.a,{href:`/ko/reference/engines/table-engines/integrations/s3`,children:`S3 table engine`}),`을 사용해 초당 수억 행을 로드할 수 있습니다. 실시간 스트리밍의 경우 `,_jsx(_components.a,{href:`/ko/integrations/clickpipes/home`,children:`ClickPipes`}),`가 Kafka 및 Confluent와 같은 플랫폼에 직접 연결됩니다.`]}),_jsxs(_components.p,{children:[`또한 Snowflake, BigQuery, Databricks와 같은 기존 데이터 웨어하우스에서 객체 스토리지로 내보낸 뒤 `,_jsx(_components.a,{href:`/ko/reference/engines/table-engines`,children:`테이블 엔진`}),`을 통해 ClickHouse로 로드하는 방식으로 마이그레이션할 수도 있습니다.`]})]}),_jsxs(Accordion,{title:`쿼리`,id:`-1`,children:[_jsxs(_components.p,{children:[`S3 및 GCS와 같은 객체 스토리지에서 직접 데이터를 쿼리하거나, `,_jsx(_components.a,{href:`/ko/reference/engines/table-engines/integrations/iceberg`,children:`Iceberg`}),`, `,_jsx(_components.a,{href:`/ko/reference/engines/table-engines/integrations/deltalake`,children:`Delta Lake`}),`, `,_jsx(_components.a,{href:`/ko/reference/engines/table-engines/integrations/hudi`,children:`Hudi`}),`와 같은 오픈 테이블 포맷을 사용하는 데이터 레이크의 데이터를 쿼리할 수 있습니다. 직접 쿼리할 수도 있고, `,_jsx(_components.a,{href:`/ko/guides/use-cases/data-warehousing/glue-catalog`,children:`AWS Glue Catalog`}),`, `,_jsx(_components.a,{href:`/ko/guides/use-cases/data-warehousing/unity-catalog`,children:`Unity Catalog`}),`, `,_jsx(_components.a,{href:`/ko/guides/use-cases/data-warehousing/rest-catalog`,children:`Iceberg REST`}),`와 같은 데이터 카탈로그를 통해 쿼리할 수도 있습니다.`]}),_jsxs(_components.p,{children:[`ClickHouse Cloud는 기본적으로 `,_jsx(_components.a,{href:`/ko/concepts/features/performance/caches/query-cache`,children:`쿼리 캐시`}),`, `,_jsx(_components.a,{href:`/ko/concepts/features/performance/skip-indexes/skipping-indexes`,children:`스파스 인덱스`}),`, `,_jsx(_components.a,{href:`/ko/concepts/features/projections/projections`,children:`프로젝션`}),`을 제공하며, 여기에 더해 70개 이상의 파일 포맷과 날짜, 배열, JSON, 지리 정보, 대규모 근사 집계를 위한 SQL 함수도 지원합니다.`]})]}),_jsxs(Accordion,{title:`데이터 변환`,id:`-2`,children:[_jsxs(_components.p,{children:[`ClickHouse의 `,_jsx(_components.a,{href:`/ko/concepts/features/materialized-views`,children:`구체화된 뷰(Materialized Views)`}),`는 변환을 자동화합니다. 원본 테이블에 새 데이터가 삽입되면 이를 트리거로 실행되므로, 별도의 맞춤형 파이프라인을 구축하지 않아도 데이터가 들어오는 즉시 추출, 집계, 수정할 수 있습니다.`]}),_jsxs(_components.p,{children:[`더 복잡한 모델링이 필요한 경우 ClickHouse의 `,_jsx(_components.a,{href:`/ko/integrations/connectors/data-ingestion/etl-tools/dbt`,children:`dbt 통합`}),`을 사용해 버전 관리되는 SQL 모델로 변환을 정의할 수 있습니다.`]})]}),_jsx(Accordion,{title:`통합`,id:`-3`,children:_jsxs(_components.p,{children:[`ClickHouse는 `,_jsx(_components.a,{href:`/ko/integrations/connectors/data-visualization/tableau/tableau-and-clickhouse`,children:`Tableau`}),` 및 `,_jsx(_components.a,{href:`/ko/integrations/connectors/data-visualization/looker-and-clickhouse`,children:`Looker`}),`와 같은 BI 도구용 네이티브 커넥터를 제공합니다. 네이티브 커넥터가 없는 도구는 `,_jsx(_components.a,{href:`/ko/concepts/features/interfaces/mysql`,children:`MySQL wire protocol`}),`을 통해 연결할 수 있습니다. `,_jsx(_components.a,{href:`/ko/guides/use-cases/ai-ml/MCP`,children:`MCP server`}),`는 ClickHouse를 LLM과 연결해 대화형 분석을 지원하며, 유연한 `,_jsx(_components.a,{href:`/ko/concepts/features/security/access-rights`,children:`RBAC`}),` 제어를 통해 읽기 전용 테이블을 안전하게 노출할 수 있습니다.`]})})]})})})]}),`\n`,_jsx(`div`,{id:`hybrid-architecture-the-best-of-both-worlds`,children:_jsx(Heading,{level:`2`,id:`하이브리드-아키텍처-두-세계의-장점을-모두-갖춘-방식`,children:`하이브리드 아키텍처: 두 세계의 장점을 모두 갖춘 방식`})}),`\n`,_jsxs(_components.p,{children:[`데이터 레이크를 쿼리하는 것에 더해, 실시간 대시보드, 운영 분석, 대화형 애플리케이션처럼 매우 낮은 지연 시간이 중요한 사용 사례를 위해 성능에 민감한 데이터를 ClickHouse의 네이티브 `,_jsx(_components.a,{href:`/ko/reference/engines/table-engines/mergetree-family/mergetree`,children:`MergeTree`}),` 스토리지로 수집할 수 있습니다.`]}),`\n`,_jsx(_components.p,{children:`이를 통해 계층형 데이터 전략을 구현할 수 있습니다. 자주 액세스되는 핫 데이터는 ClickHouse의 최적화된 스토리지에 저장되어 1초 미만의 쿼리 응답을 제공하고, 전체 데이터 이력은 레이크에 남아 계속 쿼리할 수 있습니다. 또한 ClickHouse 구체화된 뷰(Materialized View)를 사용해 레이크 데이터를 최적화된 테이블로 지속적으로 변환하고 집계함으로써, 두 계층을 자동으로 연결할 수 있습니다.`}),`\n`,_jsx(_components.p,{children:`기술적 제약이 아니라 성능 요구 사항에 따라 데이터의 저장 위치를 선택할 수 있습니다.`}),`\n`,_jsxs(Tip,{children:[_jsx(_components.p,{children:_jsx(_components.strong,{children:`ClickHouse Academy`})}),_jsxs(_components.p,{children:[`자세히 알아보려면 무료 `,_jsx(_components.a,{href:`https://clickhouse.com/learn/data-warehousing`,children:`Data Warehousing with ClickHouse`}),` 과정을 수강하세요.`]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{ExclusiveGroup,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":{"slug":"/cloud/get-started/cloud/use-cases/data_lake_and_warehouse","title":"데이터 웨어하우징","description":"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다","keywords":["데이터 웨어하우스","데이터 레이크","레이크하우스","Iceberg","Delta Lake","Hudi","Parquet","오픈 테이블 포맷","하이브리드 아키텍처","사용 사례"],"sidebarTitle":"데이터 웨어하우징","doc_type":"guide","href":"/ko/get-started/use-cases/data-warehousing"}}},"mdxSourceWithNoJs":null,"noJsSplices":[[150,341,")=>null;function _cr"]]},"mdxExtracts":{"tableOfContents":[{"title":"이 아키텍처가 제공하는 이점","slug":"이-아키텍처가-제공하는-이점","depth":2,"children":[]},{"title":"ClickHouse가 데이터 웨어하우징을 지원하는 방식","slug":"clickhouse가-데이터-웨어하우징을-지원하는-방식","depth":2,"children":[]},{"title":"하이브리드 아키텍처: 두 세계의 장점을 모두 갖춘 방식","slug":"하이브리드-아키텍처-두-세계의-장점을-모두-갖춘-방식","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/private-7c7dfe99/f11c6dde2c89bd05/_site/customizations/ask-ai-button.js","/docs/_mintlify/custom/private-7c7dfe99/39eb0ad87fa3adc8/_site/customizations/clickhouse-sql-highlight.js","/docs/_mintlify/custom/private-7c7dfe99/f2f887f569696d41/_site/customizations/clickhouse-sql-lexer-wasm.js","/docs/_mintlify/custom/private-7c7dfe99/dce387fc81a6edfe/_site/customizations/custom-footer.js","/docs/_mintlify/custom/private-7c7dfe99/240e3ba1823c3bae/_site/customizations/galaxy.js","/docs/_mintlify/custom/private-7c7dfe99/c00e6cbded147615/_site/customizations/inkeep-init.js","/docs/_mintlify/custom/private-7c7dfe99/ad7415752a665282/_site/customizations/kapa-init.js","/docs/_mintlify/custom/private-7c7dfe99/4b6201cbf0ed537b/_site/customizations/nav-icon-preload.js","/docs/_mintlify/custom/private-7c7dfe99/10c01e58e00a0bb5/_site/customizations/navbar-cta.js","/docs/_mintlify/custom/private-7c7dfe99/f75dab9369f45602/_site/customizations/raise-issue-link.js","/docs/_mintlify/custom/private-7c7dfe99/a97e716bfafb62fd/_site/customizations/scroll-reset.js","/docs/_mintlify/custom/private-7c7dfe99/bb66ab6ab59dfc53/_site/customizations/settings-legacy-redirect.js","/docs/_mintlify/custom/private-7c7dfe99/12d3dce08bc08c9a/_site/customizations/settings-legacy-routes/format-settings.js","/docs/_mintlify/custom/private-7c7dfe99/715db8995ae06543/_site/customizations/settings-legacy-routes/mergetree-settings.js","/docs/_mintlify/custom/private-7c7dfe99/768b733920354bca/_site/customizations/settings-legacy-routes/server-settings.js","/docs/_mintlify/custom/private-7c7dfe99/0d81a9808360f8e6/_site/customizations/settings-legacy-routes/session-settings.js","/docs/_mintlify/custom/private-7c7dfe99/23432dedeeb54e07/_site/customizations/tab-nav.js","/docs/_mintlify/custom/private-7c7dfe99/5c7ce50607c95a70/_site/customizations/webterminal.js","/docs/_mintlify/custom/private-7c7dfe99/5e0b81ad15d8ede0/_site/customizations/cloud-sidebar-ad.js","/docs/_mintlify/custom/private-7c7dfe99/f017ff835af2f729/_site/customizations/section-ticker.js","/docs/_mintlify/custom/private-7c7dfe99/53fc41cb46bfef11/_site/customizations/clickstack-availability.js"],"subdomain":"private-7c7dfe99","siteName":"ClickHouse Documentation","title":"데이터 웨어하우징 - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/get-started/use-cases/data-warehousing","matchLevel":1},"ar":{"href":"/ar/get-started/use-cases/data-warehousing","matchLevel":1},"es":{"href":"/es/get-started/use-cases/data-warehousing","matchLevel":1},"fr":{"href":"/fr/get-started/use-cases/data-warehousing","matchLevel":1},"ja":{"href":"/ja/get-started/use-cases/data-warehousing","matchLevel":1},"ko":{"href":"/ko/get-started/use-cases/data-warehousing","matchLevel":0},"pt-BR":{"href":"/pt-BR/get-started/use-cases/data-warehousing","matchLevel":1},"ru":{"href":"/ru/get-started/use-cases/data-warehousing","matchLevel":1},"zh":{"href":"/zh/get-started/use-cases/data-warehousing","matchLevel":1}}},"originalFileLocation":"ko/get-started/use-cases/data-warehousing.mdx","locale":"ko"},"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=\"dark\"}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=\"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다\">\u003cmeta data-mint-head name=\"application-name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_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=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"데이터 웨어하우징 - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=Use+cases\u0026amp;title=%EB%8D%B0%EC%9D%B4%ED%84%B0+%EC%9B%A8%EC%96%B4%ED%95%98%EC%9A%B0%EC%A7%95\u0026amp;description=%EB%8D%B0%EC%9D%B4%ED%84%B0+%EB%A0%88%EC%9D%B4%ED%81%AC%EC%9D%98+%EC%9C%A0%EC%97%B0%EC%84%B1%EA%B3%BC+ClickHouse+Cloud%EC%9D%98+%EC%84%B1%EB%8A%A5%EC%9D%84+%EA%B2%B0%ED%95%A9%ED%95%B4+%EC%B5%9C%EC%8B%A0+%EB%8D%B0%EC%9D%B4%ED%84%B0+%EC%9B%A8%EC%96%B4%ED%95%98%EC%9A%B0%EC%8A%A4+%EC%95%84%ED%82%A4%ED%85%8D%EC%B2%98%EB%A5%BC+%EA%B5%AC%EC%B6%95%ED%95%A9%EB%8B%88%EB%8B%A4\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=40508d3256c8ecc8f1553ce2f68403ad955fcff50f9819ecac77e81d1da1fd10\">\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=\"데이터 웨어하우징 - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=Use+cases\u0026amp;title=%EB%8D%B0%EC%9D%B4%ED%84%B0+%EC%9B%A8%EC%96%B4%ED%95%98%EC%9A%B0%EC%A7%95\u0026amp;description=%EB%8D%B0%EC%9D%B4%ED%84%B0+%EB%A0%88%EC%9D%B4%ED%81%AC%EC%9D%98+%EC%9C%A0%EC%97%B0%EC%84%B1%EA%B3%BC+ClickHouse+Cloud%EC%9D%98+%EC%84%B1%EB%8A%A5%EC%9D%84+%EA%B2%B0%ED%95%A9%ED%95%B4+%EC%B5%9C%EC%8B%A0+%EB%8D%B0%EC%9D%B4%ED%84%B0+%EC%9B%A8%EC%96%B4%ED%95%98%EC%9A%B0%EC%8A%A4+%EC%95%84%ED%82%A4%ED%85%8D%EC%B2%98%EB%A5%BC+%EA%B5%AC%EC%B6%95%ED%95%A9%EB%8B%88%EB%8B%A4\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=40508d3256c8ecc8f1553ce2f68403ad955fcff50f9819ecac77e81d1da1fd10\">\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=\"/docs/mintlify-assets/_mintlify/favicons/private-7c7dfe99/4UShO1VxIGDRhyfj/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#1c1c1c\">\u003clink data-mint-head rel=\"canonical\" href=\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/ko/get-started/use-cases/data-warehousing.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/get-started/use-cases/data-warehousing\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/get-started/use-cases/data-warehousing\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://clickhouse.com/#organization\",\"name\":\"ClickHouse Documentation\",\"url\":\"https://clickhouse.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/private-7c7dfe99/h2VHbIjccjT9ClSc/_site/logo/light.svg?fit=max\u0026auto=format\u0026n=h2VHbIjccjT9ClSc\u0026q=85\u0026s=b8a838f982def2b530a95016300bc7ec\"}},{\"@type\":\"WebSite\",\"@id\":\"https://clickhouse.com/docs#website\",\"name\":\"ClickHouse Documentation\",\"url\":\"https://clickhouse.com/docs\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing#webpage\",\"url\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing\",\"name\":\"데이터 웨어하우징\",\"description\":\"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Get started\",\"item\":\"https://clickhouse.com/docs/ko/get-started\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use cases\",\"item\":\"https://clickhouse.com/docs/ko/get-started/use-cases/overview\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"데이터 웨어하우징\",\"item\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing#article\",\"headline\":\"데이터 웨어하우징\",\"name\":\"데이터 웨어하우징\",\"description\":\"데이터 레이크의 유연성과 ClickHouse Cloud의 성능을 결합해 최신 데이터 웨어하우스 아키텍처를 구축합니다\",\"url\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/ko/get-started/use-cases/data-warehousing#webpage\"},\"keywords\":\"데이터 웨어하우스, 데이터 레이크, 레이크하우스, Iceberg, Delta Lake, Hudi, Parquet, 오픈 테이블 포맷, 하이브리드 아키텍처, 사용 사례\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"},\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"}}]}\u003c/script>","agentPointerHref":"/docs/ko/get-started/use-cases/data-warehousing.md","siteName":"ClickHouse Documentation","nav":{"global":null,"languages":[{"language":"en","pages":[{"title":"en","href":"/get-started/use-cases/data-warehousing"}]},{"language":"ar","pages":[{"title":"ar","href":"/ar/get-started/use-cases/data-warehousing"}]},{"language":"es","pages":[{"title":"es","href":"/es/get-started/use-cases/data-warehousing"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/get-started/use-cases/data-warehousing"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/get-started/use-cases/data-warehousing"}]},{"language":"ko","tabs":[{"tab":"홈","pages":[{"title":"홈","href":"/ko"}]},{"tab":"데이터베이스","menu":[{"item":"ClickHouse","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse.svg","href":"#"},{"item":"Get started","pages":[{"group":"Get started","icon":"/images/menu-icon-lightning.svg","pages":[{"title":"ClickHouse 시작하기","sidebarTitle":"개요","href":"/ko/get-started"},{"group":"빠른 시작","expanded":false,"pages":[{"sidebarTitle":"빠른 시작 둘러보기","title":"빠른 시작 둘러보기","mode":"custom","href":"/ko/get-started/quickstarts/home"},{"group":"모든 사용 사례","expanded":false,"pages":[{"sidebarTitle":"Cloud 빠른 시작","title":"ClickHouse Cloud 빠른 시작","href":"/ko/get-started/setup/cloud"},{"sidebarTitle":"Cloud 연결 정보 확인","title":"Cloud 연결 정보 확인","href":"/ko/get-started/quickstarts/obtain-your-cloud-connection-details"},{"sidebarTitle":"clickhouse-client로 ClickHouse Cloud에 데이터 삽입","title":"clickhouse-client로 ClickHouse Cloud에 데이터 삽입","href":"/ko/get-started/quickstarts/insert-data-using-clickhouse-client"},{"sidebarTitle":"ClickHouse에서 테이블 생성","title":"ClickHouse에서 테이블 생성","href":"/ko/get-started/quickstarts/creating-tables"},{"sidebarTitle":"ClickHouse 데이터 선택","title":"ClickHouse 데이터 선택","href":"/ko/get-started/quickstarts/writing-queries"},{"sidebarTitle":"첫 번째 MergeTree 테이블 만들기","title":"첫 번째 MergeTree 테이블 만들기","href":"/ko/get-started/quickstarts/create-your-first-mergetree-table"}]},{"group":"실시간 분석","expanded":false,"pages":[{"sidebarTitle":"첫 materialized view 만들기","title":"첫 materialized view 만들기","href":"/ko/get-started/quickstarts/create-your-first-materialized-view"},{"sidebarTitle":"첫 번째 프로젝션 만들기","title":"첫 번째 프로젝션 만들기","href":"/ko/get-started/quickstarts/create-your-first-projection"}]},{"group":"데이터 웨어하우징","expanded":false,"pages":[{"sidebarTitle":"ClickHouse Cloud에서 Iceberg 카탈로그를 연결하는 방법","title":"ClickHouse Cloud에서 Iceberg 카탈로그를 연결하는 방법","href":"/ko/get-started/quickstarts/connect-your-iceberg-catalog"},{"sidebarTitle":"ClickHouse 데이터 업데이트 및 삭제","title":"ClickHouse 데이터 업데이트 및 삭제","href":"/ko/get-started/quickstarts/mutations"}]},{"group":"관측성","expanded":false,"pages":[{"sidebarTitle":"ClickHouse에서 맵 타입 사용하기","title":"ClickHouse에서 맵 타입 사용하기","href":"/ko/get-started/quickstarts/working-with-the-map-type"}]}]},{"group":"Introduction","expanded":true,"pages":[{"sidebarTitle":"ClickHouse란 무엇입니까?","title":"ClickHouse란 무엇입니까?","href":"/ko/get-started/about/intro"},{"sidebarTitle":"ClickHouse는 왜 이렇게 빠를까요?","title":"ClickHouse는 왜 이렇게 빠를까요?","href":"/ko/get-started/about/why-clickhouse-is-so-fast"},{"sidebarTitle":"ClickHouse가 특별한 이유","title":"ClickHouse의 고유한 특징","href":"/ko/get-started/about/distinctive-features"}]},{"group":"Use cases","expanded":true,"pages":[{"title":"사용 사례","sidebarTitle":"개요","href":"/ko/get-started/use-cases/overview"},{"title":"실시간 분석","sidebarTitle":"실시간 분석","href":"/ko/get-started/use-cases/real-time-analytics"},{"title":"관측성","description":"분산 애플리케이션의 관측성, 모니터링, 로깅, 시스템 성능 분석에 ClickHouse Cloud를 활용합니다","sidebarTitle":"관측성","href":"/ko/get-started/use-cases/observability"},{"title":"데이터 웨어하우징","sidebarTitle":"데이터 웨어하우징","href":"/ko/get-started/use-cases/data-warehousing"},{"title":"에이전트형 분석","description":"ClickHouse가 에이전트형 분석을 지원하는 방법을 알아보세요","sidebarTitle":"에이전트형 분석","href":"/ko/get-started/use-cases/agentic-analytics"}]},{"sidebarTitle":"배포 모드","title":"배포 모드","href":"/ko/get-started/about/deployment-modes"}]},{"group":"Setup","icon":"/images/menu-icon-gear.svg","expanded":true,"pages":[{"sidebarTitle":"설치","title":"설치 안내","href":"/ko/get-started/setup/install"},{"sidebarTitle":"Cloud 빠른 시작","title":"ClickHouse Cloud 빠른 시작","href":"/ko/get-started/setup/cloud"},{"group":"Self-managed","expanded":true,"pages":[{"title":"자가 관리형 설치","sidebarTitle":"개요","href":"/ko/get-started/setup/self-managed/overview"},{"group":"Local development","pages":[{"sidebarTitle":"빠른 설치","title":"빠른 설치","href":"/ko/get-started/setup/self-managed/quick-install"},{"sidebarTitle":"clickhousectl (CLI)","title":"ClickHouse CLI로 설치","href":"/ko/get-started/setup/self-managed/clickhousectl"},{"sidebarTitle":"Docker","title":"Docker를 사용해 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/docker"},{"sidebarTitle":"소스 및 CI 빌드","title":"소스 및 CI 빌드","href":"/ko/get-started/setup/self-managed/advanced"}]},{"group":"Production server","pages":[{"sidebarTitle":"Debian/Ubuntu","title":"Debian/Ubuntu에 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/debian-ubuntu"},{"sidebarTitle":"Redhat/CentOS","title":"rpm 기반 Linux 배포판에 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/redhat"},{"sidebarTitle":"NixOS","title":"NixOS에서 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/nixos"},{"sidebarTitle":"기타 Linux","title":"tgz 아카이브를 사용해 ClickHouse 설치","href":"/ko/get-started/setup/self-managed/other-linux"}]}]}]},{"group":"Sample datasets","icon":"/images/menu-icon-database.svg","expanded":true,"pages":[{"sidebarTitle":"개요","title":"튜토리얼 및 예제 데이터셋","href":"/ko/get-started/sample-datasets/index"},{"sidebarTitle":"ClickHouse Playground","title":"ClickHouse Playground","href":"/ko/get-started/sample-datasets/playground"},{"group":"Benchmarks","pages":[{"sidebarTitle":"AMPLab 빅 데이터 벤치마크","title":"AMPLab Big Data Benchmark","href":"/ko/get-started/sample-datasets/amplab-benchmark"},{"sidebarTitle":"Brown University 벤치마크","title":"Brown University 벤치마크","href":"/ko/get-started/sample-datasets/brown-benchmark"},{"sidebarTitle":"Criteo 1TB 클릭 로그","title":"Criteo의 1TB 클릭 로그","href":"/ko/get-started/sample-datasets/criteo"},{"title":"Join Order Benchmark (JOB)","sidebarTitle":"JOB","href":"/ko/get-started/sample-datasets/job"},{"sidebarTitle":"Star Schema Benchmark","title":"Star Schema Benchmark (SSB, 2009)","href":"/ko/get-started/sample-datasets/star-schema"},{"title":"TPC-DS (2012)","sidebarTitle":"TPC-DS","href":"/ko/get-started/sample-datasets/tpcds"},{"title":"TPC-H (1999)","sidebarTitle":"TPC-H","href":"/ko/get-started/sample-datasets/tpch"}]},{"group":"Vector search \u0026 embeddings","pages":[{"sidebarTitle":"dbpedia 데이터셋","title":"dbpedia 데이터셋","href":"/ko/get-started/sample-datasets/dbpedia"},{"sidebarTitle":"Hacker News 벡터 검색 데이터셋","title":"Hacker News 벡터 검색 데이터셋","href":"/ko/get-started/sample-datasets/hacker-news-vector-search"},{"sidebarTitle":"Laion-400M 데이터셋","title":"Laion-400M 데이터셋","href":"/ko/get-started/sample-datasets/laion"},{"sidebarTitle":"LAION 5B 데이터셋","title":"LAION 5B 데이터셋","href":"/ko/get-started/sample-datasets/laion5b"}]},{"group":"Web \u0026 social analytics","pages":[{"sidebarTitle":"Amazon 고객 리뷰","title":"Amazon 고객 리뷰","href":"/ko/get-started/sample-datasets/amazon-reviews"},{"sidebarTitle":"익명화된 웹 분석","title":"익명화된 웹 분석","href":"/ko/get-started/sample-datasets/anon-web-analytics-metrica"},{"sidebarTitle":"GitHub 리포지토리","title":"GitHub 데이터로 ClickHouse에서 쿼리 작성하기","href":"/ko/get-started/sample-datasets/github"},{"sidebarTitle":"GitHub 이벤트","title":"GitHub 이벤트 데이터셋","href":"/ko/get-started/sample-datasets/github-events"},{"sidebarTitle":"Hacker News","title":"Hacker News 데이터셋","href":"/ko/get-started/sample-datasets/hacker-news"},{"sidebarTitle":"Stack Overflow","title":"ClickHouse로 Stack Overflow 데이터 분석","href":"/ko/get-started/sample-datasets/stackoverflow"},{"sidebarTitle":"YouTube 싫어요","title":"YouTube 싫어요 데이터셋","href":"/ko/get-started/sample-datasets/youtube-dislikes"}]},{"group":"Geo \u0026 location","pages":[{"sidebarTitle":"기지국","title":"기지국 데이터셋을 활용한 지리 공간 분석","href":"/ko/get-started/sample-datasets/cell-towers"},{"sidebarTitle":"Foursquare OS Places","title":"Foursquare OS Places 데이터셋","href":"/ko/get-started/sample-datasets/foursquare-os-places"},{"sidebarTitle":"뉴욕 택시 데이터","title":"뉴욕 택시 데이터셋을 활용한 지리공간 분석","href":"/ko/get-started/sample-datasets/nyc-taxi"}]},{"group":"Time series \u0026 sensors","pages":[{"sidebarTitle":"환경 센서 데이터","title":"환경 센서 데이터","href":"/ko/get-started/sample-datasets/environmental-sensors"},{"sidebarTitle":"NOAA Global Historical Climatology Network ","title":"NOAA Global Historical Climatology Network","href":"/ko/get-started/sample-datasets/noaa"},{"sidebarTitle":"대만 과거 기상 데이터셋","title":"대만 과거 기상 데이터셋","href":"/ko/get-started/sample-datasets/tw-weather"},{"sidebarTitle":"WikiStat","title":"WikiStat","href":"/ko/get-started/sample-datasets/wikistat"}]},{"group":"Public records \u0026 open data","pages":[{"sidebarTitle":"COVID-19 오픈 데이터","title":"COVID-19 오픈 데이터","href":"/ko/get-started/sample-datasets/covid19"},{"sidebarTitle":"New York Public Library \"What's on the Menu?\" 데이터셋","title":"New York Public Library \"What's on the Menu?\" 데이터셋","href":"/ko/get-started/sample-datasets/menus"},{"sidebarTitle":"NYPD 신고 데이터","title":"NYPD 신고 데이터","href":"/ko/get-started/sample-datasets/nypd-complaint-data"},{"sidebarTitle":"OnTime 항공편 데이터","title":"OnTime","href":"/ko/get-started/sample-datasets/ontime"},{"sidebarTitle":"영국 부동산 가격","title":"영국 부동산 가격 데이터 분석 쿼리","href":"/ko/get-started/sample-datasets/uk-price-paid"}]}]},{"group":"Migrate","icon":"/images/caret-double-right.svg","expanded":true,"pages":[{"sidebarTitle":"개요","title":"ClickHouse로 데이터 마이그레이션","href":"/ko/get-started/migrate/overview"},{"group":"PostgreSQL","pages":[{"title":"PostgreSQL과 ClickHouse 비교","sidebarTitle":"개요","href":"/ko/get-started/migrate/postgres/overview"},{"group":"Migration guide","pages":[{"title":"데이터 마이그레이션","sidebarTitle":"1부","href":"/ko/get-started/migrate/postgres/migration-guide/migration-guide-part1"},{"title":"PostgreSQL 쿼리 재작성하기","sidebarTitle":"2부","href":"/ko/get-started/migrate/postgres/migration-guide/migration-guide-part2"},{"title":"데이터 모델링 기법","sidebarTitle":"제3부","href":"/ko/get-started/migrate/postgres/migration-guide/migration-guide-part3"}]},{"title":"부록","href":"/ko/get-started/migrate/postgres/appendix"}]},{"group":"BigQuery","pages":[{"title":"ClickHouse Cloud와 BigQuery 비교","sidebarTitle":"개요","href":"/ko/get-started/migrate/bigquery/overview"},{"title":"BigQuery에서 ClickHouse Cloud로 마이그레이션","sidebarTitle":"마이그레이션 가이드","href":"/ko/get-started/migrate/bigquery/migrating-to-clickhouse-cloud"},{"sidebarTitle":"데이터 로드","title":"BigQuery에서 ClickHouse로 데이터 로드","href":"/ko/get-started/migrate/bigquery/loading-data"}]},{"group":"Snowflake","pages":[{"sidebarTitle":"개요","title":"Snowflake에서 ClickHouse로의 마이그레이션","href":"/ko/get-started/migrate/snowflake/overview"},{"sidebarTitle":"마이그레이션 가이드","title":"Snowflake에서 ClickHouse로 마이그레이션","href":"/ko/get-started/migrate/snowflake/migration-guide"},{"sidebarTitle":"SQL 번역 참고","title":"Snowflake에서 ClickHouse로 마이그레이션","href":"/ko/get-started/migrate/snowflake/sql-translation-reference"}]},{"group":"Elasticsearch","pages":[{"sidebarTitle":"개요","title":"Elasticsearch에서 ClickHouse로 마이그레이션","href":"/ko/get-started/migrate/elastic/overview"}]},{"group":"Redshift","pages":[{"sidebarTitle":"개요","title":"ClickHouse Cloud와 Amazon Redshift 비교","href":"/ko/get-started/migrate/redshift/overview"},{"sidebarTitle":"마이그레이션 가이드","title":"Amazon Redshift에서 ClickHouse로 이전하기 가이드","href":"/ko/get-started/migrate/redshift/migration-guide"},{"sidebarTitle":"SQL 변환 참고","title":"Amazon Redshift SQL 변환 가이드","href":"/ko/get-started/migrate/redshift/sql-translation-reference"}]},{"group":"OSS to Cloud","pages":[{"sidebarTitle":"remoteSecure 사용하기","title":"remoteSecure를 사용하여 자가 관리형 ClickHouse와 ClickHouse Cloud 간에 마이그레이션하기","href":"/ko/get-started/migrate/oss-to-cloud/clickhouse-to-cloud"},{"sidebarTitle":"BACKUP 및 RESTORE 사용","title":"Backup 명령을 사용한 자가 관리형 ClickHouse에서 ClickHouse Cloud로의 마이그레이션","href":"/ko/get-started/migrate/oss-to-cloud/oss-to-cloud-backup-restore"}]},{"group":"Other methods","pages":[{"sidebarTitle":"clickhouse-local 사용","title":"clickhouse-local을 사용해 ClickHouse로 마이그레이션하기","href":"/ko/get-started/migrate/other-methods/clickhouse-local-etl"},{"sidebarTitle":"타사 ETL 도구 사용","title":"타사 ETL 도구 사용","href":"/ko/get-started/migrate/other-methods/etl-tool-to-clickhouse"},{"title":"클라우드 객체 스토리지에서 ClickHouse Cloud로 데이터 이동","href":"/ko/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]}]},{"item":"가이드","pages":[{"title":"가이드","href":"/ko/guides/clickhouse"}]},{"item":"개념","pages":[{"title":"개념","href":"/ko/concepts"}]},{"item":"참고","pages":[{"title":"참고","href":"/ko/reference/home"}]},{"item":"ClickHouse Managed Postgres","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-postgres.svg","pages":[{"title":"ClickHouse Managed Postgres","href":"/ko/products/managed-postgres/overview"}]}]},{"tab":"제품","menu":[{"item":"배포","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickHouse Cloud","pages":[{"title":"ClickHouse Cloud","href":"/ko/products/cloud/getting-started/cloud-get-started"}]},{"item":"BYOC","pages":[{"title":"BYOC","href":"/ko/products/cloud/guides/infrastructure/deployment-options/byoc/overview"}]},{"item":"애플리케이션","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","pages":[{"title":"ClickStack","href":"/ko/clickstack"}]},{"item":"Agents","pages":[{"title":"Agents","href":"/ko/agents"}]},{"item":"AI 엔지니어링","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/logo-langfuse.svg","href":"https://langfuse.com/docs"},{"item":"보안","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/integrations/logos/runreveal.webp","href":"https://docs.runreveal.com/"},{"item":"오픈 소스","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","pages":[{"title":"ClickStack","href":"/ko/clickstack"}]},{"item":"chDB","pages":[{"title":"chDB","href":"/ko/chdb"}]},{"item":"Kubernetes Operator","pages":[{"title":"Kubernetes Operator","href":"/ko/products/kubernetes-operator/overview"}]},{"item":"LibreChat","href":"https://www.librechat.ai/docs"}],"pages":[{"title":"제품","href":"/ko/products/cloud/getting-started/cloud-get-started"}]},{"tab":"통합","menu":[{"item":"생태계","pages":[{"title":"생태계","href":"/ko/integrations/home"}]},{"item":"ClickPipes","pages":[{"title":"ClickPipes","href":"/ko/integrations/clickpipes/home"}]},{"item":"언어 클라이언트","pages":[{"title":"언어 클라이언트","href":"/ko/integrations/language-clients"}]},{"item":"커넥터","pages":[{"title":"커넥터","href":"/ko/integrations/connectors/data-sources"}]}],"pages":[{"title":"통합","href":"/ko/integrations/home"}]},{"tab":"자료","menu":[{"item":"지원 센터","pages":[{"title":"지원 센터","href":"/ko/resources/support-center/home"}]},{"item":"개발 및 기여","pages":[{"title":"개발 및 기여","href":"/ko/resources/develop-contribute/introduction/developer-instruction"}]},{"item":"변경 내역","dropdowns":[{"dropdown":"Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"Cloud","href":"/ko/resources/changelogs/cloud"}]},{"dropdown":"오픈 소스","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-server.svg","pages":[{"title":"오픈 소스","href":"/ko/resources/changelogs/oss/2026"}]}]},{"item":"소개","pages":[{"title":"소개","href":"/ko/resources/about"}]}],"pages":[{"title":"자료","href":"/ko/resources/support-center/home"}]}]},{"language":"pt-BR","pages":[{"title":"pt-BR","href":"/pt-BR/get-started/use-cases/data-warehousing"}]},{"language":"ru","pages":[{"title":"ru","href":"/ru/get-started/use-cases/data-warehousing"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/get-started/use-cases/data-warehousing"}]}]},"basePath":"","title":"데이터 웨어하우징 - ClickHouse Documentation","deploymentId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","buildId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-C6xGbawq.js","DynamicMarkdown-C_R66tyH.js","zoom-image-lightbox-Cr7fyDws.js","lightbox-handle-r17bVUz3.js"]}