Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres
Comparing counts of all tables
A simple way to validate the correctness of your data after migration is to compare the counts of all tables in the source and target databases. You can do this by running the following query on both databases:
SELECT table_name, (xpath('/row/cnt/text()', xml_count))[1]::text::bigint AS row_countFROM ( SELECT table_name, query_to_xml('SELECT count(*) AS cnt FROM ' || quote_ident(table_name), false, true, '') AS xml_count FROM information_schema.tables WHERE table_schema = 'public') tORDER BY table_name;
{"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":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"github-push-net-diff","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","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/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":"products/managed-postgres/migrations/data-validation","slug":"/products/managed-postgres/migrations/data-validation","pageMetadata":{"slug":"/cloud/managed-postgres/migrations/data-validation","sidebarTitle":"Data validation","title":"Validate data correctness after migration","description":"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres","keywords":["postgres","postgresql","logical replication","migration","data transfer","managed postgres"],"doc_type":"guide","href":"/products/managed-postgres/migrations/data-validation"},"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: \"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres\"\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={code:`code`,p:`p`,pre:`pre`,span:`span`,..._provideComponents(),...props.components},{CodeBlock,Heading}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`data-validation-counts`,children:`Comparing counts of all tables`}),`\n`,_jsx(_components.p,{children:`A simple way to validate the correctness of your data after migration is to compare the counts of all tables in the source and target databases. You can do this by running the following query on both databases:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`9`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`9`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` table_name, `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (xpath(`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'/row/cnt/text()'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, xml_count))[1]::`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`text`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`::`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`bigint`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` row_count`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` table_name, `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` query_to_xml(`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'SELECT count(*) AS cnt FROM '`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` ||`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` quote_ident(table_name), false, true, `}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`''`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` xml_count`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` FROM`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` information_schema`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`tables`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` WHERE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` table_schema `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'public'`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) t`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ORDER BY`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` table_name;`})]}),`\n`]})})})]})}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":"/cloud/managed-postgres/migrations/data-validation","sidebarTitle":"Data validation","title":"Validate data correctness after migration","description":"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres","keywords":["postgres","postgresql","logical replication","migration","data transfer","managed postgres"],"doc_type":"guide","href":"/products/managed-postgres/migrations/data-validation"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Comparing counts of all tables","slug":"data-validation-counts","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/private-7c7dfe99/f11c6dde2c89bd05/_site/customizations/ask-ai-button.js","/docs/_mintlify/custom/private-7c7dfe99/39eb0ad87fa3adc8/_site/customizations/clickhouse-sql-highlight.js","/docs/_mintlify/custom/private-7c7dfe99/f2f887f569696d41/_site/customizations/clickhouse-sql-lexer-wasm.js","/docs/_mintlify/custom/private-7c7dfe99/dce387fc81a6edfe/_site/customizations/custom-footer.js","/docs/_mintlify/custom/private-7c7dfe99/240e3ba1823c3bae/_site/customizations/galaxy.js","/docs/_mintlify/custom/private-7c7dfe99/c00e6cbded147615/_site/customizations/inkeep-init.js","/docs/_mintlify/custom/private-7c7dfe99/ad7415752a665282/_site/customizations/kapa-init.js","/docs/_mintlify/custom/private-7c7dfe99/4b6201cbf0ed537b/_site/customizations/nav-icon-preload.js","/docs/_mintlify/custom/private-7c7dfe99/10c01e58e00a0bb5/_site/customizations/navbar-cta.js","/docs/_mintlify/custom/private-7c7dfe99/f75dab9369f45602/_site/customizations/raise-issue-link.js","/docs/_mintlify/custom/private-7c7dfe99/a97e716bfafb62fd/_site/customizations/scroll-reset.js","/docs/_mintlify/custom/private-7c7dfe99/bb66ab6ab59dfc53/_site/customizations/settings-legacy-redirect.js","/docs/_mintlify/custom/private-7c7dfe99/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":"Validate data correctness after migration - ClickHouse Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/products/managed-postgres/migrations/data-validation","matchLevel":0},"ar":{"href":"/ar/products/managed-postgres/migrations/data-validation","matchLevel":1},"es":{"href":"/es/products/managed-postgres/migrations/data-validation","matchLevel":1},"fr":{"href":"/fr/products/managed-postgres/migrations/data-validation","matchLevel":1},"ja":{"href":"/ja/products/managed-postgres/migrations/data-validation","matchLevel":1},"ko":{"href":"/ko/products/managed-postgres/migrations/data-validation","matchLevel":1},"pt-BR":{"href":"/pt-BR/products/managed-postgres/migrations/data-validation","matchLevel":1},"ru":{"href":"/ru/products/managed-postgres/migrations/data-validation","matchLevel":1},"zh":{"href":"/zh/products/managed-postgres/migrations/data-validation","matchLevel":1}}},"originalFileLocation":"products/managed-postgres/migrations/data-validation.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=\"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres\">\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=\"Validate data correctness after migration - ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickHouse Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation\">\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=Migrations\u0026amp;title=Validate+data+correctness+after+migration\u0026amp;description=Learn+how+to+validate+the+correctness+of+your+data+after+migrating+to+ClickHouse+Managed+Postgres\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=8de565def5d8b14822aba4a72f9f0274ee161b791de209baab244c0475ffc77b\">\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=\"Validate data correctness after migration - ClickHouse Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://private-7c7dfe99.mintlify.site/docs/_mintlify/api/og/v2?division=Migrations\u0026amp;title=Validate+data+correctness+after+migration\u0026amp;description=Learn+how+to+validate+the+correctness+of+your+data+after+migrating+to+ClickHouse+Managed+Postgres\u0026amp;theme=5eb4cbc708d7519bb2d2fc2e\u0026amp;signature=8de565def5d8b14822aba4a72f9f0274ee161b791de209baab244c0475ffc77b\">\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/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/products/managed-postgres/migrations/data-validation.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ar\" href=\"https://clickhouse.com/docs/ar/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://clickhouse.com/docs/es/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://clickhouse.com/docs/fr/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://clickhouse.com/docs/ja/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://clickhouse.com/docs/ko/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://clickhouse.com/docs/pt-BR/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ru\" href=\"https://clickhouse.com/docs/ru/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://clickhouse.com/docs/zh/products/managed-postgres/migrations/data-validation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation\">\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/products/managed-postgres/migrations/data-validation#webpage\",\"url\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation\",\"name\":\"Validate data correctness after migration\",\"description\":\"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres\",\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"},\"breadcrumb\":{\"@id\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Migrations\",\"item\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Validate data correctness after migration\",\"item\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation#article\",\"headline\":\"Validate data correctness after migration\",\"name\":\"Validate data correctness after migration\",\"description\":\"Learn how to validate the correctness of your data after migrating to ClickHouse Managed Postgres\",\"url\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation\",\"mainEntityOfPage\":{\"@id\":\"https://clickhouse.com/docs/products/managed-postgres/migrations/data-validation#webpage\"},\"keywords\":\"postgres, postgresql, logical replication, migration, data transfer, managed postgres\",\"publisher\":{\"@id\":\"https://clickhouse.com/#organization\"},\"isPartOf\":{\"@id\":\"https://clickhouse.com/docs#website\"}}]}\u003c/script>","agentPointerHref":"/docs/products/managed-postgres/migrations/data-validation.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","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","groups":[{"group":"Get started","pages":[{"title":"ClickHouse Managed Postgres","href":"/products/managed-postgres/overview"},{"sidebarTitle":"Quickstart","title":"Quickstart for ClickHouse Managed Postgres","href":"/products/managed-postgres/quickstart"}]},{"group":"Features","pages":[{"sidebarTitle":"Connection","title":"Connecting to ClickHouse Managed Postgres","href":"/products/managed-postgres/connection"},{"sidebarTitle":"Settings","title":"Settings","href":"/products/managed-postgres/settings"},{"sidebarTitle":"Scaling","title":"Scaling","href":"/products/managed-postgres/scaling"},{"sidebarTitle":"Security","title":"Security","href":"/products/managed-postgres/security"},{"sidebarTitle":"RBAC","title":"ClickHouse Managed Postgres RBAC","href":"/products/managed-postgres/rbac"},{"sidebarTitle":"Local development","title":"Local development environments","href":"/products/managed-postgres/local-development"},{"sidebarTitle":"High availability","title":"High availability","href":"/products/managed-postgres/high-availability"},{"sidebarTitle":"Read replicas","title":"Read replicas","href":"/products/managed-postgres/read-replicas"},{"sidebarTitle":"Backup and restore","title":"Backup and restore","href":"/products/managed-postgres/backup-and-restore"},{"sidebarTitle":"Branching","title":"Branching","href":"/products/managed-postgres/branching"},{"sidebarTitle":"Extensions","title":"PostgreSQL extensions","href":"/products/managed-postgres/extensions"},{"group":"pg_clickhouse","pages":[{"sidebarTitle":"Introduction","title":"pg_clickhouse documentation","href":"/products/managed-postgres/extensions/pg_clickhouse/introduction"},{"sidebarTitle":"Reference","title":"pg_clickhouse reference documentation","href":"/products/managed-postgres/extensions/pg_clickhouse/reference"},{"sidebarTitle":"Tutorial","title":"pg_clickhouse tutorial","href":"/products/managed-postgres/extensions/pg_clickhouse/tutorial"}]},{"group":"pg_chdb","pages":[{"sidebarTitle":"Introduction","title":"chdb Extensions documentation","href":"/products/managed-postgres/extensions/chdb/introduction"},{"sidebarTitle":"chdb","title":"chdb Extension reference documentation","href":"/products/managed-postgres/extensions/chdb/chdb"},{"sidebarTitle":"chdb_hook","title":"chdb_hook Module reference documentation","href":"/products/managed-postgres/extensions/chdb/chdb_hook"}]},{"sidebarTitle":"Upgrades","title":"Upgrades","href":"/products/managed-postgres/upgrades"},{"sidebarTitle":"OpenAPI","title":"ClickHouse Managed Postgres OpenAPI","href":"/products/managed-postgres/openapi"},{"sidebarTitle":"Terraform","title":"ClickHouse Managed Postgres Terraform reference","href":"/products/managed-postgres/terraform"}]},{"group":"Guides","pages":[{"sidebarTitle":"Bun","title":"Use Bun with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/bun"},{"sidebarTitle":"Cloudflare Workers","title":"Use Cloudflare Workers with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/cloudflare-workers"},{"sidebarTitle":"Django","title":"Use Django with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/django"},{"sidebarTitle":".NET (EF Core)","title":"Use .NET and Entity Framework Core with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/dotnet"},{"sidebarTitle":"Drizzle ORM","title":"Use Drizzle ORM with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/drizzle"},{"sidebarTitle":"FastAPI and SQLAlchemy","title":"Use FastAPI and SQLAlchemy with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/fastapi"},{"sidebarTitle":"Go (pgx)","title":"Use Go (pgx) with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/go"},{"sidebarTitle":"Kysely","title":"Use Kysely with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/kysely"},{"sidebarTitle":"Laravel","title":"Use Laravel with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/laravel"},{"sidebarTitle":"Node.js","title":"Use Node.js with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/nodejs"},{"sidebarTitle":"Phoenix (Ecto)","title":"Use Phoenix with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/phoenix"},{"sidebarTitle":"Prisma","title":"Use Prisma with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/prisma"},{"sidebarTitle":"Ruby on Rails","title":"Use Ruby on Rails with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/ruby-on-rails"},{"sidebarTitle":"Rust (sqlx)","title":"Use Rust (sqlx) with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/rust"},{"sidebarTitle":"Spring Boot","title":"Use Spring Boot with ClickHouse Managed Postgres","href":"/products/managed-postgres/guides/spring-boot"}]},{"group":"Pricing","pages":[{"sidebarTitle":"Pricing","title":"Pricing","href":"/products/managed-postgres/pricing"}]},{"group":"ClickHouse Integration","pages":[{"sidebarTitle":"ClickPipes","title":"Sync to ClickHouse with ClickPipes","href":"/products/managed-postgres/sync-to-clickhouse/clickpipes"},{"sidebarTitle":"WalShadow","title":"Sync to ClickHouse with WalShadow","href":"/products/managed-postgres/sync-to-clickhouse/walshadow"}]},{"group":"Migrations","pages":[{"sidebarTitle":"Overview","title":"ClickHouse Managed Postgres data migration","href":"/products/managed-postgres/migrations/overview"},{"sidebarTitle":"ClickPipes","title":"Migrate PostgreSQL data using Data sources in ClickPipes","description":"Learn how to migrate your PostgreSQL database to ClickHouse Managed Postgres using ClickPipes.","href":"/products/managed-postgres/migrations/clickpipes"},{"sidebarTitle":"Data validation","title":"Validate data correctness after migration","href":"/products/managed-postgres/migrations/data-validation"},{"sidebarTitle":"Logical replication","title":"Migrate to ClickHouse Managed Postgres using logical replication","description":"Learn how to migrate your PostgreSQL data to ClickHouse Managed Postgres using logical replication","href":"/products/managed-postgres/migrations/logical-replication"},{"sidebarTitle":"Neon","title":"Migrate from Neon to ClickHouse Managed Postgres","href":"/products/managed-postgres/migrations/neon"},{"sidebarTitle":"pg_dump and pg_restore","title":"Migrate to ClickHouse Managed Postgres using pg_dump and pg_restore","href":"/products/managed-postgres/migrations/pg_dump-pg_restore"},{"sidebarTitle":"PeerDB","title":"Migrate to ClickHouse Managed Postgres using PeerDB","href":"/products/managed-postgres/migrations/peerdb"},{"sidebarTitle":"FAQ","title":"ClickHouse Managed Postgres migrations FAQ","href":"/products/managed-postgres/migrations/faq"}]},{"group":"Monitoring","pages":[{"sidebarTitle":"Overview","title":"ClickHouse Managed Postgres monitoring","href":"/products/managed-postgres/monitoring/overview"},{"sidebarTitle":"Dashboard","title":"ClickHouse Managed Postgres monitoring dashboard","href":"/products/managed-postgres/monitoring/dashboard"},{"sidebarTitle":"Metrics reference","title":"ClickHouse Managed Postgres metrics reference","href":"/products/managed-postgres/monitoring/metrics"},{"sidebarTitle":"Prometheus endpoint","title":"ClickHouse Managed Postgres Prometheus integration","href":"/products/managed-postgres/monitoring/prometheus"},{"sidebarTitle":"Query insights","title":"Postgres query insights","href":"/products/managed-postgres/monitoring/query-insights"},{"sidebarTitle":"Notifications","title":"ClickHouse Managed Postgres notifications","href":"/products/managed-postgres/monitoring/notifications"}]},{"group":"FAQ","pages":[{"sidebarTitle":"FAQ","title":"ClickHouse Managed Postgres FAQ","href":"/products/managed-postgres/faq"}]}]}]},{"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/products/managed-postgres/migrations/data-validation"}]},{"language":"es","pages":[{"title":"es","href":"/es/products/managed-postgres/migrations/data-validation"}]},{"language":"fr","pages":[{"title":"fr","href":"/fr/products/managed-postgres/migrations/data-validation"}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/products/managed-postgres/migrations/data-validation"}]},{"language":"ko","pages":[{"title":"ko","href":"/ko/products/managed-postgres/migrations/data-validation"}]},{"language":"pt-BR","pages":[{"title":"pt-BR","href":"/pt-BR/products/managed-postgres/migrations/data-validation"}]},{"language":"ru","pages":[{"title":"ru","href":"/ru/products/managed-postgres/migrations/data-validation"}]},{"language":"zh","pages":[{"title":"zh","href":"/zh/products/managed-postgres/migrations/data-validation"}]}]},"basePath":"","title":"Validate data correctness after migration - ClickHouse Documentation","deploymentId":"dpl_2MqcLy8smQrrovUehgcZEsoo1tJX","buildId":"dpl_2MqcLy8smQrrovUehgcZEsoo1tJX","dynamics":[],"chunks":[]}