Apresenta uma visão geral das diferenças na atualização de dados entre o ClickHouse e bancos de dados OLTP, bem como dos vários métodos disponíveis para isso no ClickHouse.
{"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.4.1.2709","airgap_keeper_tag":"26.2.1.258","airgap_operator_tag":"1.22992.1","airgap_cr_helm_tag":"1.11.11","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":""},"chroma":{"liveDeploymentHistoryId":"6ae8d9fc28a88ed9db40f71c","collectionId":"2dfa09da-3a3e-4782-ad6a-6694be472bd7","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ae8d9fc28a88ed9db40f71c"},"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":"6ae8d9fc28a88ed9db40f71c","clientVersion":"0.0.4045","searchFilterCounts":[{"language":"en","tag":"Database","count":1751},{"language":"ja","tag":"データベース","count":1737},{"language":"pt-BR","tag":"Banco de dados","count":1737},{"language":"zh","tag":"数据库","count":1737},{"language":"ar","tag":"قاعدة البيانات","count":1736},{"language":"es","tag":"Base de datos","count":1736},{"language":"fr","tag":"Base de données","count":1736},{"language":"ko","tag":"데이터베이스","count":1736},{"language":"ru","tag":"База данных","count":1736},{"language":"en","tag":"Reference","count":1576},{"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":"Solutions","count":560},{"language":"ar","tag":"الحلول","count":554},{"language":"es","tag":"Soluciones","count":554},{"language":"fr","tag":"Solutions","count":554},{"language":"ja","tag":"ソリューション","count":554},{"language":"ko","tag":"솔루션","count":554},{"language":"pt-BR","tag":"Soluções","count":554},{"language":"ru","tag":"Решения","count":554},{"language":"zh","tag":"解决方案","count":554},{"language":"es","tag":"Configuración","count":531},{"language":"ja","tag":"設定","count":531},{"language":"en","tag":"Settings","count":509},{"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":"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":300},{"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":"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":256},{"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":"en","tag":"Guides","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":"en","tag":"Resources","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":"Solutions","count":125},{"language":"default","tag":"ClickHouse Cloud","count":125},{"language":"default","tag":"Cloud API","count":83},{"language":"default","tag":"API reference","count":83},{"language":"default","tag":"ClickHouse Private","count":42},{"language":"default","tag":"ClickStack","count":31},{"language":"default","tag":"Service","count":24},{"language":"default","tag":"Organization","count":21},{"language":"default","tag":"Postgres","count":18},{"language":"default","tag":"How-To Guides","count":17}],"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":"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":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"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":"byok-sep-25","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":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"_site/styles.css","href":"/docs/_mintlify/custom/private-7c7dfe99/2a1d0d506d6c7ad1/_site/styles.css"},{"filePath":"snippets/components/Badges/badges_styles.css","content":".ClickHouseSupportedBadge,.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:.875rem}.betaBadge::before{content:\"β\";flex:0 0 auto;margin-right:8px;font-size:1rem;font-weight:600;line-height:1}.dark a.betaBadge,a.betaBadge{color:#1d4ed8!important;text-decoration:none!important}.dark .betaBadge{background-color:#1e3a6b;color:#93c5fd}.dark a.betaBadge{color:#93c5fd!important}.ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.ClickHouseSupportedIcon{margin-right:8px}.ClickHouseSupportedIcon svg path{fill:#282828}.ClickHouseSupportedBadge a{color:#000}.dark .ClickHouseSupportedBadge{background-color:#faff69;color:#161517}.dark .ClickHouseSupportedBadge a{color:#161517}.dark .ClickHouseSupportedIcon svg path{fill:#161517}.cloudNotSupportedBadge{background-color:#f6e5ff;color:#609;border-radius:16px;display:flex;align-items:center;padding:5px 12px;display:inline-flex;margin-right:5px;font-size:.875rem}.cloudNotSupportedIcon{margin-right:8px}a.cloudNotSupportedBadge{color:#609!important;text-decoration:none!important}.cloudNotSupportedIcon svg path{stroke:#609}.dark .cloudNotSupportedBadge{background-color:#33004d;color:#ecf}.dark a.cloudNotSupportedBadge{color:#ecf!important;text-decoration:none!important}.dark .cloudNotSupportedIcon svg path{stroke:#ecf}.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:.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:#fff;display:inline-flex;margin-right:5px;font-size:.875rem}.CommunityMaintainedIcon{margin-right:8px}.CommunityMaintainedIcon svg path,.dark .CommunityMaintainedIcon svg path{fill:#fff;stroke:none}.CommunityMaintainedBadge a,.CommunityMaintainedBadge svg path{color:#69afff}.dark .CommunityMaintainedBadge{background-color:#69afff;color:#fff}.dark .CommunityMaintainedBadge a{color:#fff}.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:.875rem}.deprecatedIcon{margin-right:8px}.dark .deprecatedBadge a,.deprecatedBadge a{color:inherit}.dark .deprecatedBadge{background-color:#414141;color:#e6e7e9}.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:.875rem}.enterprisePlanFeatureContainer p,.scalePlanFeatureContainer p{margin:0;padding:0}.enterprisePlanFeatureBadge,.experimentalBadge{border-radius:16px;display:flex;align-items:center;display:inline-flex;font-size:.875rem}.enterprisePlanFeatureBadge{background-color:#008a0b;border:1px;border-color:#437eef;color:#fff;padding:2px 12px;margin-bottom:8px}.dark .enterprisePlanFeatureContainer{background-color:#1f1f1c;border:1px solid #414141}.dark .enterprisePlanFeatureBadge{background-color:#99ffa1;color:#1f1f1c}.experimentalBadge{background-color:#f3e8ff;color:#6d28d9;padding:5px 12px;margin-right:5px}.experimentalIcon{margin-right:8px}.dark a.experimentalBadge,a.experimentalBadge{color:#6d28d9!important;text-decoration:none!important}.dark .experimentalBadge{background-color:#3b1d6b;color:#d8b4fe}.dark a.experimentalBadge{color:#d8b4fe!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:#fff;display:inline-flex;margin-right:5px;font-size:.875rem}.PartnerBadgeIcon{margin-right:8px}.PartnerBadgeIcon svg path{fill:#fbc9ef;stroke:#990073}.PartnerBadge a,.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:.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:.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:.875rem}.scalePlanFeatureBadge{border-radius:16px;display:flex;align-items:center;display:inline-flex;padding:2px 12px;margin-bottom:8px;font-size:.875rem}.dark .scalePlanFeatureContainer{background-color:#1f1f1c;border:1px solid #414141}.dark .scalePlanFeatureBadge,.scalePlanFeatureBadge{background-color:#1d64ec;color:#fff}"},{"filePath":"snippets/components/ClickStackAnimation/ClickStackAnimation.css","content":"@keyframes fadeInOut{0%,to{opacity:.3}50%{opacity:.8}}.clickstack-animation-wrapper{width:100%;max-width:max-content;transition:opacity .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:.375rem;padding:1rem;flex-shrink:0;border:1px solid rgba(113,113,122,.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,.6);filter:blur(40px)}.clickstack-logo-box{position:absolute;inset:0;z-index:10;display:flex;border-radius:.5rem;border:2px solid #faff69;background-color:#262626;background-image:linear-gradient(to bottom right,rgba(250,255,105,.2),rgba(250,255,105,.4))}.clickstack-logo-svg{margin:auto}:is(.light) .clickstack-logo-glow{display:none}:is(.light) .clickstack-logo-box{border-color:#faff69;background-color:#000;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":"pt-BR/concepts/features/operations/update","slug":"/pt-BR/concepts/features/operations/update","pageMetadata":{"slug":"/updating-data","title":"Atualizando dados","sidebarTitle":"Visão geral","description":"Sumário de Atualização de Dados","keywords":["atualização","atualizando dados"],"doc_type":"landing-page","href":"/pt-BR/concepts/features/operations/update/index"},"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: \"Sumário de Atualização de Dados\"\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`,p:`p`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Table}=_components;if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Nesta seção da documentação, você aprenderá como atualizar seus dados.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Página`}),_jsx(_components.th,{children:`Descrição`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/pt-BR/concepts/features/operations/update/overview`,children:`Trabalhando com atualizações`})}),_jsx(_components.td,{children:`Apresenta uma visão geral das diferenças na atualização de dados entre o ClickHouse e bancos de dados OLTP, bem como dos vários métodos disponíveis para isso no ClickHouse.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.a,{href:`/pt-BR/concepts/features/operations/update/replacing-merge-tree`,children:`Trabalhando com ReplacingMergeTree`})}),_jsx(_components.td,{children:`Saiba como atualizar dados usando o ReplacingMergeTree.`})]})]})]})]})}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":{"slug":"/updating-data","title":"Atualizando dados","sidebarTitle":"Visão geral","description":"Sumário de Atualização de Dados","keywords":["atualização","atualizando dados"],"doc_type":"landing-page","href":"/pt-BR/concepts/features/operations/update/index"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/private-7c7dfe99/a0ab956a7a3c7ff5/_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/564839e4bb02c38e/_site/customizations/custom-footer.js","/docs/_mintlify/custom/private-7c7dfe99/240e3ba1823c3bae/_site/customizations/galaxy.js","/docs/_mintlify/custom/private-7c7dfe99/38fd3c627bad5620/_site/customizations/inkeep-init.js","/docs/_mintlify/custom/private-7c7dfe99/ad7415752a665282/_site/customizations/kapa-init.js","/docs/_mintlify/custom/private-7c7dfe99/c54d4536629b44db/_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/b734912855230cc2/_site/customizations/settings-legacy-routes/format-settings.js","/docs/_mintlify/custom/private-7c7dfe99/e07c37962b288c7e/_site/customizations/settings-legacy-routes/mergetree-settings.js","/docs/_mintlify/custom/private-7c7dfe99/2b8fcba9c043bce4/_site/customizations/settings-legacy-routes/server-settings.js","/docs/_mintlify/custom/private-7c7dfe99/20d8f577c04bd763/_site/customizations/settings-legacy-routes/session-settings.js","/docs/_mintlify/custom/private-7c7dfe99/3bd87f000900d6e2/_site/customizations/tab-nav.js","/docs/_mintlify/custom/private-7c7dfe99/5c7ce50607c95a70/_site/customizations/webterminal.js","/docs/_mintlify/custom/private-7c7dfe99/7b903fec76456ee0/_site/customizations/cloud-sidebar-ad.js","/docs/_mintlify/custom/private-7c7dfe99/346eac2572f9fb1d/_site/customizations/section-ticker.js"],"subdomain":"private-7c7dfe99","siteName":"ClickHouse Documentation","title":"Atualizando dados - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/concepts/features/operations/update/index","matchLevel":1},"ar":{"href":"/ar/concepts/features/operations/update/index","matchLevel":1},"es":{"href":"/es/concepts/features/operations/update/index","matchLevel":1},"fr":{"href":"/fr/concepts/features/operations/update/index","matchLevel":1},"ja":{"href":"/ja/concepts/features/operations/update/index","matchLevel":1},"ko":{"href":"/ko/concepts/features/operations/update/index","matchLevel":1},"pt-BR":{"href":"/pt-BR/concepts/features/operations/update/index","matchLevel":2},"ru":{"href":"/ru/concepts/features/operations/update/index","matchLevel":1},"zh":{"href":"/zh/concepts/features/operations/update/index","matchLevel":1}}},"originalFileLocation":"pt-BR/concepts/features/operations/update/index.mdx","locale":"pt-BR"},"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=\"Sumário de Atualização de Dados\">\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=\"Atualizando dados - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Sumário de Atualização de Dados\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://private-7c7dfe99.mintlify.app/_mintlify/api/og/v2?division=Atualizar\u0026amp;title=Atualizando+dados\u0026amp;description=Sum%C3%A1rio+de+Atualiza%C3%A7%C3%A3o+de+Dados\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=36cd30c6e1eebf7c226ab6d4c9c4a80028301ac528a3fdff3f548ae1315eb647\">\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=\"Atualizando dados - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Sumário de Atualização de Dados\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.app/_mintlify/api/og/v2?division=Atualizar\u0026amp;title=Atualizando+dados\u0026amp;description=Sum%C3%A1rio+de+Atualiza%C3%A7%C3%A3o+de+Dados\u0026amp;theme=de5161c1b5df52f178b39943\u0026amp;signature=36cd30c6e1eebf7c226ab6d4c9c4a80028301ac528a3fdff3f548ae1315eb647\">\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/pt-BR/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/pt-BR/concepts/features/operations/update.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/concepts/features/operations/update\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/concepts/features/operations/update\">\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/pt-BR/concepts/features/operations/update#webpage\",\"url\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update\",\"name\":\"Atualizando dados\",\"description\":\"Sumário de Atualização de Dados\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Conceitos do ClickHouse\",\"item\":\"https://clickhouse.com/docs/pt-BR/concepts/features/index\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Operações\",\"item\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/background-queries\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Atualizar\",\"item\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update/index\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Atualizando dados\",\"item\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update#article\",\"headline\":\"Atualizando dados\",\"name\":\"Atualizando dados\",\"description\":\"Sumário de Atualização de Dados\",\"url\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/pt-BR/concepts/features/operations/update#webpage\"},\"keywords\":\"atualização, atualizando dados\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"},\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"}}]}\u003c/script>","siteName":"ClickHouse Documentation","nav":{"global":null,"languages":[{"language":"en","pages":[{"title":"en","href":"/concepts/features/operations/update"}]},{"language":"ar","pages":[{"title":"ar","href":"/ar/concepts/features/operations/update"}]},{"language":"es","pages":[{"title":"es","href":"/es/concepts/features/operations/update"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/concepts/features/operations/update"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/concepts/features/operations/update"}]},{"language":"ko","pages":[{"title":"ko","href":"/ko/concepts/features/operations/update"}]},{"language":"pt-BR","tabs":[{"tab":"Início","pages":[{"title":"Início","href":"/pt-BR"}]},{"tab":"Banco de dados","menu":[{"item":"Primeiros passos","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-get-started.svg","pages":[{"group":"Primeiros passos","icon":"/images/menu-icon-lightning.svg","pages":[{"title":"Comece a usar o ClickHouse","sidebarTitle":"Visão geral","href":"/pt-BR/get-started"},{"group":"Guias de início rápido","expanded":false,"pages":[{"sidebarTitle":"Explorar guias de início rápido","title":"Explorador dos guias de início rápido","mode":"custom","href":"/pt-BR/get-started/quickstarts/home"},{"group":"Todos os casos de uso","expanded":false,"pages":[{"sidebarTitle":"Início rápido na Cloud","title":"Início rápido do ClickHouse Cloud","href":"/pt-BR/get-started/setup/cloud"},{"sidebarTitle":"Obtenha os detalhes de conexão do Cloud","title":"Obtenha os detalhes de conexão do Cloud","href":"/pt-BR/get-started/quickstarts/obtain-your-cloud-connection-details"},{"sidebarTitle":"Inserir dados no ClickHouse Cloud usando clickhouse-client","title":"Inserir dados no ClickHouse Cloud usando clickhouse-client","href":"/pt-BR/get-started/quickstarts/insert-data-using-clickhouse-client"},{"sidebarTitle":"Criando tabelas no ClickHouse","title":"Criando tabelas no ClickHouse","href":"/pt-BR/get-started/quickstarts/creating-tables"},{"sidebarTitle":"Selecionando dados do ClickHouse","title":"Selecionando dados do ClickHouse","href":"/pt-BR/get-started/quickstarts/writing-queries"},{"sidebarTitle":"Crie sua primeira tabela MergeTree","title":"Crie sua primeira tabela MergeTree","href":"/pt-BR/get-started/quickstarts/create-your-first-mergetree-table"}]},{"group":"Analytics em tempo real","expanded":false,"pages":[{"sidebarTitle":"Crie sua primeira visão materializada","title":"Crie sua primeira visão materializada","href":"/pt-BR/get-started/quickstarts/create-your-first-materialized-view"},{"sidebarTitle":"Crie sua primeira projeção","title":"Crie sua primeira projeção","href":"/pt-BR/get-started/quickstarts/create-your-first-projection"}]},{"group":"Armazenamento de dados","expanded":false,"pages":[{"sidebarTitle":"Como conectar seu catálogo Iceberg ao ClickHouse Cloud","title":"Como conectar seu catálogo Iceberg ao ClickHouse Cloud","href":"/pt-BR/get-started/quickstarts/connect-your-iceberg-catalog"},{"sidebarTitle":"Atualização e exclusão de dados no ClickHouse","title":"Atualização e exclusão de dados no ClickHouse","href":"/pt-BR/get-started/quickstarts/mutations"}]},{"group":"Observabilidade","expanded":false,"pages":[{"sidebarTitle":"Trabalhando com o tipo Map no ClickHouse","title":"Trabalhando com o tipo Map no ClickHouse","href":"/pt-BR/get-started/quickstarts/working-with-the-map-type"}]}]},{"group":"Introdução","expanded":true,"pages":[{"sidebarTitle":"O que é ClickHouse?","title":"O que é ClickHouse?","href":"/pt-BR/get-started/about/intro"},{"sidebarTitle":"Por que o ClickHouse é tão rápido?","title":"Por que o ClickHouse é tão rápido?","href":"/pt-BR/get-started/about/why-clickhouse-is-so-fast"},{"sidebarTitle":"Por que o ClickHouse é único?","title":"Diferenciais do ClickHouse","href":"/pt-BR/get-started/about/distinctive-features"}]},{"group":"Casos de uso","expanded":true,"pages":[{"title":"Casos de uso","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/use-cases/overview"},{"title":"Escolha um serviço para sua carga de trabalho","sidebarTitle":"Escolha um serviço","href":"/pt-BR/get-started/use-cases/choosing-a-service"},{"title":"Analytics em tempo real","sidebarTitle":"Analytics em tempo real","href":"/pt-BR/get-started/use-cases/real-time-analytics"},{"title":"Observabilidade","sidebarTitle":"Observabilidade","href":"/pt-BR/get-started/use-cases/observability"},{"title":"Armazenamento de dados","sidebarTitle":"Armazenamento de dados","href":"/pt-BR/get-started/use-cases/data-warehousing"},{"title":"Análises agênticas","sidebarTitle":"Análises agênticas","href":"/pt-BR/get-started/use-cases/agentic-analytics"}]},{"sidebarTitle":"Modos de implantação","title":"Modos de implantação","href":"/pt-BR/get-started/about/deployment-modes"}]},{"group":"Configuração","icon":"/images/menu-icon-gear.svg","expanded":true,"pages":[{"sidebarTitle":"Instalar","title":"Instruções de instalação","href":"/pt-BR/get-started/setup/install"},{"sidebarTitle":"Início rápido na Cloud","title":"Início rápido do ClickHouse Cloud","href":"/pt-BR/get-started/setup/cloud"},{"group":"Autogerenciado","expanded":true,"pages":[{"title":"Instalação autogerenciada","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/setup/self-managed/overview"},{"group":"Desenvolvimento local","pages":[{"sidebarTitle":"Instalação rápida","title":"Instalação rápida","href":"/pt-BR/get-started/setup/self-managed/quick-install"},{"sidebarTitle":"clickhousectl (CLI)","title":"Instalar com a ClickHouse CLI","href":"/pt-BR/get-started/setup/self-managed/clickhousectl"},{"sidebarTitle":"Docker","title":"Instale o ClickHouse usando o Docker","href":"/pt-BR/get-started/setup/self-managed/docker"},{"sidebarTitle":"Compilações de código-fonte e de CI","title":"Compilações de código-fonte e de CI","href":"/pt-BR/get-started/setup/self-managed/advanced"}]},{"group":"Servidor de produção","pages":[{"sidebarTitle":"Debian/Ubuntu","title":"Instalar o ClickHouse em Debian/Ubuntu","href":"/pt-BR/get-started/setup/self-managed/debian-ubuntu"},{"sidebarTitle":"Red Hat/CentOS","title":"Instale o ClickHouse em distribuições Linux baseadas em rpm","href":"/pt-BR/get-started/setup/self-managed/redhat"},{"sidebarTitle":"NixOS","title":"Instalar o ClickHouse no NixOS","href":"/pt-BR/get-started/setup/self-managed/nixos"},{"sidebarTitle":"Outras versões do Linux","title":"Instalar o ClickHouse usando arquivos tgz","href":"/pt-BR/get-started/setup/self-managed/other-linux"}]}]}]},{"group":"Conjuntos de dados de exemplo","icon":"/images/menu-icon-database.svg","expanded":true,"pages":[{"sidebarTitle":"Visão geral","title":"Tutoriais e conjuntos de dados de exemplo","href":"/pt-BR/get-started/sample-datasets/index"},{"sidebarTitle":"ClickHouse playground","title":"ClickHouse playground","href":"/pt-BR/get-started/sample-datasets/playground"},{"group":"Testes de desempenho","pages":[{"sidebarTitle":"benchmark de big data AMPLab","title":"Benchmark de Big Data AMPLab","href":"/pt-BR/get-started/sample-datasets/amplab-benchmark"},{"sidebarTitle":"Benchmark da Brown University","title":"Benchmark da Brown University","href":"/pt-BR/get-started/sample-datasets/brown-benchmark"},{"sidebarTitle":"Logs de cliques de 1 TB da Criteo","title":"Logs de cliques de um terabyte da Criteo","href":"/pt-BR/get-started/sample-datasets/criteo"},{"title":"Join Order Benchmark (JOB)","sidebarTitle":"JOB","href":"/pt-BR/get-started/sample-datasets/job"},{"sidebarTitle":"Star Schema Benchmark","title":"Star Schema Benchmark (SSB, 2009)","href":"/pt-BR/get-started/sample-datasets/star-schema"},{"title":"TPC-DS (2012)","sidebarTitle":"TPC-DS","href":"/pt-BR/get-started/sample-datasets/tpcds"},{"title":"TPC-H (1999)","sidebarTitle":"TPC-H","href":"/pt-BR/get-started/sample-datasets/tpch"}]},{"group":"Busca vetorial e embeddings","pages":[{"sidebarTitle":"conjunto de dados dbpedia","title":"conjunto de dados dbpedia","href":"/pt-BR/get-started/sample-datasets/dbpedia"},{"sidebarTitle":"Conjunto de dados para busca vetorial do Hacker News","title":"Conjunto de dados para busca vetorial do Hacker News","href":"/pt-BR/get-started/sample-datasets/hacker-news-vector-search"},{"sidebarTitle":"Conjunto de dados Laion-400M","title":"Conjunto de dados Laion-400M","href":"/pt-BR/get-started/sample-datasets/laion"},{"sidebarTitle":"conjunto de dados LAION 5B","title":"conjunto de dados LAION 5B","href":"/pt-BR/get-started/sample-datasets/laion5b"}]},{"group":"Analytics da web e de redes sociais","pages":[{"sidebarTitle":"Avaliações de clientes da Amazon","title":"Avaliações de clientes da Amazon","href":"/pt-BR/get-started/sample-datasets/amazon-reviews"},{"sidebarTitle":"Análise da web anonimizada","title":"Análise da web anonimizada","href":"/pt-BR/get-started/sample-datasets/anon-web-analytics-metrica"},{"sidebarTitle":"Repositório do GitHub","title":"Escrevendo consultas no ClickHouse com dados do GitHub","href":"/pt-BR/get-started/sample-datasets/github"},{"sidebarTitle":"Eventos do GitHub","title":"Conjunto de dados de eventos do GitHub","href":"/pt-BR/get-started/sample-datasets/github-events"},{"sidebarTitle":"Hacker News","title":"Conjunto de dados do Hacker News","href":"/pt-BR/get-started/sample-datasets/hacker-news"},{"sidebarTitle":"Stack Overflow","title":"Análise de dados do Stack Overflow com ClickHouse","href":"/pt-BR/get-started/sample-datasets/stackoverflow"},{"sidebarTitle":"Não gostei do YouTube","title":"Dataset do YouTube com não gostei","href":"/pt-BR/get-started/sample-datasets/youtube-dislikes"}]},{"group":"Geoespacial e localização","pages":[{"sidebarTitle":"Torres de celular","title":"Análise geoespacial com o conjunto de dados de torres de celular","href":"/pt-BR/get-started/sample-datasets/cell-towers"},{"sidebarTitle":"Foursquare OS Places","title":"Conjunto de dados Foursquare OS Places","href":"/pt-BR/get-started/sample-datasets/foursquare-os-places"},{"sidebarTitle":"Dados de táxis de Nova York","title":"Análise geoespacial com o conjunto de dados de táxis de Nova York","href":"/pt-BR/get-started/sample-datasets/nyc-taxi"}]},{"group":"Séries temporais e sensores","pages":[{"sidebarTitle":"Dados de sensores ambientais","title":"Dados de sensores ambientais","href":"/pt-BR/get-started/sample-datasets/environmental-sensors"},{"sidebarTitle":"NOAA Global Historical Climatology Network ","title":"NOAA Global Historical Climatology Network","href":"/pt-BR/get-started/sample-datasets/noaa"},{"sidebarTitle":"Datasets históricos de meteorologia de Taiwan","title":"Datasets históricos de meteorologia de Taiwan","href":"/pt-BR/get-started/sample-datasets/tw-weather"},{"sidebarTitle":"WikiStat","title":"WikiStat","href":"/pt-BR/get-started/sample-datasets/wikistat"}]},{"group":"Registros públicos e dados abertos","pages":[{"sidebarTitle":"dados abertos da COVID-19","title":"dados abertos da COVID-19","href":"/pt-BR/get-started/sample-datasets/covid19"},{"sidebarTitle":"dataset \"what's on the menu?\" da New York Public Library","title":"dataset \"What's on the Menu?\" da New York Public Library","href":"/pt-BR/get-started/sample-datasets/menus"},{"sidebarTitle":"dados de ocorrências do NYPD","title":"dados de ocorrências do NYPD","href":"/pt-BR/get-started/sample-datasets/nypd-complaint-data"},{"sidebarTitle":"Dados de voos OnTime de companhias aéreas","title":"OnTime","href":"/pt-BR/get-started/sample-datasets/ontime"},{"sidebarTitle":"Preços de imóveis no Reino Unido","title":"Consultas analíticas sobre dados de preços de imóveis do Reino Unido","href":"/pt-BR/get-started/sample-datasets/uk-price-paid"}]}]},{"group":"Migrar","icon":"/images/caret-double-right.svg","expanded":true,"pages":[{"sidebarTitle":"Visão geral","title":"Migrando dados para o ClickHouse","href":"/pt-BR/get-started/migrate/overview"},{"group":"PostgreSQL","pages":[{"title":"Comparação entre PostgreSQL e ClickHouse","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/migrate/postgres/overview"},{"group":"Guia de migração","pages":[{"title":"Migração de dados","sidebarTitle":"Parte 1","href":"/pt-BR/get-started/migrate/postgres/migration-guide/migration-guide-part1"},{"title":"Reescrevendo consultas do PostgreSQL","sidebarTitle":"Parte 2","href":"/pt-BR/get-started/migrate/postgres/migration-guide/migration-guide-part2"},{"title":"Técnicas de modelagem de dados","sidebarTitle":"Parte 3","href":"/pt-BR/get-started/migrate/postgres/migration-guide/migration-guide-part3"}]},{"title":"Apêndice","href":"/pt-BR/get-started/migrate/postgres/appendix"}]},{"group":"BigQuery","pages":[{"title":"Comparando ClickHouse Cloud e BigQuery","sidebarTitle":"Visão geral","href":"/pt-BR/get-started/migrate/bigquery/overview"},{"title":"Migrando do BigQuery para o ClickHouse Cloud","sidebarTitle":"Guia de migração","href":"/pt-BR/get-started/migrate/bigquery/migrating-to-clickhouse-cloud"},{"sidebarTitle":"Carga de dados","title":"Carga de dados do BigQuery para o ClickHouse","href":"/pt-BR/get-started/migrate/bigquery/loading-data"}]},{"group":"Snowflake","pages":[{"sidebarTitle":"Visão geral","title":"Migração de Snowflake para ClickHouse","href":"/pt-BR/get-started/migrate/snowflake/overview"},{"sidebarTitle":"Guia de migração","title":"Migrando do Snowflake para o ClickHouse","href":"/pt-BR/get-started/migrate/snowflake/migration-guide"},{"sidebarTitle":"Referência de tradução SQL","title":"Migrando do Snowflake para ClickHouse","href":"/pt-BR/get-started/migrate/snowflake/sql-translation-reference"}]},{"group":"Elasticsearch","pages":[{"sidebarTitle":"Visão geral","title":"Migrar do Elasticsearch para o ClickHouse","href":"/pt-BR/get-started/migrate/elastic/overview"}]},{"group":"Redshift","pages":[{"sidebarTitle":"Visão geral","title":"Comparando o ClickHouse Cloud e o Amazon Redshift","href":"/pt-BR/get-started/migrate/redshift/overview"},{"sidebarTitle":"Guia de migração","title":"Guia de migração do Amazon Redshift para o ClickHouse","href":"/pt-BR/get-started/migrate/redshift/migration-guide"},{"sidebarTitle":"Referência de tradução de SQL","title":"Guia de tradução de SQL do Amazon Redshift","href":"/pt-BR/get-started/migrate/redshift/sql-translation-reference"}]},{"group":"Do OSS para o Cloud","pages":[{"sidebarTitle":"Usando remoteSecure","title":"Migrando entre ClickHouse autogerenciado e ClickHouse Cloud usando remoteSecure","href":"/pt-BR/get-started/migrate/oss-to-cloud/clickhouse-to-cloud"},{"sidebarTitle":"Usando BACKUP e RESTORE","title":"Migração de ClickHouse autogerenciado para ClickHouse Cloud usando comandos de backup","href":"/pt-BR/get-started/migrate/oss-to-cloud/oss-to-cloud-backup-restore"}]},{"group":"Outros métodos","pages":[{"sidebarTitle":"Como usar o clickhouse-local","title":"Como migrar para o ClickHouse usando o clickhouse-local","href":"/pt-BR/get-started/migrate/other-methods/clickhouse-local-etl"},{"sidebarTitle":"Como usar uma ferramenta ETL de terceiros","title":"Como usar uma ferramenta ETL de terceiros","href":"/pt-BR/get-started/migrate/other-methods/etl-tool-to-clickhouse"},{"title":"Mover dados do armazenamento de objetos em Cloud para o ClickHouse Cloud","href":"/pt-BR/get-started/migrate/other-methods/object-storage-to-clickhouse"}]}]}]},{"item":"Conceitos","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-concepts.svg","pages":[{"title":"Conceitos","sidebarTitle":"Visão geral","mode":"wide","href":"/pt-BR/concepts"},{"group":"Fundamentos","expanded":true,"pages":[{"title":"Conceitos fundamentais","mode":"wide","href":"/pt-BR/concepts/core-concepts/index"},{"sidebarTitle":"Glossário","title":"Glossário","mode":"wide","href":"/pt-BR/concepts/core-concepts/glossary"},{"title":"Partes de tabela","href":"/pt-BR/concepts/core-concepts/parts"},{"title":"Partições de tabela","href":"/pt-BR/concepts/core-concepts/partitions"},{"title":"Mesclagem de partes","href":"/pt-BR/concepts/core-concepts/merges"},{"title":"Índices primários","href":"/pt-BR/concepts/core-concepts/primary-indexes"},{"sidebarTitle":"Paralelismo de consulta","title":"Como o ClickHouse executa uma consulta em paralelo","href":"/pt-BR/concepts/core-concepts/query-parallelism"},{"title":"Visão geral da arquitetura","href":"/pt-BR/concepts/core-concepts/academic-overview"}]},{"group":"Conceitos do ClickHouse","expanded":true,"pages":[{"title":"Conceitos do ClickHouse","sidebarTitle":"Visão geral","mode":"wide","href":"/pt-BR/concepts/features/index"},{"group":"Visões materializadas","pages":[{"title":"Visões materializadas","sidebarTitle":"Visão geral","href":"/pt-BR/concepts/features/materialized-views/index"},{"title":"View materializada incremental","href":"/pt-BR/concepts/features/materialized-views/incremental-materialized-view"},{"title":"View materializada atualizável","href":"/pt-BR/concepts/features/materialized-views/refreshable-materialized-view"},{"title":"Visões materializadas em cascata","href":"/pt-BR/concepts/features/materialized-views/cascading-materialized-views"}]},{"group":"Dicionários","pages":[{"title":"Dicionário","href":"/pt-BR/concepts/features/dictionaries/index"},{"title":"Boas práticas para dicionários","sidebarTitle":"Boas práticas","href":"/pt-BR/concepts/features/dictionaries/best-practices"}]},{"group":"Projeções","pages":[{"title":"Projeções","href":"/pt-BR/concepts/features/projections/projections"},{"sidebarTitle":"Visões materializadas vs projeções","title":"Visões materializadas versus projeções","href":"/pt-BR/concepts/features/projections/materialized-views-versus-projections"}]},{"group":"Desempenho","pages":[{"sidebarTitle":"Visão geral de desempenho e otimizações","title":"Desempenho e otimizações","mode":"wide","href":"/pt-BR/concepts/features/performance/index"},{"sidebarTitle":"Otimização PREWHERE","title":"Como funciona a otimização PREWHERE?","href":"/pt-BR/concepts/features/performance/prewhere"},{"sidebarTitle":"Perfil de alocação","title":"Perfil de alocação","href":"/pt-BR/concepts/features/performance/allocation-profiling"},{"sidebarTitle":"Profiling de alocação para versões anteriores à 25.9","title":"Profiling de alocação para versões anteriores à 25.9","href":"/pt-BR/concepts/features/performance/allocation-profiling-old"},{"group":"Caches","pages":[{"sidebarTitle":"Caches","title":"Tipos de cache","href":"/pt-BR/concepts/features/performance/caches/caches"},{"sidebarTitle":"Cache de consultas","title":"Cache de consultas","href":"/pt-BR/concepts/features/performance/caches/query-cache"},{"sidebarTitle":"Cache de condições de consulta","title":"Cache de condições de consulta","href":"/pt-BR/concepts/features/performance/caches/query-condition-cache"},{"sidebarTitle":"Cache de páginas em espaço de usuário","title":"Cache de páginas em espaço de usuário","href":"/pt-BR/concepts/features/performance/caches/userspace-page-cache"}]},{"group":"Índices de salto","pages":[{"sidebarTitle":"Data skipping indexes","title":"Entendendo os data skipping indexes no ClickHouse","href":"/pt-BR/concepts/features/performance/skip-indexes/skipping-indexes"},{"sidebarTitle":"Data skipping indexes - exemplos","title":"Exemplos de data skipping indexes","href":"/pt-BR/concepts/features/performance/skip-indexes/skipping-indexes-examples"}]},{"sidebarTitle":"Materialização tardia","title":"Materialização tardia","href":"/pt-BR/concepts/features/performance/lazy-materialization"},{"group":"Solução de problemas","pages":[{"sidebarTitle":"Depuração de problemas de memória","title":"Depuração de problemas de memória","href":"/pt-BR/concepts/features/performance/troubleshoot/debugging-memory-issues"},{"title":"Canário de OOM","href":"/pt-BR/concepts/features/performance/troubleshoot/oom-canary"},{"sidebarTitle":"Teste de hardware","title":"Como testar o hardware com ClickHouse","href":"/pt-BR/concepts/features/performance/troubleshoot/performance-test"},{"sidebarTitle":"Profiling de consultas","title":"Sampling query profiler","href":"/pt-BR/concepts/features/performance/troubleshoot/sampling-query-profiler"}]}]},{"group":"Operações","pages":[{"sidebarTitle":"consultas em segundo plano","title":"consultas em segundo plano","href":"/pt-BR/concepts/features/operations/background-queries"},{"group":"Inserir","pages":[{"title":"Inserção de dados no ClickHouse","sidebarTitle":"Inserção de dados no ClickHouse","href":"/pt-BR/concepts/features/operations/insert/inserting-data"},{"sidebarTitle":"Inserções assíncronas","title":"Inserções assíncronas (async_insert)","href":"/pt-BR/concepts/features/operations/insert/asyncinserts"},{"sidebarTitle":"INSERT ... SELECT assíncrono","title":"INSERT ... SELECT assíncrono","href":"/pt-BR/concepts/features/operations/insert/async-insert-select"},{"sidebarTitle":"Inserções em lote","title":"Inserções em lote","href":"/pt-BR/concepts/features/operations/insert/bulkinserts"},{"sidebarTitle":"Estratégias de desduplicação","title":"Estratégias de desduplicação","href":"/pt-BR/concepts/features/operations/insert/deduplication"},{"title":"Desduplicação de inserções em tentativas repetidas","href":"/pt-BR/concepts/features/operations/insert/deduplicating-inserts-on-retries"},{"title":"Suporte transacional (ACID)","href":"/pt-BR/concepts/features/operations/insert/transactions"}]},{"group":"Selecionar","pages":[{"title":"Como usar JOINs no ClickHouse","description":"Como fazer junções entre tabelas no ClickHouse","href":"/pt-BR/concepts/features/operations/select/joining-tables"}]},{"group":"Atualizar","pages":[{"title":"Atualizando dados","sidebarTitle":"Visão geral","href":"/pt-BR/concepts/features/operations/update/index"},{"title":"Atualizações no ClickHouse","description":"Guia sobre quais métodos de atualização estão disponíveis e como escolher o método correto para sua carga de trabalho.","sidebarTitle":"Trabalhando com atualizações","href":"/pt-BR/concepts/features/operations/update/overview"},{"title":"Trabalhando com o motor ReplacingMergeTree","sidebarTitle":"Trabalhando com o motor ReplacingMergeTree","href":"/pt-BR/concepts/features/operations/update/replacing-merge-tree"}]},{"group":"Excluir","pages":[{"title":"Exclusão de dados","href":"/pt-BR/concepts/features/operations/delete/index"},{"title":"Visão geral da exclusão","href":"/pt-BR/concepts/features/operations/delete/overview"},{"sidebarTitle":"Excluir partição","title":"Excluindo partições","href":"/pt-BR/concepts/features/operations/delete/drop-partition"},{"title":"Exclusão leve","href":"/pt-BR/concepts/features/operations/delete/lightweight-delete"},{"sidebarTitle":"TRUNCATE tabela","title":"TRUNCATE Tabela","href":"/pt-BR/concepts/features/operations/delete/truncate"},{"sidebarTitle":"TTL (tempo de vida)","title":"Gerencie dados com TTL (tempo de vida)","href":"/pt-BR/concepts/features/operations/delete/ttl"}]}]},{"group":"Configuração","pages":[{"group":"Configurações","pages":[{"title":"Visão geral das configurações","href":"/pt-BR/concepts/features/configuration/settings/overview"},{"sidebarTitle":"Configurações de sessão em nível de consulta","title":"Configurações de sessão em nível de consulta","href":"/pt-BR/concepts/features/configuration/settings/settings-query-level"},{"sidebarTitle":"Configurações de usuário","title":"Configurações de usuários e funções","href":"/pt-BR/concepts/features/configuration/settings/settings-users"},{"sidebarTitle":"Perfis de configurações","title":"Perfis de configurações","href":"/pt-BR/concepts/features/configuration/settings/settings-profiles"},{"sidebarTitle":"Restrições nas configurações","title":"Restrições nas configurações","href":"/pt-BR/concepts/features/configuration/settings/constraints-on-settings"},{"sidebarTitle":"Restrições na complexidade das consultas","title":"Restrições na complexidade das consultas","href":"/pt-BR/concepts/features/configuration/settings/query-complexity"},{"sidebarTitle":"Permissões para consultas","title":"Permissões para consultas","href":"/pt-BR/concepts/features/configuration/settings/permissions-for-queries"},{"title":"Overcommit de memória","href":"/pt-BR/concepts/features/configuration/settings/memory-overcommit"},{"sidebarTitle":"Sobrecarga do servidor","title":"Sobrecarga do servidor","href":"/pt-BR/concepts/features/configuration/settings/server-overload"},{"sidebarTitle":"Limites de conexões TCP","title":"Limites de conexões TCP","href":"/pt-BR/concepts/features/configuration/settings/tcp-connection-limits"},{"sidebarTitle":"Linguagens de consulta alternativas","title":"Linguagens de consulta alternativas","href":"/pt-BR/concepts/features/configuration/settings/alternative-query-languages"}]},{"group":"Configuração do servidor","pages":[{"sidebarTitle":"Arquivos de configuração","title":"Arquivos de configuração","href":"/pt-BR/concepts/features/configuration/server-config/configuration-files"},{"sidebarTitle":"Discos externos para armazenar dados","title":"Discos externos para armazenar dados","href":"/pt-BR/concepts/features/configuration/server-config/storing-data"},{"sidebarTitle":"Coleções nomeadas","title":"Coleções nomeadas","href":"/pt-BR/concepts/features/configuration/server-config/named-collections"},{"sidebarTitle":"Escalonamento de cargas de trabalho","title":"Escalonamento de cargas de trabalho","href":"/pt-BR/concepts/features/configuration/server-config/workload-scheduling"},{"sidebarTitle":"QUOTAS","title":"QUOTAS","href":"/pt-BR/concepts/features/configuration/server-config/quotas"},{"sidebarTitle":"Protocolos componíveis","title":"Protocolos componíveis","href":"/pt-BR/concepts/features/configuration/server-config/composable-protocols"},{"sidebarTitle":"Scripts de inicialização","title":"Scripts de inicialização","href":"/pt-BR/concepts/features/configuration/server-config/startup-scripts"},{"sidebarTitle":"Porta de introspecção","title":"Porta de introspecção","href":"/pt-BR/concepts/features/configuration/server-config/introspection-port"}]}]},{"group":"Segurança e autenticação","pages":[{"title":"Segurança e autenticação","mode":"wide","href":"/pt-BR/concepts/features/security/index"},{"sidebarTitle":"Usuários e funções","title":"Controle de acesso e gerenciamento de contas","href":"/pt-BR/concepts/features/security/access-rights"},{"sidebarTitle":"Portas de rede","title":"Portas de rede","href":"/pt-BR/concepts/features/security/network-ports"},{"group":"TLS","pages":[{"title":"Configuração de TLS","href":"/pt-BR/concepts/features/security/tls/index"},{"sidebarTitle":"Configurando TLS","title":"Configurando TLS","href":"/pt-BR/concepts/features/security/tls/configuring-tls"},{"sidebarTitle":"Configurando o Provisioning automático de TLS via ACME","title":"Configurando o Provisioning automático de TLS via ACME","href":"/pt-BR/concepts/features/security/tls/configuring-tls-acme-client"}]},{"group":"Autenticadores externos","pages":[{"sidebarTitle":"Autenticadores e diretórios de usuários externos","title":"Autenticadores e diretórios de usuários externos","href":"/pt-BR/concepts/features/security/external-authenticators/index"},{"group":"SSL","pages":[{"title":"Autenticação por certificado SSL X.509","href":"/pt-BR/concepts/features/security/external-authenticators/ssl-x509"},{"sidebarTitle":"Autenticação com certificado SSL de usuário","title":"Configurando o certificado SSL de usuário para autenticação","href":"/pt-BR/concepts/features/security/ssl-user-auth"}]},{"group":"LDAP","pages":[{"title":"LDAP","href":"/pt-BR/concepts/features/security/external-authenticators/ldap"},{"sidebarTitle":"Configurando LDAP","title":"Configurando o ClickHouse para usar LDAP para autenticação e mapeamento de funções","href":"/pt-BR/concepts/features/security/configuring-ldap"}]},{"title":"HTTP","href":"/pt-BR/concepts/features/security/external-authenticators/http"},{"title":"Kerberos","href":"/pt-BR/concepts/features/security/external-authenticators/kerberos"},{"sidebarTitle":"JWT","title":"Autenticação JWT","href":"/pt-BR/concepts/features/security/external-authenticators/jwt"}]}]},{"group":"Backup e restauração","pages":[{"sidebarTitle":"Visão geral","title":"Backup e restauração no ClickHouse","href":"/pt-BR/concepts/features/backup-restore/overview"},{"sidebarTitle":"Configurações de restauração","title":"Configurações de restauração","href":"/pt-BR/concepts/features/backup-restore/restore-settings"},{"sidebarTitle":"Disco local / disco S3","title":"BACKUP / RESTORE em disco","href":"/pt-BR/concepts/features/backup-restore/local-disk"},{"sidebarTitle":"endpoint do S3","title":"BACKUP / RESTAURAÇÃO para ou de um endpoint do S3","href":"/pt-BR/concepts/features/backup-restore/s3-endpoint"},{"sidebarTitle":"AzureBlobStorage","title":"BACKUP/RESTORE para ou a partir do Azure Blob Storage","href":"/pt-BR/concepts/features/backup-restore/azure-blob-storage"},{"sidebarTitle":"Backup por snapshot","title":"Backup e restauração por snapshot","href":"/pt-BR/concepts/features/backup-restore/snapshot"},{"sidebarTitle":"Métodos alternativos","title":"Métodos alternativos de backup ou restauração","href":"/pt-BR/concepts/features/backup-restore/alternative-methods"}]},{"group":"Interfaces","pages":[{"title":"Clientes nativos e interfaces","mode":"wide","href":"/pt-BR/concepts/features/interfaces/native-clients-interfaces-index"},{"sidebarTitle":"clickhousectl","title":"clickhousectl","href":"/pt-BR/concepts/features/interfaces/cli"},{"sidebarTitle":"ClickHouse Client","title":"ClickHouse Client","href":"/pt-BR/concepts/features/interfaces/client"},{"sidebarTitle":"Model Context Protocol (MCP)","title":"Model Context Protocol (MCP)","href":"/pt-BR/concepts/features/interfaces/mcp"},{"group":"Drivers e interfaces","pages":[{"sidebarTitle":"Visão geral","title":"Drivers e interfaces","href":"/pt-BR/concepts/features/interfaces/overview"},{"sidebarTitle":"interface HTTP","title":"interface HTTP","href":"/pt-BR/concepts/features/interfaces/http"},{"sidebarTitle":"Formatos de enquadramento","title":"Formatos de enquadramento","href":"/pt-BR/concepts/features/interfaces/framing-formats"},{"sidebarTitle":"Interface nativa (TCP)","title":"Interface nativa (TCP)","href":"/pt-BR/concepts/features/interfaces/tcp"},{"sidebarTitle":"driver ADBC","title":"driver ADBC","href":"/pt-BR/concepts/features/interfaces/adbc"},{"sidebarTitle":"interface MySQL","title":"Interface MySQL","href":"/pt-BR/concepts/features/interfaces/mysql"},{"group":"Driver ODBC","pages":[{"sidebarTitle":"Visão geral","title":"Driver ODBC","href":"/pt-BR/concepts/features/interfaces/odbc/index"}]},{"sidebarTitle":"Interface PostgreSQL","title":"Interface PostgreSQL","href":"/pt-BR/concepts/features/interfaces/postgresql"},{"sidebarTitle":"API do Prometheus e PromQL","title":"API HTTP do Prometheus e PromQL","href":"/pt-BR/concepts/features/interfaces/prometheus"},{"sidebarTitle":"Endpoint de métricas do Prometheus","title":"Endpoint de métricas do Prometheus","href":"/pt-BR/concepts/features/interfaces/prometheus-metrics"},{"sidebarTitle":"Interface SSH","title":"Interface SSH com PTY","href":"/pt-BR/concepts/features/interfaces/ssh"},{"sidebarTitle":"Interface gRPC","title":"Interface gRPC","href":"/pt-BR/concepts/features/interfaces/grpc"},{"sidebarTitle":"Interface Arrow Flight","title":"Interface Arrow Flight","href":"/pt-BR/concepts/features/interfaces/arrowflight"}]},{"sidebarTitle":"Inferência de esquema","title":"Inferência automática de esquema a partir de dados de entrada","href":"/pt-BR/concepts/features/interfaces/schema-inference"},{"sidebarTitle":"Busca na documentação","title":"Busca na documentação","href":"/pt-BR/concepts/features/interfaces/documentation-search"},{"sidebarTitle":"Web SQL UI","title":"Web SQL UI (Play)","href":"/pt-BR/concepts/features/interfaces/web-sql"},{"sidebarTitle":"SQL Console","title":"SQL Console","href":"/pt-BR/concepts/features/interfaces/sql-console"},{"sidebarTitle":"Codificação por cores na interface web","title":"Codificação por cores na interface web","href":"/pt-BR/concepts/features/interfaces/web-ui-color-coding"},{"sidebarTitle":"Colunas fixadas na interface web","title":"Colunas fixadas na interface web","href":"/pt-BR/concepts/features/interfaces/web-ui-pinned-columns"},{"sidebarTitle":"Modo notebook da interface web","title":"Modo notebook da interface web","href":"/pt-BR/concepts/features/interfaces/web-ui-notebook"},{"sidebarTitle":"Modelagem de resultados na interface web","title":"Ordenação, filtragem e paginação na interface web","href":"/pt-BR/concepts/features/interfaces/web-ui-result-shaping"},{"sidebarTitle":"Terminal web","title":"Terminal web","href":"/pt-BR/concepts/features/interfaces/web-terminal"},{"group":"Clientes de terceiros","pages":[{"title":"Interfaces de terceiros","href":"/pt-BR/concepts/features/interfaces/third-party/index"}]}]},{"group":"Ferramentas e utilitários","pages":[{"sidebarTitle":"Lista de ferramentas e utilitários","title":"Lista de ferramentas e utilitários","mode":"wide","href":"/pt-BR/concepts/features/tools-and-utilities/index"},{"title":"clickhouse_backupview","href":"/pt-BR/concepts/features/tools-and-utilities/backupview"},{"sidebarTitle":"clickhouse-benchmark","title":"clickhouse-benchmark","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-benchmark"},{"title":"clickhouse-compressor","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-compressor"},{"sidebarTitle":"clickhouse-disks","title":"clickhouse-disks","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-disks"},{"title":"clickhouse-format","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-format"},{"sidebarTitle":"clickhouse-keeper-client","title":"utilitário clickhouse-keeper-client","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-keeper-client"},{"sidebarTitle":"API HTTP do Keeper","title":"API HTTP e painel do Keeper","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-keeper-http-api"},{"sidebarTitle":"clickhouse-local","title":"clickhouse-local","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-local"},{"title":"clickhouse-obfuscator","href":"/pt-BR/concepts/features/tools-and-utilities/clickhouse-obfuscator"},{"title":"clickhouse-odbc-bridge","href":"/pt-BR/concepts/features/tools-and-utilities/odbc-bridge"},{"title":"clickhouse-static-files-disk-uploader","href":"/pt-BR/concepts/features/tools-and-utilities/static-files-disk-uploader"}]}]},{"group":"Boas práticas","expanded":true,"pages":[{"title":"Boas práticas no ClickHouse","mode":"wide","href":"/pt-BR/concepts/best-practices/index"},{"sidebarTitle":"Como escolher uma chave primária","title":"Como escolher uma chave primária","href":"/pt-BR/concepts/best-practices/choosing-a-primary-key"},{"sidebarTitle":"Como escolher tipos de dados","title":"Como escolher tipos de dados","href":"/pt-BR/concepts/best-practices/select-data-type"},{"sidebarTitle":"Use as visões materializadas","title":"Use as visões materializadas","href":"/pt-BR/concepts/best-practices/use-materialized-views"},{"sidebarTitle":"Minimize e otimize junções","title":"Minimize e otimize junções","href":"/pt-BR/concepts/best-practices/minimize-optimize-joins"},{"sidebarTitle":"Como escolher uma chave de particionamento","title":"Como escolher uma chave de particionamento","href":"/pt-BR/concepts/best-practices/partitioning-keys"},{"sidebarTitle":"Selecionar uma estratégia de inserção","title":"Selecionar uma estratégia de inserção","href":"/pt-BR/concepts/best-practices/selecting-an-insert-strategy"},{"sidebarTitle":"Índices de omissão de dados","title":"Use índices de omissão de dados quando apropriado","href":"/pt-BR/concepts/best-practices/using-data-skipping-indices"},{"sidebarTitle":"Evite mutações","title":"Evite mutações","href":"/pt-BR/concepts/best-practices/avoid-mutations"},{"sidebarTitle":"Evite o OPTIMIZE FINAL","title":"Evite `OPTIMIZE FINAL`","href":"/pt-BR/concepts/best-practices/avoid-optimize-final"},{"sidebarTitle":"Evite colunas Nullable","title":"Evite colunas Nullable","href":"/pt-BR/concepts/best-practices/avoidnullablecolumns"},{"sidebarTitle":"Uso de JSON","title":"Use JSON quando apropriado","href":"/pt-BR/concepts/best-practices/json-type"}]}]},{"item":"Guias","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-guides.svg","pages":[{"title":"Guias","href":"/pt-BR/guides/clickhouse"}]},{"item":"Referência","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-reference.svg","pages":[{"title":"Referência","href":"/pt-BR/reference/home"}]}]},{"tab":"Soluções","menu":[{"item":"ClickHouse Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickHouse Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"ClickHouse Cloud","href":"/pt-BR/products/cloud/getting-started/cloud-get-started"}]},{"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":"/pt-BR/products/managed-postgres/overview"}]},{"item":"Langfuse","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/logo-langfuse.svg","href":"https://langfuse.com/docs"},{"item":"Código aberto","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/section-header.svg","href":"#"},{"item":"ClickStack","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickstack.svg","pages":[{"title":"ClickStack","href":"/pt-BR/clickstack"}]},{"item":"Agentic Data Stack","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-agentic-data-stack.svg","pages":[{"title":"Agentic Data Stack","href":"/pt-BR/products/agentic-data-stack/overview"}]},{"item":"chDB","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-chdb.svg","pages":[{"title":"chDB","href":"/pt-BR/chdb"}]},{"item":"Operador do Kubernetes","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-kubernetes-operator.svg","pages":[{"title":"Operador do Kubernetes","href":"/pt-BR/products/kubernetes-operator/overview"}]}],"pages":[{"title":"Soluções","href":"/pt-BR/products/cloud/getting-started/cloud-get-started"}]},{"tab":"Integrações","menu":[{"item":"Ecossistema","pages":[{"title":"Ecossistema","href":"/pt-BR/integrations/home"}]},{"item":"ClickPipes","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickpipes.svg","pages":[{"title":"ClickPipes","href":"/pt-BR/integrations/clickpipes/home"}]},{"item":"Clientes por linguagem","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-language-clients.svg","pages":[{"title":"Clientes por linguagem","href":"/pt-BR/integrations/language-clients"}]},{"item":"Conectores","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-connectors.svg","pages":[{"title":"Conectores","href":"/pt-BR/integrations/connectors/data-sources"}]}],"pages":[{"title":"Integrações","href":"/pt-BR/integrations/home"}]},{"tab":"Recursos","menu":[{"item":"Central de suporte","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-support-center.svg","pages":[{"title":"Central de suporte","href":"/pt-BR/resources/support-center/home"}]},{"item":"Desenvolvimento e contribuições","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-contribute.svg","pages":[{"title":"Desenvolvimento e contribuições","href":"/pt-BR/resources/develop-contribute/introduction/developer-instruction"}]},{"item":"Registros de alterações","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-changelogs.svg","dropdowns":[{"dropdown":"Cloud","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-clickhouse-cloud.svg","pages":[{"title":"Cloud","href":"/pt-BR/resources/changelogs/cloud"}]},{"dropdown":"Código aberto","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-server.svg","pages":[{"title":"Código aberto","href":"/pt-BR/resources/changelogs/oss/2026"}]}]},{"item":"Sobre","icon":"https://mintlify.s3.us-west-1.amazonaws.com/private-7c7dfe99/images/icons/icon-about.svg","pages":[{"title":"Sobre","href":"/pt-BR/resources/about"}]}],"pages":[{"title":"Recursos","href":"/pt-BR/resources/support-center/home"}]}]},{"language":"ru","pages":[{"title":"ru","href":"/ru/concepts/features/operations/update"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/concepts/features/operations/update"}]}]},"basePath":"","title":"Atualizando dados - ClickHouse Documentation","buildId":"dpl_Acry4NrQAgjcikyFgVE2eJ7XQCAv","deploymentId":"dpl_Acry4NrQAgjcikyFgVE2eJ7XQCAv","dynamics":[],"chunks":[]}
