Move data from cloud object storage to ClickHouse Cloud
Moving data from object storage to ClickHouse Cloud
If you use a Cloud Object Storage as a data lake and wish to import this data into ClickHouse Cloud,
or if your current database system is able to directly offload data into a Cloud Object Storage, then you can use one of the
table functions for migrating data stored in Cloud Object Storage into a ClickHouse Cloud table:
If your current database system isn’t able to directly offload data into a Cloud Object Storage, you could use a third-party ETL/ELT tool or clickhouse-local for moving data
from you current database system to Cloud Object Storage, in order to migrate that data in a second step into a ClickHouse Cloud table.Although this is a two steps process (offload data into a Cloud Object Storage, then load into ClickHouse), the advantage is that this
scales to petabytes thanks to a solid ClickHouse Cloud support of highly-parallel reads from Cloud Object Storage.
Also you can leverage sophisticated and compressed formats like Parquet.There is a blog article with concrete code examples showing how you can get data into ClickHouse Cloud using S3.
{"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_operator_private_chart_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":"6aff4af2e02d768905ce0845","clientVersion":"0.0.4227","searchFilterCounts":[{"language":"en","tag":"Databases","count":1811},{"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":674},{"language":"es","tag":"Configuración","count":531},{"language":"ja","tag":"設定","count":531},{"language":"ar","tag":"المنتجات","count":513},{"language":"es","tag":"Productos","count":513},{"language":"fr","tag":"Produits","count":513},{"language":"ja","tag":"製品","count":513},{"language":"ko","tag":"제품","count":513},{"language":"pt-BR","tag":"Produtos","count":513},{"language":"ru","tag":"Продукты","count":513},{"language":"zh","tag":"产品","count":513},{"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":"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":323},{"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":"ClickHouse Cloud","count":264},{"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":"ar","tag":"ClickHouse Cloud","count":255},{"language":"es","tag":"ClickHouse Cloud","count":255},{"language":"fr","tag":"ClickHouse Cloud","count":255},{"language":"ja","tag":"ClickHouse Cloud","count":255},{"language":"ko","tag":"ClickHouse Cloud","count":255},{"language":"pt-BR","tag":"ClickHouse Cloud","count":255},{"language":"ru","tag":"ClickHouse Cloud","count":255},{"language":"zh","tag":"ClickHouse Cloud","count":255},{"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":125},{"language":"default","tag":"ClickHouse Cloud","count":125},{"language":"default","tag":"Cloud API","count":79},{"language":"default","tag":"API reference","count":79},{"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":"Reference","count":10}],"searchSettings":{"maxResults":1}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":true,"toggles":[],"googleFontsInlined":false},"customCss":[{"filePath":"_site/styles.css","href":"/docs/_mintlify/custom/private-7c7dfe99/9ce922f719fc2597/_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":"get-started/migrate/other-methods/object-storage-to-clickhouse","slug":"/get-started/migrate/other-methods/object-storage-to-clickhouse","pageMetadata":{"title":"Move data from cloud object storage to ClickHouse Cloud","description":"Moving data from object storage to ClickHouse Cloud","keywords":["object storage","s3","azure blob","gcs","migration"],"slug":"/integrations/migration/object-storage-to-clickhouse","doc_type":"guide","href":"/get-started/migrate/other-methods/object-storage-to-clickhouse"},"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: \"Moving data from object storage to 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];function _createMdxContent(props){const _components={a:`a`,li:`li`,p:`p`,ul:`ul`,..._provideComponents(),...props.components},{Frame,OptimizedImage}=_components;if(!Frame)_missingMdxReference(`Frame`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);return _jsxs(_Fragment,{children:[_jsx(`div`,{className:`ch-image-md`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/migration/object-storage-01.webp?fit=max\u0026auto=format\u0026n=6s0zAeps_NYZmK2e\u0026q=85\u0026s=dae7f196aa0c25dc05c2d4f6905a9071`,alt:`Migrating Self-managed ClickHouse`,\"data-og-width\":`666`,width:`666`,\"data-og-height\":`431`,height:`431`,\"data-path\":`images/integrations/migration/object-storage-01.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/migration/object-storage-01.webp?w=280\u0026fit=max\u0026auto=format\u0026n=6s0zAeps_NYZmK2e\u0026q=85\u0026s=522b9e6d47ba246ce5091a991ff10337 280w, https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/migration/object-storage-01.webp?w=560\u0026fit=max\u0026auto=format\u0026n=6s0zAeps_NYZmK2e\u0026q=85\u0026s=30ef8fc8771b62deb8aaae9bf28e5e1c 560w, https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/migration/object-storage-01.webp?w=840\u0026fit=max\u0026auto=format\u0026n=6s0zAeps_NYZmK2e\u0026q=85\u0026s=e211ac3b7ab1cf3c2924ee78408ac911 840w, https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/migration/object-storage-01.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=6s0zAeps_NYZmK2e\u0026q=85\u0026s=2086a622eac47e1a6d3525248c59a044 1100w, https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/migration/object-storage-01.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=6s0zAeps_NYZmK2e\u0026q=85\u0026s=d8d5e34d29770301d5fa41ac5503d151 1650w, https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/migration/object-storage-01.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=6s0zAeps_NYZmK2e\u0026q=85\u0026s=ef73af4fb02cb034b65ba11ca186a5ca 2500w`})})}),`\n`,_jsx(_components.p,{children:`If you use a Cloud Object Storage as a data lake and wish to import this data into ClickHouse Cloud,\nor if your current database system is able to directly offload data into a Cloud Object Storage, then you can use one of the\ntable functions for migrating data stored in Cloud Object Storage into a ClickHouse Cloud table:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/reference/functions/table-functions/s3`,children:`s3`}),` or `,_jsx(_components.a,{href:`/reference/functions/table-functions/s3Cluster`,children:`s3Cluster`})]}),`\n`,_jsx(_components.li,{children:_jsx(_components.a,{href:`/reference/functions/table-functions/gcs`,children:`gcs`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.a,{href:`/reference/functions/table-functions/azureBlobStorage`,children:`azureBlobStorage`})}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`If your current database system isn’t able to directly offload data into a Cloud Object Storage, you could use a `,_jsx(_components.a,{href:`/get-started/migrate/other-methods/etl-tool-to-clickhouse`,children:`third-party ETL/ELT tool`}),` or `,_jsx(_components.a,{href:`/get-started/migrate/other-methods/clickhouse-local-etl`,children:`clickhouse-local`}),` for moving data\nfrom you current database system to Cloud Object Storage, in order to migrate that data in a second step into a ClickHouse Cloud table.`]}),`\n`,_jsxs(_components.p,{children:[`Although this is a two steps process (offload data into a Cloud Object Storage, then load into ClickHouse), the advantage is that this\nscales to petabytes thanks to a `,_jsx(_components.a,{href:`https://clickhouse.com/blog/getting-data-into-clickhouse-part-3-s3`,children:`solid ClickHouse Cloud`}),` support of highly-parallel reads from Cloud Object Storage.\nAlso you can leverage sophisticated and compressed formats like `,_jsx(_components.a,{href:`/reference/formats/Parquet/Parquet`,children:`Parquet`}),`.`]}),`\n`,_jsxs(_components.p,{children:[`There is a `,_jsx(_components.a,{href:`https://clickhouse.com/blog/getting-data-into-clickhouse-part-3-s3`,children:`blog article`}),` with concrete code examples showing how you can get data into ClickHouse Cloud using S3.`]})]})}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":"Move data from cloud object storage to ClickHouse Cloud","description":"Moving data from object storage to ClickHouse Cloud","keywords":["object storage","s3","azure blob","gcs","migration"],"slug":"/integrations/migration/object-storage-to-clickhouse","doc_type":"guide","href":"/get-started/migrate/other-methods/object-storage-to-clickhouse"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"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/bd3cb49fae80807e/_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/5fd0936388a00cd0/_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":"Move data from cloud object storage to ClickHouse Cloud - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":0},"ar":{"href":"/ar/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1},"es":{"href":"/es/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1},"fr":{"href":"/fr/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1},"ja":{"href":"/ja/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1},"ko":{"href":"/ko/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1},"pt-BR":{"href":"/pt-BR/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1},"ru":{"href":"/ru/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1},"zh":{"href":"/zh/get-started/migrate/other-methods/object-storage-to-clickhouse","matchLevel":1}}},"originalFileLocation":"get-started/migrate/other-methods/object-storage-to-clickhouse.mdx","locale":"en"},"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=\"Moving data from object storage to 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=\"Move data from cloud object storage to ClickHouse Cloud - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Moving data from object storage to 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/get-started/migrate/other-methods/object-storage-to-clickhouse\">\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=Other+methods\u0026amp;title=Move+data+from+cloud+object+storage+to+ClickHouse+Cloud\u0026amp;description=Moving+data+from+object+storage+to+ClickHouse+Cloud\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=7bba6d6f0f7d6a104d2341587af19c17b6b343e3f3b3b5d041a8302fadf95270\">\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=\"Move data from cloud object storage to ClickHouse Cloud - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Moving data from object storage to ClickHouse Cloud\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=Other+methods\u0026amp;title=Move+data+from+cloud+object+storage+to+ClickHouse+Cloud\u0026amp;description=Moving+data+from+object+storage+to+ClickHouse+Cloud\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=7bba6d6f0f7d6a104d2341587af19c17b6b343e3f3b3b5d041a8302fadf95270\">\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/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/get-started/migrate/other-methods/object-storage-to-clickhouse.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/get-started/migrate/other-methods/object-storage-to-clickhouse\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse\">\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/get-started/migrate/other-methods/object-storage-to-clickhouse#webpage\",\"url\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse\",\"name\":\"Move data from cloud object storage to ClickHouse Cloud\",\"description\":\"Moving data from object storage to ClickHouse Cloud\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Migrate\",\"item\":\"https://clickhouse.com/docs/get-started/migrate/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Other methods\",\"item\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/clickhouse-local-etl\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Move data from cloud object storage to ClickHouse Cloud\",\"item\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse#article\",\"headline\":\"Move data from cloud object storage to ClickHouse Cloud\",\"name\":\"Move data from cloud object storage to ClickHouse Cloud\",\"description\":\"Moving data from object storage to ClickHouse Cloud\",\"url\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/get-started/migrate/other-methods/object-storage-to-clickhouse#webpage\"},\"keywords\":\"object storage, s3, azure blob, gcs, migration\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"},\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"}}]}\u003c/script>","agentPointerHref":"/docs/get-started/migrate/other-methods/object-storage-to-clickhouse.md","siteName":"ClickHouse Documentation","nav":{"global":null,"languages":[{"language":"en","tabs":[{"tab":"Home","pages":[{"title":"Home","href":""}]},{"tab":"Databases","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":"Get started with ClickHouse","sidebarTitle":"Overview","href":"/get-started"},{"group":"Quickstarts","expanded":false,"pages":[{"sidebarTitle":"Explore quickstarts","title":"Quickstarts explorer","mode":"custom","href":"/get-started/quickstarts/home"},{"group":"All use cases","expanded":false,"pages":[{"sidebarTitle":"Cloud quickstart","title":"ClickHouse Cloud quick start","href":"/get-started/setup/cloud"},{"sidebarTitle":"Obtain your Cloud connection details","title":"Obtain your Cloud connection details","href":"/get-started/quickstarts/obtain-your-cloud-connection-details"},{"sidebarTitle":"Insert data into ClickHouse Cloud using clickhouse-client","title":"Insert data into ClickHouse Cloud using clickhouse-client","href":"/get-started/quickstarts/insert-data-using-clickhouse-client"},{"sidebarTitle":"Creating tables in ClickHouse","title":"Creating tables in ClickHouse","href":"/get-started/quickstarts/creating-tables"},{"sidebarTitle":"Selecting ClickHouse Data","title":"Selecting ClickHouse Data","href":"/get-started/quickstarts/writing-queries"},{"sidebarTitle":"Create your first MergeTree table","title":"Create your first MergeTree table","href":"/get-started/quickstarts/create-your-first-mergetree-table"}]},{"group":"Real-time analytics","expanded":false,"pages":[{"sidebarTitle":"Create your first materialized view","title":"Create your first materialized view","href":"/get-started/quickstarts/create-your-first-materialized-view"},{"sidebarTitle":"Create your first projection","title":"Create your first projection","href":"/get-started/quickstarts/create-your-first-projection"}]},{"group":"Data warehousing","expanded":false,"pages":[{"sidebarTitle":"How to connect your Iceberg catalog in ClickHouse Cloud","title":"How to connect your Iceberg catalog in ClickHouse Cloud","href":"/get-started/quickstarts/connect-your-iceberg-catalog"},{"sidebarTitle":"Updating and deleting ClickHouse data","title":"Updating and deleting ClickHouse data","href":"/get-started/quickstarts/mutations"}]},{"group":"Observability","expanded":false,"pages":[{"sidebarTitle":"Working with the Map type in ClickHouse","title":"Working with the Map type in ClickHouse","href":"/get-started/quickstarts/working-with-the-map-type"}]}]},{"group":"Introduction","expanded":true,"pages":[{"sidebarTitle":"What is ClickHouse?","title":"What is ClickHouse?","href":"/get-started/about/intro"},{"sidebarTitle":"Why is ClickHouse so fast?","title":"Why is ClickHouse so fast?","href":"/get-started/about/why-clickhouse-is-so-fast"},{"sidebarTitle":"Why is ClickHouse unique?","title":"Distinctive Features of ClickHouse","href":"/get-started/about/distinctive-features"}]},{"group":"Use cases","expanded":true,"pages":[{"title":"Use cases","sidebarTitle":"Overview","href":"/get-started/use-cases/overview"},{"title":"Choose a service for your workload","sidebarTitle":"Choose a service","href":"/get-started/use-cases/choosing-a-service"},{"title":"Real-time analytics","sidebarTitle":"Real-time analytics","href":"/get-started/use-cases/real-time-analytics"},{"title":"Observability","sidebarTitle":"Observability","href":"/get-started/use-cases/observability"},{"title":"Data warehousing","sidebarTitle":"Data warehousing","href":"/get-started/use-cases/data-warehousing"}]},{"sidebarTitle":"Deployment modes","title":"Deployment modes","href":"/get-started/about/deployment-modes"}]},{"group":"Setup","icon":"/images/menu-icon-gear.svg","expanded":true,"pages":[{"sidebarTitle":"Install","title":"Installation instructions","href":"/get-started/setup/install"},{"sidebarTitle":"Cloud quickstart","title":"ClickHouse Cloud quick start","href":"/get-started/setup/cloud"},{"group":"Self-managed","expanded":true,"pages":[{"title":"Self-managed install","sidebarTitle":"Overview","href":"/get-started/setup/self-managed/overview"},{"group":"Local development","pages":[{"sidebarTitle":"Quick install","title":"Quick install","href":"/get-started/setup/self-managed/quick-install"},{"sidebarTitle":"clickhousectl (CLI)","title":"Install with the ClickHouse CLI","href":"/get-started/setup/self-managed/clickhousectl"},{"sidebarTitle":"Docker","title":"Install ClickHouse using Docker","href":"/get-started/setup/self-managed/docker"},{"sidebarTitle":"Source \u0026 CI builds","title":"Source \u0026 CI builds","href":"/get-started/setup/self-managed/advanced"}]},{"group":"Production server","pages":[{"sidebarTitle":"Debian/Ubuntu","title":"Install ClickHouse on Debian/Ubuntu","href":"/get-started/setup/self-managed/debian-ubuntu"},{"sidebarTitle":"Redhat/CentOS","title":"Install ClickHouse on rpm-based Linux distributions","href":"/get-started/setup/self-managed/redhat"},{"sidebarTitle":"NixOS","title":"Install ClickHouse on NixOS","href":"/get-started/setup/self-managed/nixos"},{"sidebarTitle":"Other Linux","title":"Install ClickHouse using tgz archives","href":"/get-started/setup/self-managed/other-linux"}]}]}]},{"group":"Sample datasets","icon":"/images/menu-icon-database.svg","expanded":true,"pages":[{"sidebarTitle":"Overview","title":"Tutorials and example datasets","href":"/get-started/sample-datasets/index"},{"sidebarTitle":"ClickHouse playground","title":"ClickHouse playground","href":"/get-started/sample-datasets/playground"},{"group":"Benchmarks","pages":[{"sidebarTitle":"AMPLab big data benchmark","title":"AMPLab Big Data Benchmark","href":"/get-started/sample-datasets/amplab-benchmark"},{"sidebarTitle":"Brown university benchmark","title":"Brown University Benchmark","href":"/get-started/sample-datasets/brown-benchmark"},{"sidebarTitle":"Criteo 1TB click logs","title":"Terabyte click logs from Criteo","href":"/get-started/sample-datasets/criteo"},{"title":"Join Order Benchmark (JOB)","sidebarTitle":"JOB","href":"/get-started/sample-datasets/job"},{"sidebarTitle":"Star Schema Benchmark","title":"Star Schema Benchmark (SSB, 2009)","href":"/get-started/sample-datasets/star-schema"},{"title":"TPC-DS (2012)","sidebarTitle":"TPC-DS","href":"/get-started/sample-datasets/tpcds"},{"title":"TPC-H (1999)","sidebarTitle":"TPC-H","href":"/get-started/sample-datasets/tpch"}]},{"group":"Vector search \u0026 embeddings","pages":[{"sidebarTitle":"dbpedia dataset","title":"dbpedia dataset","href":"/get-started/sample-datasets/dbpedia"},{"sidebarTitle":"Hacker News vector search dataset","title":"Hacker News vector search dataset","href":"/get-started/sample-datasets/hacker-news-vector-search"},{"sidebarTitle":"Laion-400M dataset","title":"Laion-400M dataset","href":"/get-started/sample-datasets/laion"},{"sidebarTitle":"LAION 5B dataset","title":"LAION 5B dataset","href":"/get-started/sample-datasets/laion5b"}]},{"group":"Web \u0026 social analytics","pages":[{"sidebarTitle":"Amazon customer reviews","title":"Amazon customer review","href":"/get-started/sample-datasets/amazon-reviews"},{"sidebarTitle":"Anonymized web analytics","title":"Anonymized web analytics","href":"/get-started/sample-datasets/anon-web-analytics-metrica"},{"sidebarTitle":"Github repo","title":"Writing queries in ClickHouse using GitHub data","href":"/get-started/sample-datasets/github"},{"sidebarTitle":"GitHub events","title":"GitHub events dataset","href":"/get-started/sample-datasets/github-events"},{"sidebarTitle":"Hacker news","title":"Hacker News dataset","href":"/get-started/sample-datasets/hacker-news"},{"sidebarTitle":"Stack Overflow","title":"Analyzing Stack Overflow data with ClickHouse","href":"/get-started/sample-datasets/stackoverflow"},{"sidebarTitle":"YouTube dislikes","title":"YouTube dataset of dislikes","href":"/get-started/sample-datasets/youtube-dislikes"}]},{"group":"Geo \u0026 location","pages":[{"sidebarTitle":"Cell towers","title":"Geospatial analysis with the cell tower dataset","href":"/get-started/sample-datasets/cell-towers"},{"sidebarTitle":"Foursquare OS Places","title":"Foursquare OS Places dataset","href":"/get-started/sample-datasets/foursquare-os-places"},{"sidebarTitle":"New York taxi data","title":"Geospatial analysis with the New York taxi dataset","href":"/get-started/sample-datasets/nyc-taxi"}]},{"group":"Time series \u0026 sensors","pages":[{"sidebarTitle":"Environmental sensors data","title":"Environmental sensors data","href":"/get-started/sample-datasets/environmental-sensors"},{"sidebarTitle":"NOAA Global Historical Climatology Network ","title":"NOAA Global Historical Climatology Network","href":"/get-started/sample-datasets/noaa"},{"sidebarTitle":"Taiwan historical weather datasets","title":"Taiwan historical weather datasets","href":"/get-started/sample-datasets/tw-weather"},{"sidebarTitle":"WikiStat","title":"WikiStat","href":"/get-started/sample-datasets/wikistat"}]},{"group":"Public records \u0026 open data","pages":[{"sidebarTitle":"COVID-19 open-data","title":"COVID-19 open data","href":"/get-started/sample-datasets/covid19"},{"sidebarTitle":"New York Public Library \"what's on the menu?\" dataset","title":"New York Public Library \"What's on the Menu?\" dataset","href":"/get-started/sample-datasets/menus"},{"sidebarTitle":"NYPD complaint data","title":"NYPD complaint data","href":"/get-started/sample-datasets/nypd-complaint-data"},{"sidebarTitle":"OnTime airline flight data","title":"OnTime","href":"/get-started/sample-datasets/ontime"},{"sidebarTitle":"UK property prices","title":"Analytical queries on UK property price data","href":"/get-started/sample-datasets/uk-price-paid"}]}]},{"group":"Migrate","icon":"/images/caret-double-right.svg","expanded":true,"pages":[{"sidebarTitle":"Overview","title":"Migrating Data into ClickHouse","href":"/get-started/migrate/overview"},{"group":"PostgreSQL","pages":[{"title":"Comparing PostgreSQL and ClickHouse","sidebarTitle":"Overview","href":"/get-started/migrate/postgres/overview"},{"group":"Migration guide","pages":[{"title":"Migrating data","sidebarTitle":"Part 1","href":"/get-started/migrate/postgres/migration-guide/migration-guide-part1"},{"title":"Rewriting PostgreSQL queries","sidebarTitle":"Part 2","href":"/get-started/migrate/postgres/migration-guide/migration-guide-part2"},{"title":"Data modeling techniques","sidebarTitle":"Part 3","href":"/get-started/migrate/postgres/migration-guide/migration-guide-part3"}]},{"title":"Appendix","href":"/get-started/migrate/postgres/appendix"}]},{"group":"BigQuery","pages":[{"title":"Comparing ClickHouse Cloud and BigQuery","sidebarTitle":"Overview","href":"/get-started/migrate/bigquery/overview"},{"title":"Migrating from BigQuery to ClickHouse Cloud","sidebarTitle":"Migration guide","href":"/get-started/migrate/bigquery/migrating-to-clickhouse-cloud"},{"sidebarTitle":"Loading data","title":"Loading data from BigQuery to ClickHouse","href":"/get-started/migrate/bigquery/loading-data"}]},{"group":"Snowflake","pages":[{"sidebarTitle":"Overview","title":"Snowflake to ClickHouse migration","href":"/get-started/migrate/snowflake/overview"},{"sidebarTitle":"Migration guide","title":"Migrate from Snowflake to ClickHouse","href":"/get-started/migrate/snowflake/migration-guide"},{"sidebarTitle":"SQL translation reference","title":"Migrating from Snowflake to ClickHouse","href":"/get-started/migrate/snowflake/sql-translation-reference"}]},{"group":"Elasticsearch","pages":[{"sidebarTitle":"Overview","title":"Migrate from Elasticsearch to ClickHouse","href":"/get-started/migrate/elastic/overview"}]},{"group":"Redshift","pages":[{"sidebarTitle":"Overview","title":"Comparing ClickHouse Cloud and Amazon Redshift","href":"/get-started/migrate/redshift/overview"},{"sidebarTitle":"Migration guide","title":"Amazon Redshift to ClickHouse migration guide","href":"/get-started/migrate/redshift/migration-guide"},{"sidebarTitle":"SQL translation reference","title":"Amazon Redshift SQL translation guide","href":"/get-started/migrate/redshift/sql-translation-reference"}]},{"group":"OSS to Cloud","pages":[{"sidebarTitle":"Using remoteSecure","title":"Migrating between self-managed ClickHouse and ClickHouse Cloud using remoteSecure","href":"/get-started/migrate/oss-to-cloud/clickhouse-to-cloud"},{"sidebarTitle":"Using BACKUP and RESTORE","title":"Migrating from self-managed ClickHouse to ClickHouse Cloud using backup commands","href":"/get-started/migrate/oss-to-cloud/oss-to-cloud-backup-restore"}]},{"group":"Other methods","pages":[{"sidebarTitle":"Using clickhouse-local","title":"Migrating to ClickHouse using clickhouse-local","href":"/get-started/migrate/other-methods/clickhouse-local-etl"},{"sidebarTitle":"Using a third-party ETL tool","title":"Using a third-party ETL tool","description":"Page describing how to use a third-party ETL tool with ClickHouse","href":"/get-started/migrate/other-methods/etl-tool-to-clickhouse"},{"title":"Move data from cloud object storage to ClickHouse Cloud","href":"/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]}]},{"item":"Guides","pages":[{"title":"Guides","href":"/guides/clickhouse"}]},{"item":"Concepts","pages":[{"title":"Concepts","href":"/concepts"}]},{"item":"Reference","pages":[{"title":"Reference","href":"/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":"/products/managed-postgres/overview"}]}]},{"tab":"Products","menu":[{"item":"Deployments","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":"/products/cloud/getting-started/cloud-get-started"}]},{"item":"BYOC","pages":[{"title":"BYOC","href":"/products/cloud/guides/infrastructure/deployment-options/byoc/overview"}]},{"item":"Applications","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickHouse Observability","dropdowns":[{"dropdown":"ClickHouse Observability","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-observability.svg","pages":[{"title":"ClickHouse Observability","href":"/clickstack/observability"}]},{"dropdown":"ClickStack (OSS)","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/clickstack/clickstack-icon-dark.svg","pages":[{"title":"ClickStack (OSS)","href":"/clickstack"}]}]},{"item":"Agents","pages":[{"title":"Agents","href":"/agents"}]},{"item":"AI Engineering","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/logo-langfuse.svg","href":"https://langfuse.com/docs"},{"item":"Security","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/integrations/logos/runreveal.webp","href":"https://docs.runreveal.com/"},{"item":"Open source","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","pages":[{"title":"ClickStack","href":"/clickstack"}]},{"item":"chDB","pages":[{"title":"chDB","href":"/chdb"}]},{"item":"Kubernetes Operator","pages":[{"title":"Kubernetes Operator","href":"/products/kubernetes-operator/overview"}]},{"item":"LibreChat","href":"https://www.librechat.ai/docs"}],"pages":[{"title":"Products","href":"/products/cloud/getting-started/cloud-get-started"}]},{"tab":"Integrations","menu":[{"item":"Ecosystem","pages":[{"title":"Ecosystem","href":"/integrations/home"}]},{"item":"ClickPipes","pages":[{"title":"ClickPipes","href":"/integrations/clickpipes/home"}]},{"item":"Language clients","pages":[{"title":"Language clients","href":"/integrations/language-clients"}]},{"item":"Connectors","pages":[{"title":"Connectors","href":"/integrations/connectors/data-sources"}]}],"pages":[{"title":"Integrations","href":"/integrations/home"}]},{"tab":"Resources","menu":[{"item":"Support center","pages":[{"title":"Support center","href":"/resources/support-center/home"}]},{"item":"Development \u0026 contributing","pages":[{"title":"Development \u0026 contributing","href":"/resources/develop-contribute/introduction/developer-instruction"}]},{"item":"Changelogs","dropdowns":[{"dropdown":"Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"Cloud","href":"/resources/changelogs/cloud"}]},{"dropdown":"Open source","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-server.svg","pages":[{"title":"Open source","href":"/resources/changelogs/oss/2026"}]}]},{"item":"About","pages":[{"title":"About","href":"/resources/about"}]}],"pages":[{"title":"Resources","href":"/resources/support-center/home"}]}]},{"language":"ar","pages":[{"title":"ar","href":"/ar/get-started/migrate/other-methods/object-storage-to-clickhouse"}]},{"language":"es","pages":[{"title":"es","href":"/es/get-started/migrate/other-methods/object-storage-to-clickhouse"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/get-started/migrate/other-methods/object-storage-to-clickhouse"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/get-started/migrate/other-methods/object-storage-to-clickhouse"}]},{"language":"ko","pages":[{"title":"ko","href":"/ko/get-started/migrate/other-methods/object-storage-to-clickhouse"}]},{"language":"pt-BR","pages":[{"title":"pt-BR","href":"/pt-BR/get-started/migrate/other-methods/object-storage-to-clickhouse"}]},{"language":"ru","pages":[{"title":"ru","href":"/ru/get-started/migrate/other-methods/object-storage-to-clickhouse"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]},"basePath":"","title":"Move data from cloud object storage to ClickHouse Cloud - ClickHouse Documentation","deploymentId":"dpl_2MqcLy8smQrrovUehgcZEsoo1tJX","buildId":"dpl_2MqcLy8smQrrovUehgcZEsoo1tJX","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-BSnmehho.js","DynamicMarkdown-CU5QIokU.js","zoom-image-lightbox-TD6wszNR.js","lightbox-handle-r17bVUz3.js"]}