Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.
Learn how to configure your data warehouse for use with Paradime and dbt™, including advanced patterns for multi-project and cross-account setups.
BigQuery multi-project service account
Configure a Google Cloud service account to query and transform data across multiple BigQuery projects.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Paradime","colors":{"primary":"#726AE3","light":"#9291F4","dark":"#5943D6"},"logo":{"light":"https://mintcdn.com/paradime-docs/C-R77mCdstNPsNTv/logo/paradime-logo-light-mode.svg?fit=max\u0026auto=format\u0026n=C-R77mCdstNPsNTv\u0026q=85\u0026s=7a32141c8f01f795c35f0c3c48b2f26a","dark":"https://mintcdn.com/paradime-docs/C-R77mCdstNPsNTv/logo/paradime-logo-dark-mode.svg?fit=max\u0026auto=format\u0026n=C-R77mCdstNPsNTv\u0026q=85\u0026s=e8b1dae8a943bf2a7c4d0088d7cc107b"},"favicon":"https://mintcdn.com/paradime-docs/F1X35JoCsYMKtOFi/favicon.svg?fit=max\u0026auto=format\u0026n=F1X35JoCsYMKtOFi\u0026q=85\u0026s=4ba032ce7ca6b66ccd44805e1e22567a","appearance":{"default":"system"},"background":{"decoration":"gradient"},"navbar":{"links":[{"href":"mailto:support@paradime.io","label":"Support"}],"primary":{"type":"button","label":"Launch Paradime","href":"https://app.paradime.io"}},"footer":{"socials":{"x":"https://x.com/paradimelabs","github":"https://github.com/paradime-io","linkedin":"https://www.linkedin.com/company/paradimelabs"},"links":[{"header":"Resources","items":[{"label":"Paradime Blog","href":"https://www.paradime.io/blog"},{"label":"SQL Resources Hub","href":"https://www.paradime.io/sql"},{"label":"Community","href":"https://paradimers.slack.com/join/shared_invite/zt-1mzax4sb8-jgw~hXRlDHAx~KN0az18bw"}]}]},"fonts":{"family":"Geist"},"icons":{"library":"lucide"},"styling":{"eyebrows":"breadcrumbs","codeblocks":"system","latex":true},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"thumbnails":{"appearance":"light"},"markdown":{"schema":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"paradime-docs","hasAudioNarration":false,"actualSubdomain":"paradime-docs","customDomains":["docs.paradime.io"],"gitSource":{"type":"github","owner":"paradime-io","repo":"paradime-docs-mintlify","deployBranch":"main","contentDirectory":"paradime-docs","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6ae9aad85ef2c10d596e22d0","collectionId":"0ae7ba9e-9bdb-49b2-acf1-c49a95f71a3e","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ae9aad85ef2c10d596e22d0"},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6aedf586aaaef32f9954dbde","clientVersion":"0.0.4074","searchFilterCounts":[{"language":"default","tag":"Products","count":286},{"language":"default","tag":"Guides","count":182},{"language":"default","tag":"Integrations","count":163},{"language":"default","tag":"Changelog","count":101},{"language":"default","tag":"DinoAI","count":88},{"language":"default","tag":"Bolt","count":83},{"language":"default","tag":"Developers","count":57},{"language":"default","tag":"Orchestrate data pipelines","count":45},{"language":"default","tag":"Schedule Anatomy","count":45},{"language":"default","tag":"Administration","count":44}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"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":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"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":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"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":"comment-mode","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[{"filePath":"custom.css","content":"#navigation-items>ul.sidebar-group~ul.sidebar-group{margin-top:0}#navigation-items a .rounded-md[style*=\"background\"] svg{background:white!important}div[class*=\"w-[160px]\"] .flex.flex-wrap>span.inline-block.rounded-lg.font-medium{padding:2px 8px;background-color:rgba(114, 106, 227, 0.12);color:#5943D6}#content-area h1,#content-area h2,#content-area h3,#content-area h4{letter-spacing:-0.03em}#content-area #page-title{font-size:2.25rem;line-height:1.1}.nav-logo{height:22px}#background-color::after{content:\"\";position:absolute;inset:0;pointer-events:none;background-image:linear-gradient(to right, rgba(114, 106, 227, 0.13) 1px, transparent 1px),\n linear-gradient(to bottom, rgba(114, 106, 227, 0.13) 1px, transparent 1px);background-size:44px 44px;-webkit-mask-image:radial-gradient(700px circle at 100% 0%, black 12%, transparent 68%),\n radial-gradient(700px circle at 0% 0%, black 12%, transparent 68%);-webkit-mask-composite:source-over;mask-image:radial-gradient(700px circle at 100% 0%, black 12%, transparent 68%),\n radial-gradient(700px circle at 0% 0%, black 12%, transparent 68%);mask-composite:add}#sidebar .sidebar-group-header{color:rgb(113, 113, 122)}#sidebar div:has(>.sidebar-group-header)~div:has(>.sidebar-group-header){border-top:1px solid rgba(128, 128, 140, 0.18);padding-top:1.25rem}img[src*=\"dino-ai\"]{background:transparent!important;filter:brightness(0) invert(0.64)}a[aria-current=\"location\"] img[src*=\"dino-ai\"],a.group:hover img[src*=\"dino-ai\"]{filter:brightness(0) invert(1)}img.sidebar-group-icon[src*=\"slack\"]{filter:brightness(0) invert(0.44)}"}],"page":{"pagePath":"guides/data-warehouse-essentials","slug":"/guides/data-warehouse-essentials","pageMetadata":{"title":"Data Warehouse essentials","description":"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.","href":"/guides/data-warehouse-essentials/index"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.\"\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},{Card,CardGroup}=_components;if(!Card)_missingMdxReference(`Card`,true);if(!CardGroup)_missingMdxReference(`CardGroup`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Learn how to configure your data warehouse for use with Paradime and dbt™, including advanced patterns for multi-project and cross-account setups.`}),`\n`,_jsx(CardGroup,{cols:2,children:_jsx(Card,{title:`BigQuery multi-project service account`,href:`/guides/data-warehouse-essentials/bigquery-multi-project-service-account`,icon:`google`,children:_jsx(_components.p,{children:`Configure a Google Cloud service account to query and transform data across multiple BigQuery projects.`})})})]})}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":{"codeStyling":"system","config":{},"pageMetadata":{"title":"Data Warehouse essentials","description":"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.","href":"/guides/data-warehouse-essentials/index"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":["/_mintlify/custom/paradime-docs/d89c3c6c95bfc95f/snitcher.js"],"subdomain":"paradime-docs","siteName":"Paradime","title":"Data Warehouse essentials - Paradime","relatedPagesConfig":{"enabled":true,"limit":5,"mode":"automatic"},"navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-07-27T17:56:25.608Z","originalFileLocation":"guides/data-warehouse-essentials/index.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=\"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Paradime\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/paradime-docs/M6Wm7PyWfTcwC_Oc/_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/paradime-docs/M6Wm7PyWfTcwC_Oc/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/paradime-docs/M6Wm7PyWfTcwC_Oc/_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/paradime-docs/M6Wm7PyWfTcwC_Oc/_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/paradime-docs/M6Wm7PyWfTcwC_Oc/_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/paradime-docs/M6Wm7PyWfTcwC_Oc/_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/paradime-docs/M6Wm7PyWfTcwC_Oc/_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/paradime-docs/M6Wm7PyWfTcwC_Oc/_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/paradime-docs/M6Wm7PyWfTcwC_Oc/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Data Warehouse essentials - Paradime\">\u003cmeta data-mint-head property=\"og:description\" content=\"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Paradime\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.paradime.io/guides/data-warehouse-essentials\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://paradime-docs.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Data+Warehouse+essentials\u0026amp;description=Guides+for+configuring+and+connecting+your+data+warehouse+to+Paradime%2C+covering+advanced+setup+patterns+across+supported+platforms.\u0026amp;theme=5da792a529ae15a65836c568\u0026amp;signature=9d5ede8fcaaf7be36276564f0208bcf5f302896a4bae8674a6ac976f51639686\">\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=\"Data Warehouse essentials - Paradime\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://paradime-docs.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Data+Warehouse+essentials\u0026amp;description=Guides+for+configuring+and+connecting+your+data+warehouse+to+Paradime%2C+covering+advanced+setup+patterns+across+supported+platforms.\u0026amp;theme=5da792a529ae15a65836c568\u0026amp;signature=9d5ede8fcaaf7be36276564f0208bcf5f302896a4bae8674a6ac976f51639686\">\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/paradime-docs/M6Wm7PyWfTcwC_Oc/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Paradime\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#726AE3\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.paradime.io/guides/data-warehouse-essentials\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/guides/data-warehouse-essentials.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.paradime.io/#organization\",\"name\":\"Paradime\",\"url\":\"https://docs.paradime.io\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/paradime-docs/C-R77mCdstNPsNTv/logo/paradime-logo-light-mode.svg?fit=max\u0026auto=format\u0026n=C-R77mCdstNPsNTv\u0026q=85\u0026s=7a32141c8f01f795c35f0c3c48b2f26a\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.paradime.io#website\",\"name\":\"Paradime\",\"url\":\"https://docs.paradime.io\",\"publisher\":{\"@id\":\"https://docs.paradime.io/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.paradime.io/guides/data-warehouse-essentials#webpage\",\"url\":\"https://docs.paradime.io/guides/data-warehouse-essentials\",\"name\":\"Data Warehouse essentials\",\"description\":\"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.\",\"dateModified\":\"2026-07-27T17:56:25.608Z\",\"isPartOf\":{\"@id\":\"https://docs.paradime.io#website\"},\"breadcrumb\":{\"@id\":\"https://docs.paradime.io/guides/data-warehouse-essentials#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.paradime.io/guides/data-warehouse-essentials#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Set up \u0026 configure\",\"item\":\"https://docs.paradime.io/guides/set-up-and-configure/index\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connections\",\"item\":\"https://docs.paradime.io/guides/data-warehouse-essentials/index\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Warehouse essentials\",\"item\":\"https://docs.paradime.io/guides/data-warehouse-essentials\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.paradime.io/guides/data-warehouse-essentials#article\",\"headline\":\"Data Warehouse essentials\",\"name\":\"Data Warehouse essentials\",\"description\":\"Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.\",\"url\":\"https://docs.paradime.io/guides/data-warehouse-essentials\",\"mainEntityOfPage\":{\"@id\":\"https://docs.paradime.io/guides/data-warehouse-essentials#webpage\"},\"dateModified\":\"2026-07-27T17:56:25.608Z\",\"publisher\":{\"@id\":\"https://docs.paradime.io/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.paradime.io#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Paradime\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Paradime","nav":{"global":null,"tabs":[{"tab":"Start here","pages":[{"title":"Start here","href":""}]},{"tab":"Guides","pages":[{"group":"Foundations","icon":"lightbulb","pages":[{"title":"Foundations","sidebarTitle":"Overview","href":"/guides/foundations"},{"title":"How Paradime works","href":"/guides/foundations/how-paradime-works"},{"title":"What is dbt™?","href":"/guides/foundations/what-is-dbt"},{"title":"Environments and connections","href":"/guides/foundations/environments-and-connections"},{"title":"What is DinoAI?","href":"/guides/foundations/what-is-dinoai"},{"title":"What is Bolt?","href":"/guides/foundations/what-is-bolt"},{"title":"Monitoring and discovery","href":"/guides/foundations/monitoring-and-discovery"},{"title":"Key terms","href":"/guides/foundations/key-terms"}]},{"group":"Automate with AI agents","icon":"bot","pages":[{"title":"Automate with AI agents","sidebarTitle":"Overview","href":"/guides/programmable-agents/index"},{"group":"Build \u0026 run agents","pages":[{"title":"Build an agent in the UI","href":"/guides/programmable-agents/build-in-the-agent-ui"},{"title":"Run an agent with Bolt","href":"/guides/programmable-agents/run-an-agent-with-bolt"},{"title":"Run an agent from a webhook","href":"/guides/programmable-agents/run-an-agent-from-a-webhook"},{"title":"Build a custom bot on the agent API","sidebarTitle":"Build a custom bot","href":"/guides/programmable-agents/build-a-custom-bot"}]},{"group":"Pipeline reliability \u0026 on-call","pages":[{"title":"Bolt pipeline healer","href":"/guides/programmable-agents/bolt-pipeline-healer"},{"title":"Bolt CI healer","href":"/guides/programmable-agents/bolt-ci-healer"},{"title":"MongoDB schema drift healer","href":"/guides/programmable-agents/mongo-schema-drift-healer"},{"title":"Pipeline incident commander (Airflow)","href":"/guides/programmable-agents/incident-commander"},{"title":"Self-heal Dagster pipelines","href":"/guides/programmable-agents/self-healing-pipelines-dagster"},{"title":"Snowflake Task migrator","href":"/guides/programmable-agents/snowflake-task-migrator"}]},{"group":"Code quality","pages":[{"title":"Set up DinoAI Code Review","href":"/guides/programmable-agents/set-up-dinoai-code-review"},{"title":"End-to-end PR reviewer","href":"/guides/programmable-agents/end-to-end-pr-reviewer"},{"title":"End-to-end PR reviewer (Jira)","href":"/guides/programmable-agents/end-to-end-pr-reviewer-jira"},{"title":"dbt™ impact assessor","href":"/guides/programmable-agents/impact-assessor"},{"title":"dbt™ test maintainer","href":"/guides/programmable-agents/test-maintainer"},{"title":"dbt™ documentation backfiller","href":"/guides/programmable-agents/doc-backfiller"},{"title":"PR reviewer with the DinoAI GitHub Action","sidebarTitle":"PR reviewer with the GitHub Action (alternative)","href":"/guides/programmable-agents/github-action-pr-reviewer"}]},{"group":"Slack bots","pages":[{"title":"Jira intake agent","href":"/guides/programmable-agents/jira-intake-agent"},{"title":"Linear intake agent","href":"/guides/programmable-agents/linear-intake-agent"}]},{"group":"Backlog \u0026 tickets","pages":[{"title":"GitHub Issues backlog agent","href":"/guides/programmable-agents/github-issues-backlog-agent"},{"title":"Linear backlog agent","href":"/guides/programmable-agents/linear-backlog-agent"},{"title":"Jira backlog agent","href":"/guides/programmable-agents/jira-backlog-agent"},{"title":"Jira change request agent","href":"/guides/programmable-agents/jira-change-request-agent"},{"title":"MongoDB schema drift triager","href":"/guides/programmable-agents/mongodb-schema-drift-triager"}]},{"group":"Cost optimization","pages":[{"title":"Query cost optimizer (Snowflake)","href":"/guides/programmable-agents/dbt-tm-model-query-cost-optimizer-snowflake"},{"title":"Query cost optimizer (BigQuery)","href":"/guides/programmable-agents/dbt-tm-model-query-cost-optimizer-bigquery"}]},{"group":"Analytics \u0026 reporting","pages":[{"title":"Weekly Metrics Pulse Reporter","href":"/guides/programmable-agents/weekly-metrics-pulse-agent"},{"title":"Renewal Prep Agent","href":"/guides/programmable-agents/renewal-prep-agent"}]}]},{"group":"Set up \u0026 configure","icon":"settings","pages":[{"title":"Set up \u0026 configure","sidebarTitle":"Overview","href":"/guides/set-up-and-configure/index"},{"group":"Workspace setup","root":{"title":"Getting Started with your Paradime Workspace","href":"/guides/paradime-101/getting-started-with-your-paradime-workspace/index"},"pages":[{"title":"Create a workspace","href":"/guides/paradime-101/getting-started-with-your-paradime-workspace/creating-a-workspace"},{"title":"Create and manage environments","href":"/guides/paradime-101/getting-started-with-your-paradime-workspace/setting-up-data-warehouse-connections"},{"title":"Manage workspace configurations","href":"/guides/paradime-101/getting-started-with-your-paradime-workspace/managing-workspace-configurations"},{"title":"Manage users","href":"/guides/paradime-101/getting-started-with-your-paradime-workspace/managing-users-in-the-workspace"},{"title":"Upgrade dbt Core™ version","description":"Change the dbt Core™ version for your Paradime workspace so the Code IDE and Bolt run a consistent, up-to-date version for everyone.","href":"/guides/upgrade-dbt-core-version"}]},{"group":"Connections","root":{"title":"Data Warehouse essentials","href":"/guides/data-warehouse-essentials/index"},"pages":[{"title":"Manage connections","sidebarTitle":"Overview","description":"Manage Connections in Paradime: Oversee and configure data warehouse connections for dbt™ projects. Ensure seamless data integration.","href":"/guides/data-warehouse-essentials/manage-connections/index"},{"title":"Configure a connection","description":"Add a data warehouse connection to a Paradime environment: choose your provider, enter credentials, set the target and schema, and test it.","href":"/guides/data-warehouse-essentials/manage-connections/configure-a-connection"},{"title":"Copy a connection to another environment","sidebarTitle":"Copy a connection","description":"Copy a data warehouse connection, secrets included, into another Bolt or Agent environment or the Code IDE, then review and test it before it saves.","href":"/guides/data-warehouse-essentials/manage-connections/copy-a-connection"},{"title":"Set an alternative default connection","description":"Change which warehouse connection is the default for an environment in Paradime, so dbt™ commands run against the database you want.","href":"/guides/data-warehouse-essentials/manage-connections/set-alternative-default-connection"},{"title":"Delete a connection","description":"Permanently remove an unused data warehouse connection from Paradime to keep your environments clean, with the safeguards you need to know first.","href":"/guides/data-warehouse-essentials/manage-connections/delete-connections"},{"title":"Optional connection attributes","description":"Add a custom profiles.yml snippet to a Paradime connection to set any attribute your dbt™ adapter supports, like timeouts, priority, or retries.","href":"/guides/data-warehouse-essentials/optional-connection-attributes"},{"title":"Set up a BigQuery multi-project service account","description":"Configure a Google Cloud service account to read and write across multiple BigQuery projects, then point your dbt™ project at the right source and target.","href":"/guides/data-warehouse-essentials/bigquery-multi-project-service-account"},{"title":"Snowflake DinoAI Agent Key-Pair Setup","description":"Set up Snowflake key-pair authentication for the DinoAI Background Agent: generate RSA keys, create a service user, grant access, and wire it into Paradime.","href":"/guides/paradime-101/getting-started-with-the-dinoai-background-agent/snowflake-dinoai-agent-key-pair-setup"}]},{"group":"Data mesh \u0026 multi-project","pages":[{"title":"Data Mesh Setup","href":"/guides/data-mesh-setup/index"},{"title":"Configure cross-project dependencies","href":"/guides/data-mesh-setup/configure-project-dependencies"},{"title":"Cross-project references on dbt™ 2.0","href":"/guides/data-mesh-setup/cross-project-refs-on-dbt-v2"},{"title":"Model access","href":"/guides/data-mesh-setup/model-access"},{"title":"Model groups","href":"/guides/data-mesh-setup/model-groups"},{"title":"Workspaces and data mesh","href":"/guides/paradime-fundamentals/workspaces-and-data-mesh"},{"title":"PII Anonymization with dbt™ Mesh Setup","href":"/guides/pii-anonymization-with-dbt-tm-mesh-setup"}]}]},{"group":"Orchestrate data pipelines","icon":"workflow","pages":[{"title":"Orchestrate data pipelines","sidebarTitle":"Overview","href":"/guides/ship-to-production/index"},{"group":"Create \u0026 schedule jobs","pages":[{"title":"Create a schedule","href":"/guides/paradime-101/running-dbt-in-production-with-bolt/creating-bolt-schedules"},{"title":"Schedule types and triggers","href":"/guides/paradime-101/running-dbt-in-production-with-bolt/understanding-schedule-types-and-triggers"},{"title":"Orchestrate your whole stack","href":"/guides/orchestrate-data-pipelines/orchestrate-your-whole-stack"},{"title":"Manage schedules as code","href":"/guides/orchestrate-data-pipelines/manage-schedules-as-code"},{"title":"Run SQL statements in Bolt schedules","sidebarTitle":"Run SQL statements in Bolt","href":"/guides/running-sql-statements-in-bolt"}]},{"group":"Data ingestion with dlt","root":{"title":"Using dlt in Paradime","href":"/guides/using-dlt-in-paradime/index"},"pages":[{"title":"dlt credentials via environment variables","href":"/guides/using-dlt-in-paradime/dlt-source-and-destination-credentials-via-environment-variables"},{"title":"Reuse dbt™ BigQuery credentials in dlt pipelines","href":"/guides/using-dlt-in-paradime/reuse-dbt-tm-connection-credentials-in-dlt-pipelines-bigquery"},{"title":"Ingest Google Sheets into Snowflake with dltHub","href":"/guides/using-dlt-in-paradime/python-data-pipeline-using-dlthub-google-sheets-to-snowflake"}]},{"group":"Set up CI/CD","pages":[{"title":"Set up Turbo CI","href":"/guides/orchestrate-data-pipelines/set-up-turbo-ci"},{"title":"Run several Turbo CI checks on a pull request","sidebarTitle":"Run several Turbo CI checks","href":"/guides/orchestrate-data-pipelines/run-several-turbo-ci-checks"},{"title":"Chain Turbo CI checks to run in order","sidebarTitle":"Chain Turbo CI checks","href":"/guides/orchestrate-data-pipelines/chain-turbo-ci-checks"},{"title":"Set up continuous deployment","href":"/guides/orchestrate-data-pipelines/set-up-continuous-deployment"},{"title":"Run several jobs when a pull request merges","sidebarTitle":"Run several jobs on merge","href":"/guides/orchestrate-data-pipelines/run-several-jobs-on-merge"},{"title":"Make merges take turns with a merge queue","sidebarTitle":"Set up a merge queue","href":"/guides/orchestrate-data-pipelines/set-up-a-merge-queue"},{"title":"Compare column-level lineage on pull requests","href":"/guides/orchestrate-data-pipelines/compare-column-level-lineage"},{"title":"Migrate Turbo CI from --target flags to a CI environment","sidebarTitle":"Turbo CI to a CI environment","href":"/guides/migrations/migrate-turbo-ci-to-a-dedicated-environment"}]},{"group":"Monitor \u0026 operate","pages":[{"title":"View run history and analytics","href":"/guides/paradime-101/running-dbt-in-production-with-bolt/viewing-run-history-and-analytics"},{"title":"Set up notifications","href":"/guides/paradime-101/running-dbt-in-production-with-bolt/setting-up-notifications"},{"title":"Debug a failed run","href":"/guides/paradime-101/running-dbt-in-production-with-bolt/debugging-failed-runs"},{"title":"Set up alerts","href":"/guides/orchestrate-data-pipelines/set-up-alerts"},{"title":"Set up self-healing","href":"/guides/orchestrate-data-pipelines/set-up-self-healing"},{"title":"Send failures to your incident tools","href":"/guides/orchestrate-data-pipelines/send-failures-to-incident-tools"}]},{"group":"Templates","root":{"title":"Job templates","href":"/guides/orchestrate-data-pipelines/templates/index"},"pages":[{"group":"dbt™ jobs","root":{"title":"dbt™ Templates","href":"/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/index"},"pages":[{"title":"Run and Test all your dbt™ Models","href":"/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/run-and-test-all-your-dbt-tm-models"},{"title":"Snapshot Source Data Freshness","href":"/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/snapshot-source-data-freshness"},{"title":"Build and Test Models with New Source Data","href":"/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/deferred-model-execution"}]},{"group":"CI/CD","root":{"title":"CI/CD Templates","href":"/guides/orchestrate-data-pipelines/templates/ci-cd-templates/index"},"pages":[{"title":"Test Code Changes On Pull Requests","href":"/guides/orchestrate-data-pipelines/templates/ci-cd-templates/test-code-changes-on-pull-requests"},{"title":"Lint and Test Code Changes On Pull Requests","href":"/guides/orchestrate-data-pipelines/templates/ci-cd-templates/lint-and-test-code-changes-on-pull-requests"},{"title":"Deploy Code Changes On Merge","href":"/guides/orchestrate-data-pipelines/templates/ci-cd-templates/deploy-code-changes-on-merge"}]},{"group":"Observability","root":{"title":"Observability Templates","href":"/guides/orchestrate-data-pipelines/templates/observability-templates/index"},"pages":[{"title":"Send Elementary alerts to Slack","href":"/guides/orchestrate-data-pipelines/templates/observability-templates/send-elementary-alerts-to-slack"},{"title":"Send Elementary alerts to MS Teams","href":"/guides/orchestrate-data-pipelines/templates/observability-templates/send-elementary-alerts-to-ms-teams"}]},{"group":"Ticketing","root":{"title":"Ticketing Templates","href":"/guides/orchestrate-data-pipelines/templates/ticketing-templates/index"},"pages":[{"title":"Create Jira Tickets","href":"/guides/orchestrate-data-pipelines/templates/ticketing-templates/create-jira-tickets"},{"title":"Create Linear Issues","href":"/guides/orchestrate-data-pipelines/templates/ticketing-templates/create-linear-issues"},{"title":"Create Azure DevOps Items","href":"/guides/orchestrate-data-pipelines/templates/ticketing-templates/create-azure-devops-items"}]},{"group":"Reverse ETL","root":{"title":"Reverse ETL Templates","href":"/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/index"},"pages":[{"title":"Trigger Census Syncs","href":"/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/trigger-census-syncs"},{"title":"Trigger Hightouch Syncs","href":"/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/trigger-hightouch-syncs"},{"title":"Trigger Hightouch Sequence Sync","href":"/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/trigger-hightouch-sequence-sync"}]},{"group":"Dashboards","root":{"title":"Dashboard Templates","href":"/guides/orchestrate-data-pipelines/templates/dashboard-templates/index"},"pages":[{"title":"Trigger Hex Projects","href":"/guides/orchestrate-data-pipelines/templates/dashboard-templates/trigger-hex-projects"}]},{"group":"Incidents","root":{"title":"Incident Templates","href":"/guides/orchestrate-data-pipelines/templates/incident-templates/index"},"pages":[{"title":"Create Datadog Incident","href":"/guides/orchestrate-data-pipelines/templates/incident-templates/create-datadog-incident"},{"title":"Create PagerDuty Incident","href":"/guides/orchestrate-data-pipelines/templates/incident-templates/create-pagerduty-incident"},{"title":"Create Incident in incident.io","href":"/guides/orchestrate-data-pipelines/templates/incident-templates/create-incident-in-incident.io"},{"title":"Create New Relic Incidents","href":"/guides/orchestrate-data-pipelines/templates/incident-templates/create-new-relic-incidents"},{"title":"Create Rootly Incident","href":"/guides/orchestrate-data-pipelines/templates/incident-templates/create-rootly-incident"}]}]},{"group":"Trigger Bolt externally","pages":[{"title":"Trigger Bolt externally","href":"/guides/orchestrate-data-pipelines/trigger-bolt-externally"},{"title":"Use a webhook payload in a Bolt run","href":"/guides/orchestrate-data-pipelines/use-a-webhook-payload-in-a-run"}]}]},{"group":"Optimize builds with Paradime State","icon":"zap","pages":[{"title":"Paradime State","sidebarTitle":"Overview","href":"/guides/paradime-state/index"},{"title":"Turn on Paradime State","href":"/guides/paradime-state/turn-on-paradime-state"},{"title":"Paradime State configuration reference","sidebarTitle":"Configuration reference","href":"/guides/paradime-state/configuration-reference"},{"title":"Read a Paradime State run","sidebarTitle":"Read a run","href":"/guides/paradime-state/read-a-run"},{"title":"Troubleshoot Paradime State","sidebarTitle":"Troubleshooting","href":"/guides/paradime-state/troubleshooting"}]},{"group":"Migrate to Paradime","icon":"arrow-left-right","pages":[{"title":"Migrations","sidebarTitle":"Overview","href":"/guides/migrations/index"},{"group":"dbt™ cloud to Paradime","root":{"title":"dbt™ cloud to Paradime","href":"/guides/migrations/dbt-cloud-tm-importer/index"},"pages":[{"title":"Migrate from dbt Cloud™ step by step","href":"/guides/migrations/dbt-cloud-tm-importer/migrate-step-by-step"},{"title":"Transferring dbt™ Jobs","href":"/guides/migrations/dbt-cloud-tm-importer/transferring-dbt-tm-jobs"},{"title":"Translating Key Terms","href":"/guides/migrations/dbt-cloud-tm-importer/translation-of-key-terms"},{"title":"Migration Playbook","href":"/guides/migrations/dbt-cloud-tm-importer/migration-from-dbt-cloud-playbook"},{"title":"Migration Checklist","href":"/guides/migrations/dbt-cloud-tm-importer/migration-checklist"}]},{"title":"Migrate dbt™ jobs from GitHub Actions to Paradime Bolt","href":"/guides/migrations/migrating-dbt-tm-jobs-from-github-actions-to-paradime-bolt"},{"group":"dbt™ version upgrades","root":{"title":"dbt™ version upgrades","sidebarTitle":"Overview","href":"/guides/migrations/dbt-version-upgrades/index"},"pages":[{"title":"Upgrade to dbt™ 1.9","href":"/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.9"},{"title":"Upgrade to dbt™ 1.10","href":"/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.10"},{"title":"Upgrade to dbt™ 1.11","href":"/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.11"},{"title":"Upgrade to dbt™ 1.12","href":"/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.12"},{"title":"Prepare for dbt™ v2","href":"/guides/migrations/dbt-version-upgrades/prepare-for-dbt-v2"},{"title":"Upgrade with the DinoAI agent","href":"/guides/migrations/dbt-version-upgrades/upgrade-with-the-dinoai-agent"}]}]},{"group":"Develop in Paradime","icon":"code","pages":[{"title":"Develop in Paradime","sidebarTitle":"Overview","href":"/guides/develop-in-paradime/index"},{"group":"Build in the IDE","pages":[{"title":"Set up a dbt™ project","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/setting-up-a-dbt-project"},{"title":"Create a dbt™ model","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/creating-a-dbt-model"},{"title":"Explore data in the Code IDE","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/data-exploration-in-the-code-ide"},{"title":"Defer to production","href":"/guides/paradime-fundamentals/dbt-tm-defer-to-production"},{"title":"Visualize data lineage","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/utilizing-advanced-developer-features/visualize-data-lineage"},{"title":"Enforce SQL and YAML best practices","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/utilizing-advanced-developer-features/enforce-sql-and-yaml-best-practices"},{"title":"Work with CSV files","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/utilizing-advanced-developer-features/working-with-csv-files"}]},{"group":"Build with DinoAI","root":{"title":"DinoAI copilot use cases","sidebarTitle":"Overview","href":"/guides/dinoai-copilot-use-cases/index"},"pages":[{"title":"Create sources from your warehouse","href":"/guides/dinoai-copilot-use-cases/creating-sources-from-your-warehouse"},{"title":"Generate dbt™ models","href":"/guides/dinoai-copilot-use-cases/generating-dbt-tm-models"},{"title":"Build marts models","href":"/guides/dinoai-copilot-use-cases/building-marts-models"},{"title":"Generate documentation","href":"/guides/dinoai-copilot-use-cases/generating-documentation"},{"title":"Configure data pipelines","href":"/guides/dinoai-copilot-use-cases/configuring-data-pipelines"},{"title":"Fix errors with Jira","href":"/guides/dinoai-copilot-use-cases/fixing-errors-with-jira"},{"title":"Debug failed dbt™ commands with terminal context","href":"/guides/dinoai-copilot-use-cases/debugging-failed-dbt-tm-commands-with-terminal-context"},{"title":"Research with Perplexity","href":"/guides/dinoai-copilot-use-cases/researching-with-perplexity"},{"title":"Provide additional context using PDFs","href":"/guides/dinoai-copilot-use-cases/providing-additional-context-using-pdfs"},{"title":"Generate pull request descriptions","href":"/guides/dinoai-copilot-use-cases/generating-pull-request-descriptions"},{"title":"Set up .dinorules using your project as context","href":"/guides/dinoai-copilot-use-cases/using-your-project-as-context-to-set-up-.dinorules"},{"title":"Accelerating dbt™ Development","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/dinoai-accelerating-your-analytics-engineering-workflow/accelerating-dbt-development"},{"title":"Accelerating GitOps","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/dinoai-accelerating-your-analytics-engineering-workflow/accelerating-git-ops"},{"title":"Accelerating Data Governance","href":"/guides/paradime-101/getting-started-with-the-paradime-ide/dinoai-accelerating-your-analytics-engineering-workflow/accelerating-data-governance"}]},{"group":"Version control with Git","root":{"title":"Working with Git","href":"/guides/working-with-git/index"},"pages":[{"title":"Use Git Lite","href":"/guides/working-with-git/git-lite"},{"title":"Use Git Advanced","href":"/guides/working-with-git/git-advanced"},{"title":"Work with read-only branches","href":"/guides/working-with-git/read-only-branches"},{"title":"Resolve merge conflicts","href":"/guides/working-with-git/merge-conflicts"},{"title":"Delete branches","href":"/guides/working-with-git/delete-branches"},{"title":"Explore Git history with GitLens","href":"/guides/working-with-git/gitlens"},{"title":"Set up a GitHub merge queue with Paradime Turbo CI","href":"/guides/working-with-git/github-merge-queue"},{"title":"Connecting a repository asynchronously","href":"/guides/working-with-git/connecting-a-repository-asynchronously"},{"title":"Configure signed commits with SSH keys","href":"/guides/working-with-git/configuring-signed-commits-on-paradime-with-ssh-keys"},{"title":"Protect the main branch on GitHub","href":"/guides/working-with-git/github-branch-protection-guide-preventing-direct-commits-to-main"}]}]},{"group":"Learn dbt™","icon":"graduation-cap","pages":[{"title":"dbt™ fundamentals","sidebarTitle":"Overview","href":"/guides/dbt-fundamentals/index"},{"group":"Getting started with dbt™","root":{"title":"Getting started with dbt™","href":"/guides/dbt-fundamentals/getting-started-with-dbt/index"},"pages":[{"title":"Introduction","href":"/guides/dbt-fundamentals/getting-started-with-dbt/introduction"},{"title":"Project Strucuture","href":"/guides/dbt-fundamentals/getting-started-with-dbt/project-strucuture"},{"title":"Working with Sources","href":"/guides/dbt-fundamentals/getting-started-with-dbt/working-with-sources"},{"title":"Testing Data Quality","href":"/guides/dbt-fundamentals/getting-started-with-dbt/testing-data-quality"},{"title":"Models and Transformations","href":"/guides/dbt-fundamentals/getting-started-with-dbt/models-and-transformations"}]},{"group":"Configuring your dbt™ Project","root":{"title":"Configuring your dbt™ Project","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/index"},"pages":[{"title":"Setting up your dbt_project.yml","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/setting-up-your-dbt_project.yml"},{"title":"Defining Your Sources in sources.yml","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/define-your-sources.yml"},{"title":"Testing Source Freshness","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/testing-source-freshness"},{"title":"Unit Testing","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/unit-testing"},{"title":"Working with Tags","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/working-with-tags-in-your-dbt-tm-project"},{"title":"Managing Seeds","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/managing-seeds"},{"title":"Environment Management","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/environment-management"},{"title":"Variables and Parameters","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/variables-and-parameters"},{"title":"Macros","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/macros"},{"title":"Custom Tests","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/custom-tests"},{"title":"Hooks \u0026 Operational Tasks","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/hooks-and-operational-tasks"},{"title":"Packages","href":"/guides/dbt-fundamentals/configuring-your-dbt-project/packages"}]},{"group":"Model Materializations","root":{"title":"Model Materializations","href":"/guides/dbt-fundamentals/model-materializations/index"},"pages":[{"title":"Table Materialization","href":"/guides/dbt-fundamentals/model-materializations/table-materialization"},{"title":"View Materialization","href":"/guides/dbt-fundamentals/model-materializations/view-materialization"},{"group":"Incremental Materialization","root":{"title":"Incremental Materialization","href":"/guides/dbt-fundamentals/model-materializations/incremental-materialization/index"},"pages":[{"title":"Using Merge for Incremental Models","href":"/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-merge-for-incremental-models"},{"title":"Using Delete+Insert for Incremental Models","href":"/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-delete+insert-for-incremental-models"},{"title":"Using Append for Incremental Models","href":"/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-append-for-incremental-models"},{"title":"Using Microbatch for Incremental Models","href":"/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-microbatch-for-incremental-models"}]},{"title":"Ephemeral Materialization","href":"/guides/dbt-fundamentals/model-materializations/ephemeral-materialization"},{"title":"Snapshots","href":"/guides/dbt-fundamentals/model-materializations/snapshots"}]},{"group":"Running dbt™","root":{"title":"Running dbt™","href":"/guides/dbt-fundamentals/running-dbt/index"},"pages":[{"group":"Mastering the dbt™ CLI","root":{"title":"Mastering the dbt™ CLI","href":"/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/index"},"pages":[{"title":"Commands","href":"/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/commands"},{"title":"dbt selector methods for precise CLI runs and tests","href":"/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/methods"},{"title":"Selector Methods","href":"/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/selector-methods"},{"title":"Graph Operators","href":"/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/graph-operators"}]}]}]}]},{"tab":"Products","pages":[{"title":"Products","href":"/products/dino-ai"}]},{"tab":"Integrations","pages":[{"title":"Integrations","href":"/integrations"}]},{"tab":"Developers","pages":[{"title":"Developers","href":"/developers"}]},{"tab":"GraphQL Schema (generated - do not remove; powers API Reference pages)","hidden":true,"pages":[{"title":"GraphQL Schema (generated - do not remove; powers API Reference pages)","href":"/graphql-reference/queries/apiKeyIdentity"}]},{"tab":"Help \u0026 Resources","pages":[{"title":"Help \u0026 Resources","href":"/get-help/support"}]},{"tab":"Changelog","pages":[{"title":"Changelog","href":"/changelog/overview"}]}]},"basePath":"","title":"Data Warehouse essentials - Paradime","buildId":"dpl_BLQvU86QFwq3AhPofSTw6q8dGWKm","deploymentId":"dpl_BLQvU86QFwq3AhPofSTw6q8dGWKm","dynamics":[],"chunks":[]}