Syncing tables will allow you to view table and column names in the dataset editor,
as well as use autocomplete when writing SQL. It is recommended that you sync tables
when adding a new schema to Explo, or when new tables are added into your database
or warehouse.You can sync tables by clicking on the triple dot menu to the right of the schema.From here, you can select the specific tables that you plan on querying from while
using Explo. Note that all tables will still be accessible in the dataset editor,
but only synced tables will show up with autocomplete.Click continue and the tables should be synced! This may take a little while if the tables
are particularly large. Note that a schema only syncs tables taken from the default data
source for that schema.
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Explo","colors":{"primary":"#0069ED","light":"#4D9CFF","dark":"#0050B4"},"favicon":"/favicon.png","logo":{"light":"https://mintcdn.com/explo/W1dLS0orXWucM1gW/logo/light.svg?fit=max\u0026auto=format\u0026n=W1dLS0orXWucM1gW\u0026q=85\u0026s=e0479125df798410f4acd8938e757e9b","dark":"https://mintcdn.com/explo/W1dLS0orXWucM1gW/logo/dark.svg?fit=max\u0026auto=format\u0026n=W1dLS0orXWucM1gW\u0026q=85\u0026s=820b9961213857a8d31d7186a74d4d7c"},"api":{"mdx":{"server":"https://api.explo.co","auth":{"method":"key","name":"Explo-Authorization"}}},"navbar":{"links":[{"label":"Take a tour","href":"https://try.explo.co/?utm_source=docs"}],"primary":{"type":"button","label":"Request free trial","href":"https://www.explo.co/book-a-demo"}},"seo":{"metatags":{"og:title":"Explo | Customer-facing analytics for any platform","og:image":"https://uploads-ssl.webflow.com/62f681c18d50329187681754/654198e19dd9d2a6544daab9_new%20OgImage.png","og:description":"An embedded analytics solution for product and engineering teams. Interactive dashboards, self-serve reporting, Explo AI, and enterprise-grade security all for your end users."},"indexing":"navigable"},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"explo","hasAudioNarration":false,"actualSubdomain":"explo","customDomains":["docs.explo.co"],"gitSource":{"type":"github","owner":"trust-kaz","repo":"embeddo","deployBranch":"main","contentDirectory":"docs","mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6ae913e621cf493fcfb30d6f:success","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"default","tag":"Documentation","count":174},{"language":"default","tag":"Dashboards","count":89},{"language":"default","tag":"Creating Dashboards","count":67},{"language":"default","tag":"API Reference","count":34},{"language":"default","tag":"Data","count":32},{"language":"default","tag":"Visualizations","count":30},{"language":"default","tag":"Dashboard Features","count":22},{"language":"default","tag":"Connecting to Data Sources","count":20},{"language":"default","tag":"All Charts","count":19},{"language":"default","tag":"UI Elements","count":17}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"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":"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":"site-roles","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":[]}
{"page":{"pagePath":"data-sources/data-sources-and-schema/sync-new-tables","slug":"/data-sources/data-sources-and-schema/sync-new-tables","pageMetadata":{"title":"Sync Tables","description":"Sync tables in your database","href":"/data-sources/data-sources-and-schema/sync-new-tables"},"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: \"Sync tables in your database\"\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={p:`p`,..._provideComponents(),...props.components},{OptimizedImage}=_components;if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Syncing tables will allow you to view table and column names in the dataset editor,\nas well as use autocomplete when writing SQL. It is recommended that you sync tables\nwhen adding a new schema to Explo, or when new tables are added into your database\nor warehouse.`}),`\n`,_jsx(_components.p,{children:`You can sync tables by clicking on the triple dot menu to the right of the schema.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables.png?fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=eb06865946b5acecd94c06576724c9da`,alt:``,\"data-og-width\":`991`,width:`991`,\"data-og-height\":`434`,height:`434`,\"data-path\":`images/data-sources/sync-tables.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables.png?w=280\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=be2b0e48f3200b4e8d3fd60c08f987de 280w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables.png?w=560\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=f6c39da5f46010e8568ad9a43a41ff0c 560w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables.png?w=840\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=77a8dd8a80a01ca2384627f103e40925 840w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=aa993f1c28e957abc6062b1d82eb2e58 1100w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=d66e78727206c639ebb7bb895c82b168 1650w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=c2086379d604b3d4ba9f6309499f7e4c 2500w`}),`\n`,_jsx(_components.p,{children:`From here, you can select the specific tables that you plan on querying from while\nusing Explo. Note that all tables will still be accessible in the dataset editor,\nbut only synced tables will show up with autocomplete.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables-2.png?fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=0e9a968e44ebdbb601cca9156749e9df`,alt:``,\"data-og-width\":`997`,width:`997`,\"data-og-height\":`618`,height:`618`,\"data-path\":`images/data-sources/sync-tables-2.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables-2.png?w=280\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=f4b55e6739f9d68719669a35353ca031 280w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables-2.png?w=560\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=534d3a33c852892a9cb00eb902e186b1 560w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables-2.png?w=840\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=b21e9596ec4c8eb75f423a64bcbc1795 840w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables-2.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=a50c086caaebb08288f384f754a0010c 1100w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables-2.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=dc7485d0c53e70dfb7336a7a31ac535c 1650w, https://mintcdn.com/explo/PKkXxOQ4Cq1reQN8/images/data-sources/sync-tables-2.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PKkXxOQ4Cq1reQN8\u0026q=85\u0026s=7940ce06850f3478c4317527dc82ad6a 2500w`}),`\n`,_jsx(_components.p,{children:`Click continue and the tables should be synced! This may take a little while if the tables\nare particularly large. Note that a schema only syncs tables taken from the default data\nsource for that schema.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Sync Tables","description":"Sync tables in your database","href":"/data-sources/data-sources-and-schema/sync-new-tables"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"explo","siteName":"Explo","title":"Explo | Customer-facing analytics for any platform","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2025-10-15T03:46:06.092Z","originalFileLocation":"data-sources/data-sources-and-schema/sync-new-tables.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Sync tables in your database\">\u003cmeta data-mint-head name=\"application-name\" content=\"Explo\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Explo | Customer-facing analytics for any platform\">\u003cmeta data-mint-head property=\"og:description\" content=\"An embedded analytics solution for product and engineering teams. Interactive dashboards, self-serve reporting, Explo AI, and enterprise-grade security all for your end users.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Explo\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://uploads-ssl.webflow.com/62f681c18d50329187681754/654198e19dd9d2a6544daab9_new%20OgImage.png\">\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=\"Explo | Customer-facing analytics for any platform\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"An embedded analytics solution for product and engineering teams. Interactive dashboards, self-serve reporting, Explo AI, and enterprise-grade security all for your end users.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://uploads-ssl.webflow.com/62f681c18d50329187681754/654198e19dd9d2a6544daab9_new%20OgImage.png\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/explo/Redz2LxTO0BDLUHi/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Explo\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#0069ED\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/data-sources/data-sources-and-schema/sync-new-tables.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.explo.co/#organization\",\"name\":\"Explo\",\"url\":\"https://docs.explo.co\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/explo/W1dLS0orXWucM1gW/logo/light.svg?fit=max\u0026auto=format\u0026n=W1dLS0orXWucM1gW\u0026q=85\u0026s=e0479125df798410f4acd8938e757e9b\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.explo.co#website\",\"name\":\"Explo\",\"url\":\"https://docs.explo.co\",\"publisher\":{\"@id\":\"https://docs.explo.co/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables#webpage\",\"url\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables\",\"name\":\"Sync Tables\",\"description\":\"Sync tables in your database\",\"dateModified\":\"2025-10-15T03:46:06.092Z\",\"isPartOf\":{\"@id\":\"https://docs.explo.co#website\"},\"breadcrumb\":{\"@id\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Data\",\"item\":\"https://docs.explo.co/data-sources/connecting-to-data-sources/connectivity-regions\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Sources and Schema\",\"item\":\"https://docs.explo.co/data-sources/data-sources-and-schema\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Sync Tables\",\"item\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables#article\",\"headline\":\"Sync Tables\",\"name\":\"Sync Tables\",\"description\":\"Sync tables in your database\",\"url\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables\",\"mainEntityOfPage\":{\"@id\":\"https://docs.explo.co/data-sources/data-sources-and-schema/sync-new-tables#webpage\"},\"image\":\"https://uploads-ssl.webflow.com/62f681c18d50329187681754/654198e19dd9d2a6544daab9_new%20OgImage.png\",\"dateModified\":\"2025-10-15T03:46:06.092Z\",\"publisher\":{\"@id\":\"https://docs.explo.co/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.explo.co#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Explo\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Explo\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/data-sources/data-sources-and-schema/sync-new-tables.md","siteName":"Explo","nav":{"global":null,"anchors":[{"anchor":"Documentation","icon":"book-open","groups":[{"group":"Home","pages":[{"title":"Explo Help Desk","href":"/explo-help-desk"},{"title":"FAQ","href":"/faqs"}]},{"group":"Customers","pages":[{"title":"Overview","href":"/customers/overview"},{"title":"Customer Hierarchy","href":"/customers/customer-hierarchy"},{"title":"Group Tags","href":"/customers/group-tags"}]},{"group":"Data","pages":[{"group":"Connecting to Data Sources","pages":[{"title":"Connectivity Regions","href":"/data-sources/connecting-to-data-sources/connectivity-regions"},{"title":"SSH Tunnels","href":"/data-sources/connecting-to-data-sources/ssh-tunnels"},{"title":"AWS PrivateLink","href":"/data-sources/connecting-to-data-sources/aws-private-link"},{"group":"Data Source Types","pages":[{"title":"Athena","href":"/data-sources/connecting-to-data-sources/data-source-types/athena"},{"title":"Azure SQL DB","href":"/data-sources/connecting-to-data-sources/data-source-types/azure"},{"title":"BigQuery","href":"/data-sources/connecting-to-data-sources/data-source-types/big-query"},{"title":"Clickhouse","href":"/data-sources/connecting-to-data-sources/data-source-types/clickhouse"},{"title":"CockroachDB","href":"/data-sources/connecting-to-data-sources/data-source-types/cockroachdb"},{"title":"Databricks","href":"/data-sources/connecting-to-data-sources/data-source-types/databricks"},{"title":"Materialize","href":"/data-sources/connecting-to-data-sources/data-source-types/materialize"},{"title":"Microsoft SQL Server","href":"/data-sources/connecting-to-data-sources/data-source-types/microsoft-sql-server"},{"title":"MotherDuck","href":"/data-sources/connecting-to-data-sources/data-source-types/motherduck"},{"title":"MySQL","href":"/data-sources/connecting-to-data-sources/data-source-types/mysql"},{"title":"Parade DB","href":"/data-sources/connecting-to-data-sources/data-source-types/parade-db"},{"title":"Postgres","href":"/data-sources/connecting-to-data-sources/data-source-types/postgres"},{"title":"Redshift","href":"/data-sources/connecting-to-data-sources/data-source-types/redshift"},{"title":"SingleStore","href":"/data-sources/connecting-to-data-sources/data-source-types/singlestore"},{"title":"Snowflake","href":"/data-sources/connecting-to-data-sources/data-source-types/snowflake"},{"title":"Supabase","href":"/data-sources/connecting-to-data-sources/data-source-types/supabase"},{"title":"Timescale","href":"/data-sources/connecting-to-data-sources/data-source-types/timescale"}]}]},{"group":"Data Sources and Schema","pages":[{"title":"Overview","href":"/data-sources/data-sources-and-schema"},{"title":"Managing Schema","href":"/data-sources/data-sources-and-schema/managing-schema"},{"title":"Multiple Data Sources","description":"This guide describes how to configure Explo to support multiple data sources","href":"/data-sources/data-sources-and-schema/multiple-data-sources"},{"title":"Sync Tables","href":"/data-sources/data-sources-and-schema/sync-new-tables"}]},{"group":"Data Library","pages":[{"title":"Overview","description":"Understanding the Data Library and its components","href":"/data-sources/data-library/overview"},{"title":"Global Datasets","href":"/data-sources/data-library/global-datasets"},{"title":"Local Datasets","href":"/data-sources/data-library/local-datasets"},{"title":"FAQ","href":"/data-sources/data-library/faq"}]},{"title":"Building your data model","href":"/data-sources/building-your-data-model"},{"group":"Data Connector (FIDO)","pages":[{"title":"General","href":"/data-sources/fido/general"},{"title":"How to Migrate","href":"/data-sources/fido/how-to-migrate"},{"title":"Data Source Specifics","href":"/data-sources/fido/data-source-specifics"}]}]},{"group":"Dashboards","pages":[{"group":"Creating Dashboards","pages":[{"title":"Creating My First Dashboard","href":"/getting-started/creating-my-first-dashboard"},{"title":"Dataset Editor","href":"/creating-dashboards/dataset-editor"},{"title":"Debugger Panel","href":"/creating-dashboards/debugger-panel"},{"group":"Variables","pages":[{"title":"Overview","href":"/creating-dashboards/variables"},{"group":"Types of Variables","pages":[{"title":"Overview","href":"/creating-dashboards/variables/types-of-variables"},{"title":"Customer-Specific Variables","href":"/creating-dashboards/variables/types-of-variables/customer-object"},{"title":"Dashboard Elements (Controls)","href":"/creating-dashboards/variables/types-of-variables/dashboard-elements-controls"},{"title":"Data Panels (Drilldowns)","href":"/creating-dashboards/variables/types-of-variables/data-panels-drilldowns"},{"title":"Embed Variables","href":"/creating-dashboards/variables/types-of-variables/embed-variables"},{"title":"Dataset Fields","href":"/creating-dashboards/variables/types-of-variables/dataset-fields"},{"title":"Raw Variables","href":"/creating-dashboards/variables/types-of-variables/raw-variables"}]},{"title":"Passing in Variables","href":"/creating-dashboards/variables/passing-in-variables"},{"title":"Using Variables","href":"/creating-dashboards/variables/using-variables"},{"title":"Tips","href":"/creating-dashboards/variables/tips"}]},{"group":"Visualizations","pages":[{"group":"All Charts","pages":[{"title":"Area Chart","href":"/creating-dashboards/visualizations/charts/area-chart"},{"title":"Bar Chart","href":"/creating-dashboards/visualizations/charts/bar-chart"},{"title":"Box Plot","href":"/creating-dashboards/visualizations/charts/box-plot"},{"title":"Choropleth Map","href":"/creating-dashboards/visualizations/charts/choropleth-map"},{"title":"Collapsible List","href":"/creating-dashboards/visualizations/charts/collapsible-list"},{"title":"Data Table","href":"/creating-dashboards/visualizations/charts/data-table"},{"title":"Density Heat Map","href":"/creating-dashboards/visualizations/charts/density-heat-map"},{"title":"Funnel Chart","href":"/creating-dashboards/visualizations/charts/funnel-chart"},{"title":"Heat Map","href":"/creating-dashboards/visualizations/charts/heat-map"},{"title":"KPI","href":"/creating-dashboards/visualizations/charts/kpi"},{"title":"KPI Trend","href":"/creating-dashboards/visualizations/charts/kpi-trend"},{"title":"Line Chart","href":"/creating-dashboards/visualizations/charts/line-chart"},{"title":"Location Marker Map","href":"/creating-dashboards/visualizations/charts/location-marker-map"},{"title":"Pie Chart","href":"/creating-dashboards/visualizations/charts/pie-chart"},{"title":"Pivot Table","href":"/creating-dashboards/visualizations/charts/pivot-table"},{"title":"Pivot Table V2","href":"/creating-dashboards/visualizations/charts/pivot-table-v2"},{"title":"Sankey Chart","href":"/creating-dashboards/visualizations/charts/sankey"},{"title":"Scatter Plot","href":"/creating-dashboards/visualizations/charts/scatter-plot"},{"title":"Spider Chart","href":"/creating-dashboards/visualizations/charts/spider-chart"}]},{"title":"Data Tab","href":"/creating-dashboards/visualizations/data-tab"},{"group":"Format Tab","pages":[{"title":"Overview","href":"/creating-dashboards/visualizations/format-tab/overview"},{"title":"Data Labels","href":"/creating-dashboards/visualizations/format-tab/data-labels"},{"title":"Chart Level Filters","href":"/creating-dashboards/visualizations/format-tab/chart-level-filters"},{"title":"Custom Formulas","href":"/creating-dashboards/visualizations/format-tab/custom-formulas"},{"title":"Goal Lines","href":"/creating-dashboards/visualizations/format-tab/goal-lines"},{"title":"KPI Value","href":"/creating-dashboards/visualizations/format-tab/kpi-values"},{"title":"Legends","href":"/creating-dashboards/visualizations/format-tab/legends"},{"title":"Table Value Formatting","href":"/creating-dashboards/visualizations/format-tab/value-formatting"},{"title":"X Axis","href":"/creating-dashboards/visualizations/format-tab/x-axis"},{"title":"Y Axis","href":"/creating-dashboards/visualizations/format-tab/y-axis"}]}]},{"group":"UI Elements","pages":[{"title":"Overview","href":"/creating-dashboards/ui-elements"},{"group":"Controls","pages":[{"title":"Dropdown","href":"/creating-dashboards/ui-elements/controls/dropdown"},{"title":"Toggle","href":"/creating-dashboards/ui-elements/controls/toggle"},{"title":"Date","href":"/creating-dashboards/ui-elements/controls/date"},{"title":"Switch","href":"/creating-dashboards/ui-elements/controls/switch"},{"title":"Slider","href":"/creating-dashboards/ui-elements/controls/slider"},{"title":"Text Input","href":"/creating-dashboards/ui-elements/controls/text-input"},{"title":"Time Dropdown","href":"/creating-dashboards/ui-elements/controls/time-dropdown"},{"title":"Date Group Toggle","href":"/creating-dashboards/ui-elements/controls/date-group-toggle"},{"title":"Apply Filter Button","href":"/creating-dashboards/ui-elements/controls/apply-filter-button"},{"title":"Refresh Dashboard Button","href":"/creating-dashboards/ui-elements/controls/refresh-dashboard-button"},{"title":"JS Event Button","href":"/creating-dashboards/ui-elements/controls/js-event-button"}]},{"group":"Export","pages":[{"title":"Share Button","href":"/creating-dashboards/ui-elements/export/share-button"}]},{"group":"Display","pages":[{"title":"Text","href":"/creating-dashboards/ui-elements/display/text"},{"title":"Image","href":"/creating-dashboards/ui-elements/display/image"},{"title":"Container","href":"/creating-dashboards/ui-elements/display/container"},{"title":"IFrame","href":"/creating-dashboards/ui-elements/display/iframe"}]}]},{"group":"Drilldowns","pages":[{"title":"Overview","href":"/creating-dashboards/drilldowns"},{"title":"Underlying Data Drilldowns","href":"/creating-dashboards/drilldowns/underlying-data-drilldowns"},{"group":"Filter Drilldowns","pages":[{"title":"Overview","href":"/creating-dashboards/drilldowns/filter-drilldowns"},{"title":"Bar Charts","href":"/creating-dashboards/drilldowns/filter-drilldowns/bar-charts"},{"title":"Data Tables","href":"/creating-dashboards/drilldowns/filter-drilldowns/data-tables"}]},{"title":"Dashboard Drilldowns","href":"/creating-dashboards/drilldowns/dashboard-drilldowns"}]}]},{"group":"Dashboard Features","pages":[{"group":"Styling Dashboards","pages":[{"title":"Custom Styles","href":"/dashboard-features/styling-dashboards"},{"title":"Custom Fonts","href":"/dashboard-features/styling-dashboards/custom-fonts"}]},{"group":"Email Reporting","pages":[{"title":"Get Access","href":"/dashboard-features/email-reporting"},{"title":"Scheduling Emails","href":"/dashboard-features/email-reporting/scheduling-emails"},{"title":"Email-specific Dashboard Configuration","href":"/dashboard-features/email-reporting/email-specific-dashboard-configuration"},{"title":"Email Layout Configuration","href":"/dashboard-features/email-reporting/email-layout-configuration"},{"title":"Email Networking","href":"/dashboard-features/email-reporting/email-networking"}]},{"group":"Editable Dashboard Sections","pages":[{"title":"What is an Editable Dashboard Section?","href":"/dashboard-features/editable-dashboard-sections"},{"title":"Configuring Editable Dashboard Sections","href":"/dashboard-features/editable-dashboard-sections/configuring-editable-dashboard-sections"},{"title":"Previewing an Editable Dashboard Section","href":"/dashboard-features/editable-dashboard-sections/previewing-an-editable-dashboard-section"},{"title":"How End Users Configure an Editable Dashboard Section","href":"/dashboard-features/editable-dashboard-sections/end-user-configuration-of-section"},{"title":"FAQ","href":"/dashboard-features/editable-dashboard-sections/faq"}]},{"group":"Dashboard Attributes","pages":[{"title":"Overview","href":"/dashboard-features/dashboard-attributes"},{"title":"Assigning Values","href":"/dashboard-features/dashboard-attributes/assigning-values"},{"title":"Using Assigned Values","href":"/dashboard-features/dashboard-attributes/using-assigned-values"}]},{"title":"Setting Category Colors","href":"/dashboard-features/setting-color-categories"},{"title":"Custom Menu","href":"/dashboard-features/custom-menu"},{"title":"Row Level Actions","href":"/dashboard-features/row-level-actions"},{"title":"Dashboard Caching","href":"/dashboard-features/dashboard-caching"},{"title":"Dashboard State Persistence","href":"/dashboard-features/dashboard-state-persistence"},{"title":"Duplicating Dashboards","href":"/dashboard-features/duplicating-dashboards"},{"title":"Custom Map Boundaries","href":"/dashboard-features/custom-map-boundaries"}]}]},{"group":"Report Builders","pages":[{"group":"Creating Report Builders","pages":[{"title":"Datasets","href":"/creating-report-builders/datasets"},{"title":"Built In Reports","href":"/creating-report-builders/built-in-reports"}]},{"group":"Report Builder Features","pages":[{"title":"Custom Aggregations","href":"/report-builder-features/custom-aggregations"},{"title":"Duplicating Report Builders","href":"/report-builder-features/duplicating-report-builders"},{"title":"Read-Only Report Builders","href":"/report-builder-features/read-only"},{"title":"Report Builder AI","href":"/report-builder-features/report-builder-ai"}]}]},{"group":"Embedding Documentation","pages":[{"title":"Add Explo Domains To CSP","href":"/embedding-documentation/add-explo-domains-to-csp"},{"title":"Allowlisting your domain","href":"/embedding-documentation/allowlisting-your-domain"},{"group":"Embed secrets (JWTs)","pages":[{"title":"Overview","href":"/embedding-documentation/embed-secrets/intro"},{"title":"Generating a JWT","href":"/embedding-documentation/embed-secrets/generating-jwt"},{"title":"Testing JWTs","href":"/embedding-documentation/embed-secrets/testing-jwt"},{"title":"Refreshing Expired JWTs","href":"/embedding-documentation/embed-secrets/refreshing-expired-jwt"}]},{"group":"Dashboard Embedding","pages":[{"title":"Option 1: Web Component","href":"/embedding-documentation/dashboard/option-1-web-component"},{"title":"Option 2: IFrame","href":"/embedding-documentation/dashboard/option-2-iframe"},{"title":"Option 3: Customer Portal","href":"/embedding-documentation/dashboard/option-3-customer-portal"}]},{"group":"Report Builder Embedding","pages":[{"title":"Option 1: Web Component","href":"/embedding-documentation/report-builder/rb-option-1-web-component"},{"title":"Option 2: IFrame","href":"/embedding-documentation/report-builder/rb-option-2-iframe"},{"title":"General Notes","href":"/embedding-documentation/report-builder/general-embedding-notes"}]},{"title":"IFrame vs Web Component","href":"/embedding-documentation/web-component-vs-iframe"},{"title":"Troubleshooting Your Embed","href":"/embedding-documentation/troubleshooting-your-embed"}]},{"group":"Data Share","pages":[{"title":"Overview","href":"/data-share/overview"},{"title":"Getting Started","href":"/data-share/getting-started"},{"title":"S3 Setup","href":"/data-share/s3-setup"},{"title":"SFTP Setup","href":"/data-share/sftp-setup"}]},{"group":"AI Features","pages":[{"title":"AI Acknowledgement","href":"/security/ai-acknowledgement"},{"title":"Context Setting","href":"/ai-features/context-setting"}]},{"group":"General Features","pages":[{"group":"Version Control","pages":[{"title":"Viewing Versions","href":"/general-features/version-control/viewing-versions"},{"title":"Editing the Current Draft","href":"/general-features/version-control/editing-the-current-draft"},{"title":"Publishing a New Version","href":"/general-features/version-control/publishing-a-new-version"},{"title":"Reverting Versions","href":"/general-features/version-control/reverting-versions"},{"title":"Managing Environment Tags","href":"/general-features/version-control/managing-environment-tags"},{"title":"Embedding Environments","href":"/general-features/version-control/embedding-environments"}]},{"title":"Analytics Reporting","href":"/general-features/analytics-reporting"},{"title":"Internationalization","href":"/general-features/internationalization"},{"title":"Timezones","href":"/general-features/timezones"},{"group":"Custom JS Events","pages":[{"title":"Overview","href":"/general-features/custom-js-events"},{"group":"Incoming JS Events to Consume","pages":[{"title":"Incoming Events","href":"/general-features/custom-js-events/incoming-events"},{"title":"Web Component Example","href":"/general-features/custom-js-events/incoming-events/web-component-example"},{"title":"Iframe Example","href":"/general-features/custom-js-events/incoming-events/iframe-example"}]},{"title":"Outgoing JS Events to Emit","href":"/general-features/custom-js-events/outgoing-events"},{"title":"Editable Sections Example Code","href":"/general-features/custom-js-events/editable-sections-example-code"}]},{"title":"Embed ID Page","href":"/general-features/embed-id-page"},{"title":"Exporting Features","href":"/general-features/exporting-features"}]},{"group":"Managing Permissions","pages":[{"title":"Data Visibility Groups","href":"/managing-permissions/visibility-groups"},{"title":"User Roles","href":"/managing-permissions/user-roles"}]},{"group":"Security","pages":[{"title":"Security FAQs","href":"/security/security-faqs"},{"title":"Rate Limits","href":"/security/rate-limits"},{"title":"Caching Layer","href":"/security/caching-layer"}]}]},{"anchor":"API Reference","icon":"rectangle-terminal","pages":[{"title":"API Reference","href":"/api-reference/explos-authentication"}]},{"anchor":"Security Trust Center","href":"https://security.explo.co/?itemUid=7bfa66da-33ab-49de-8391-e329738a1ae9\u0026source=click","icon":"shield-halved"},{"anchor":"Changelog","href":"https://www.explo.co/changelog","icon":"list"}]},"basePath":"","title":"Explo | Customer-facing analytics for any platform","deploymentId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","buildId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","dynamics":["a74be98ba7"],"chunks":["zoom-image-lightbox-BQ4tbj_9.js","lightbox-handle-r17bVUz3.js"]}