Connect Summation to an Amazon Redshift data warehouse.
Summation connects to Amazon Redshift using standard host, port, database, username, and password credentials. After the connection is saved, you can browse Redshift schemas and tables and add them as datasets.
A user with access to the schemas and tables you want exposed. The user needs USAGE on the schema and SELECT on the tables or views. See GRANT in the Redshift docs.
Network access from Summation to your Redshift endpoint.
Create a dedicated read-only Redshift user for Summation. This keeps queries auditable and prevents accidental writes from the connector.
Form fields
Field
Required
Stored as
Notes
Host
Yes
Config
Redshift endpoint host, e.g. cluster.example.us-west-2.redshift.amazonaws.com.
Port
Yes
Config
Default 5439.
Database
Yes
Config
Redshift database name.
Username
Yes
Config
Login user.
Password
Yes
Secret
Password for the login user.
SSL Mode
Optional
Config
One of disable, prefer, require, verify-ca, verify-full. Default require. Use verify-ca or verify-full when you want the server certificate checked.
CA Certificate
Optional
Secret
PEM-encoded CA certificate, pasted (not a file path). Required when SSL Mode is verify-ca or verify-full.
Connection Pool Size
Optional
Config
Max concurrent connections from Summation. Default 10.
Setup SQL
Replace analytics with the schema you want Summation to read.
CREATE USER summation PASSWORD '<strong-password>';GRANT USAGE ON SCHEMA analytics TO summation;GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO summation;ALTER DEFAULT PRIVILEGES IN SCHEMA analytics GRANT SELECT ON TABLES TO summation;
Adding datasets
After saving the connection, browse Redshift schemas and select tables or views. Source references use the Postgres-compatible form:
postgres:public.orders
Common problems
Error or symptom
Likely cause
connection refused
Wrong host or port, or your network/firewall doesn’t allow traffic from Summation.
timeout
Redshift is private or behind a VPC path Summation cannot reach.
authentication failed
Wrong username or password.
permission denied
Grant USAGE on the schema and SELECT on the table or view.
Tables don’t appear in the browser
The user can connect to the database but lacks access to the schema or table metadata.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Summation","colors":{"primary":"#000000","light":"#888888","dark":"#000000"},"logo":{"light":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685","dark":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685"},"favicon":{"light":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368","dark":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368"},"appearance":{"default":"light"},"navbar":{"primary":{"type":"button","label":"Get Started","href":"https://app.summation.com/signup"}},"fonts":{"family":"Inter"},"contextual":{"options":["copy","view","claude","chatgpt"],"display":"header"},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"summation-676748f5","hasAudioNarration":false,"actualSubdomain":"summation-676748f5","customDomains":["docs.summation.com"],"gitSource":{"type":"github","owner":"summationai","repo":"code","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af5cda8b51d0e31167b5abb","clientVersion":"0.0.4205","searchFilterCounts":[{"language":"default","tag":"API","count":156},{"language":"default","tag":"Endpoints","count":144},{"language":"default","tag":"Documentation","count":49},{"language":"default","tag":"Tables","count":31},{"language":"default","tag":"Connectors","count":21},{"language":"default","tag":"Key concepts","count":20},{"language":"default","tag":"Data Connectors","count":17},{"language":"default","tag":"Grid","count":13},{"language":"default","tag":"Conversations","count":12},{"language":"default","tag":"Use cases","count":11}]},"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":"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":"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":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"a[href=\"https://app.summation.com/signup\"]{border:0!important;box-shadow:none!important}a[href=\"https://app.summation.com/signup\"]>*{background:#000000!important;color:#ffffff!important;box-shadow:none!important;padding-right:1rem!important;padding-left:1rem!important;gap:0!important}a[href=\"https://app.summation.com/signup\"] span,a[href=\"https://app.summation.com/signup\"] svg{color:#ffffff!important}a[href=\"https://app.summation.com/signup\"] svg{display:none!important}a[href=\"https://app.summation.com/signup\"]:hover>*{background:#27272a!important}html[data-current-path=\"/home\"] .eyebrow{display:none}html[data-current-path^=\"/features/\"] .eyebrow{display:none}html[data-current-path=\"/home\"] #header{max-width:41rem;margin-top:3rem}html[data-current-path=\"/home\"] .mdx-content{margin-top:1.5rem}html[data-current-path=\"/home\"] #content-area{width:100%;max-width:64rem}html[data-current-path=\"/home\"] #header>p{margin-top:0.75rem;color:#52525b;font-size:1.125rem;line-height:1.75rem}.home-get-started{display:inline-flex;min-width:10rem;height:2.75rem;align-items:center;justify-content:center;gap:0.5rem;padding-inline:1rem;border-radius:0.75rem;background:#000000;box-shadow:none!important;color:#ffffff!important;font-size:0.875rem;font-weight:500;line-height:1;text-decoration:none!important;transition:background-color 120ms ease}.home-get-started:hover{background:#27272a;box-shadow:none!important}.home-get-started:focus-visible{outline:2px solid #000000;outline-offset:3px}.home-get-started img{width:1rem;height:1rem}.home-section-divider{width:100%;height:0.5px;margin-block:2.5rem;background:#e7e7e7}.home-section-divider+.card-group{margin-top:0!important}html[data-current-path=\"/home\"] .card-group{width:100%;max-width:64rem;grid-template-columns:repeat(3, minmax(0, 1fr))!important;justify-content:center;gap:1.5rem!important}html[data-current-path=\"/home\"] .card-group>.card{--primary: 228 228 231;display:flex;width:100%;min-height:9.5rem;padding:1.3125rem 1.5rem;align-items:center;box-sizing:border-box;margin-block:0!important;border:var(--border-width-border-half, 0.5px) solid\n var(--border-layout-divider, #e7e7e7)!important;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:var(--color-neutral-white, #ffffff);box-shadow:0 1px 2px 0 rgb(0 0 0 / 5%);transition:background-color 120ms ease,\n box-shadow 120ms ease}html[data-current-path=\"/home\"] .card-group>.card:hover{background:#f4f4f5;border-color:#e4e4e7!important}html[data-current-path=\"/home\"] .card-group>.card>div{height:100%;width:100%;padding:0}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-title\"]{font-size:0.9375rem!important}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-content\"]{color:var(--home-card-description, #52525b)!important;font-size:0.875rem!important;line-height:1.25rem!important}html[data-current-path=\"/home\"] .card-group>.card svg{color:#000000!important}html.dark[data-current-path=\"/home\"] .card-group>.card{--primary-light: 63 63 70;--home-card-description: #888888;border-color:#3f3f46!important;background:#18181b}html.dark[data-current-path=\"/home\"] .card-group>.card svg{color:#f4f4f5!important}html.dark[data-current-path=\"/home\"] .card-group>.card:hover{background:#27272a;border-color:#3f3f46!important}html.dark[data-current-path=\"/home\"] .home-section-divider{background:#27272a}.card{background-color:#fafafa!important;transition:background-color 120ms ease,\n border-color 120ms ease}.card:hover{background-color:#f4f4f5!important}html.dark .card{background-color:#18181b!important}html.dark .card:hover{background-color:#232326!important}#content-area{box-sizing:content-box;width:auto;max-width:700px;margin-inline:auto}#page-title{font-size:2rem!important;line-height:2.5rem!important}#page-context-menu-button{border-radius:8px 0 0 8px!important}#page-context-menu>button[aria-label=\"More actions\"]{border-radius:0 8px 8px 0!important}html[data-current-path=\"/home\"] #page-context-menu{display:none!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:first-child{border-color:transparent!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:nth-child(2)>div:first-child>svg{display:none!important}.mdx-content{font-size:15px;letter-spacing:-0.1px}.mdx-content a.link{border-bottom:0;font-weight:400;text-decoration-line:underline;text-decoration-style:dotted;text-decoration-color:#a1a1aa;text-decoration-thickness:from-font;text-decoration-skip-ink:none;text-underline-position:from-font;transition:text-decoration-color 120ms ease-out}.mdx-content a.link:hover{text-decoration-style:solid;text-decoration-color:currentColor}@media (prefers-reduced-motion: reduce){.mdx-content a.link{transition:none}}.mdx-content>h2{margin-top:3rem!important}#table-of-contents-content{--toc-indicator-height: 1.5rem;--toc-indicator-y: 0px;position:relative;border-left:1px solid #e4e4e7}nav:has(>div>#table-of-contents-content)>h2{display:none}#table-of-contents-content::before{position:absolute;top:0;left:-2px;width:3px;height:var(--toc-indicator-height);border-radius:0;background:#27272a;content:\"\";opacity:0;pointer-events:none;transform:translateY(var(--toc-indicator-y));transition:transform 240ms cubic-bezier(0.4, 0, 0.2, 1),\n height 240ms cubic-bezier(0.4, 0, 0.2, 1),\n opacity 120ms ease-out}#table-of-contents-content[data-has-active=\"true\"]::before{opacity:1}@media (prefers-reduced-motion: reduce){#table-of-contents-content::before{transition:opacity 120ms ease-out}}#table-of-contents-content .toc-item>a{padding-left:calc(\n var(--toc-padding-left) + var(--toc-focus-padding, 0rem) + 1rem\n )!important}#table-of-contents-content .toc-item[data-active=\"true\"]>a{font-weight:400;text-shadow:none!important}#table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#4f4f4f}#table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#000000}.dark #table-of-contents-content{border-left-color:#3f3f46}.dark #table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#9e9e9e}.dark #table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#888888}.dark #table-of-contents-content::before{background:#f4f4f5}#navigation-items .sidebar-group>li+li{margin-top:4px}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{width:calc(100% - 0.5rem)!important;margin-left:0.5rem}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{padding-top:0.25rem!important;padding-bottom:0.25rem!important;line-height:1.25rem!important}#sidebar a[aria-current=\"page\"]{background-color:#f4f4f5!important;border-radius:8px!important;color:#000000!important;font-weight:500!important;text-shadow:none!important}#navigation-items a:not([aria-current=\"page\"]):hover{background-color:#fafafa!important}.dark #navigation-items a:not([aria-current=\"page\"]):hover{background-color:#18181b!important}.dark #sidebar a[aria-current=\"page\"]{background-color:#27272a!important;color:#ffffff!important}#sidebar button[aria-expanded]>div:last-child{margin-left:auto}#navigation-items .sidebar-group a span,#navigation-items .sidebar-group button span{hyphens:none}div:has(>form #search-input){padding:0!important;border:0!important;background:transparent!important;box-shadow:none!important}#theme-preference-menu-trigger{width:2.25rem;height:2.25rem;padding:0!important;border:0.5px solid #e4e4e7;border-radius:0.625rem!important}#theme-preference-menu-trigger [data-theme-preference-icon]{display:none!important}#theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:inline-flex!important}html[data-summation-theme-toggle=\"ready\"] #theme-preference-menu-content{display:none!important}.dark #theme-preference-menu-trigger{border-color:#27272a}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:none!important}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"light\"]{display:inline-flex!important}#header-ask-ai,#assistant-entry{display:none!important}.chat-assistant-floating-input{display:none!important}#pagination{display:grid;grid-template-columns:repeat(2, minmax(0, 1fr));gap:1.5rem;padding:0}#footer{border-top:0!important}html[data-current-path=\"/home\"] #pagination{display:none!important}#pagination>a{display:grid;box-sizing:border-box;min-width:0;height:5rem;align-content:center;padding:1rem 1.5rem;column-gap:0.75rem;row-gap:0.5rem;border:1px solid #e4e4e7;border-radius:0.75rem;background:transparent;font-weight:400;transition:border-color 120ms ease,\n background-color 120ms ease}#pagination>a:hover{border-color:#d4d4d8;background:#fafafa}#pagination>a::before{color:#71717a;font-size:0.8125rem;font-weight:400;line-height:1.25rem}#pagination .pagination-prev{grid-template-columns:auto minmax(0, 1fr)}#pagination .pagination-prev::before{grid-column:2;grid-row:1;content:\"Previous\"}#pagination .pagination-next{grid-template-columns:minmax(0, 1fr) auto;margin-left:0;text-align:right}#pagination .pagination-next::before{grid-column:1;grid-row:1;content:\"Next\"}#pagination [data-component-part=\"pagination-chevron\"]{grid-row:1;width:0.25rem;height:0.5rem;align-self:center;stroke-width:1}#pagination [data-component-part=\"pagination-chevron\"] path{stroke-width:1!important}#pagination [data-component-part=\"pagination-title\"]{grid-column:1 / -1;grid-row:2;color:#27272a;font-size:0.9375rem;font-weight:400;line-height:1.5rem}.dark #pagination>a{border-color:#3f3f46}.dark #pagination>a:hover{border-color:#52525b;background:#18181b}.dark #pagination [data-component-part=\"pagination-title\"]{color:#f4f4f5}header .max-w-8xl{max-width:none!important;margin-inline:0!important}#navbar a[href=\"/\"]:has(.nav-logo){display:flex;align-items:center}#navbar a[href=\"/\"] .nav-logo{height:1.25rem!important}.dark #navbar a[href=\"/\"] .nav-logo{filter:invert(1)}#navbar .max-w-8xl>div>div>.flex.items-center{padding-inline:1.5rem!important}@media (max-width: 639px){#navbar a[href=\"/\"] .nav-logo{height:1.125rem!important}}#navbar>div:first-child{border-bottom-color:#f0f0f0!important}:root{--topbar-tabs-height: 0rem !important}@media (min-width: 1024px){#navbar div.hidden.lg\\:flex.px-12.h-12{position:absolute!important;top:0!important;left:183px!important;height:4rem!important;padding:0!important;width:auto!important}#navbar .nav-tabs{column-gap:2rem}#navbar .nav-tabs-item{gap:0.5rem;white-space:nowrap}#navbar .nav-tabs-item:hover>div.absolute.bottom-0{background-color:currentColor}#navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#27272a!important}.dark #navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#888888!important}#navbar .nav-tabs-item[aria-current=\"location\"]{text-shadow:none!important}}@media (min-width: 1024px){#navbar div:has(>#search-bar-entry){flex:0 1 16rem;min-width:12rem}#navbar div:has(>nav[aria-label=\"Main\"]){flex:0 0 auto;margin-left:0}}#search-bar-entry:focus-visible{outline:2px solid currentColor;outline-offset:2px}.sidebar-group-header--collapsible{cursor:pointer;user-select:none}.sidebar-group-header--collapsible:hover{color:#18181b}.dark .sidebar-group-header--collapsible:hover{color:#f4f4f5}.sidebar-group-header--collapsible:focus-visible{outline:2px solid #a1a1aa;outline-offset:2px;border-radius:4px}.sidebar-group-chevron{margin-left:auto;transform:rotate(90deg);transition:transform 120ms ease}.sidebar-group-header--collapsible[data-sidebar-collapsed=\"true\"] .sidebar-group-chevron{transform:rotate(0deg)}ul.sidebar-group[data-sidebar-collapsed=\"true\"]{display:none}header div:has(>#theme-preference-menu-trigger){margin-left:0.5rem!important}#navbar nav:has(a[href=\"https://app.summation.com/signup\"]){margin-right:0!important}header a[href=\"https://app.summation.com/signup\"]{padding-inline:0.75rem!important}header a[href=\"https://app.summation.com/signup\"]>div{padding-inline:0!important;background:#000000!important}@media (min-width: 1024px){html[data-current-path=\"/home\"] #content-container{position:relative;left:7.5rem}#sidebar{width:280px!important;max-width:280px;transform:translateX(min(-2rem, calc((92rem - 100vw) / 2 - 2rem)));border-right:1px solid #f0f0f0}html:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #sidebar{transform:translateX(min(-2rem, calc((115rem - 100vw) / 2 - 2rem)))}#sidebar>#sidebar-content{top:0!important;left:1.5rem!important}#sidebar-content>[class~=\"pr-8\"]{padding-right:1.5rem!important}#sidebar-content .sticky.top-0.h-8{height:1.5rem}#sidebar-content>[data-component-part=\"scroll-area-scrollbar\"][data-orientation=\"vertical\"]{inset-inline-end:-2.5px!important;margin-inline:0!important}.dark #sidebar{border-right-color:rgba(255, 255, 255, 0.18)}}@media (min-width: 1280px){html[data-current-path=\"/home\"] #header,html[data-current-path=\"/home\"] .mdx-content{transform:translateX(-1.625rem)}html[data-current-path=\"/home\"] .mdx-content{width:calc(100% + 5.25rem)}}@media (min-width: 1024px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:0}}@media (min-width: 1280px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #header,html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{transform:none}html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{width:100%}}@media (min-width: 1600px) and (max-width: 1839px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:calc(50vw - 50rem)}}@media (max-width: 767px){#pagination{grid-template-columns:minmax(0, 1fr)}html[data-current-path=\"/home\"] #header{margin-top:2rem}html[data-current-path=\"/home\"] #header>p{font-size:1rem;line-height:1.5rem}.home-section-divider{margin-block:1.5rem}html[data-current-path=\"/home\"] .card-group{grid-template-columns:minmax(0, 1fr)!important}}figure[data-name=\"frame\"]{padding:1.25rem!important;margin-top:0!important;margin-bottom:1.5rem!important;border-radius:var(--border-radius-rounded-xl, 0.75rem)!important;background:#fafafa!important}.columns figure[data-name=\"frame\"]{margin-bottom:0!important}.columns{margin-top:0!important;margin-bottom:1.5rem!important;row-gap:1.5rem!important}html.dark figure[data-name=\"frame\"]{background:#18181b!important}figure[data-name=\"frame\"]>div[class*=\"bg-grid\"]{display:none}figure[data-name=\"frame\"]>div[class*=\"justify-center\"]{overflow:visible;border-radius:0}figure[data-name=\"frame\"] img{border-radius:0.375rem;box-shadow:0 0 0 0.5px #d4d4d8,\n 0 1px 2px 0 rgb(0 0 0 / 5%)}html.dark figure[data-name=\"frame\"] img{box-shadow:0 0 0 0.5px #3f3f46,\n 0 1px 2px 0 rgb(0 0 0 / 30%)}figure[data-name=\"frame\"]>div[class*=\"pointer-events-none\"]{border-color:transparent}@media (max-width: 767px){figure[data-name=\"frame\"]{padding:0.75rem!important}}html[data-current-path=\"/introduction\"] .card-group,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center){row-gap:0.5rem!important}html[data-current-path=\"/introduction\"] .card-group>.card,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center)>.card{margin-block:0!important}.template-meta{display:grid;grid-template-columns:7.5rem minmax(0, 1fr);gap:0.5rem 1rem;margin:0 0 1.5rem;padding:1.25rem;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:#fafafa}.template-meta-label{margin:0;font-weight:500;color:#71717a}.template-meta-value{margin:0}html.dark .template-meta{background:#18181b}html.dark .template-meta-label{color:#a1a1aa}@media (max-width: 639px){.template-meta{grid-template-columns:minmax(0, 1fr);gap:0.25rem;padding:1rem}.template-meta-value:not(:last-child){margin-bottom:0.5rem}}"}],"page":{"pagePath":"features/connectors/redshift","slug":"/features/connectors/redshift","pageMetadata":{"title":"Redshift","description":"Connect Summation to an Amazon Redshift data warehouse.","href":"/features/connectors/redshift"},"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: \"Connect Summation to an Amazon Redshift data warehouse.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,li:`li`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Table,Tip}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Summation connects to Amazon Redshift using standard host, port, database, username, and password credentials. After the connection is saved, you can browse Redshift schemas and tables and add them as datasets.`}),`\n`,_jsx(Heading,{level:`2`,id:`what-you’ll-need`,children:`What you’ll need`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`A reachable `,_jsx(_components.strong,{children:`Redshift endpoint`}),` and `,_jsx(_components.strong,{children:`port`}),`. Redshift Serverless defaults to port `,_jsx(_components.code,{children:`5439`}),`. See `,_jsx(_components.a,{href:`https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html`,children:`Connecting to Amazon Redshift Serverless`}),`.`]}),`\n`,_jsxs(_components.li,{children:[`A `,_jsx(_components.strong,{children:`database`}),` name.`]}),`\n`,_jsxs(_components.li,{children:[`A `,_jsx(_components.strong,{children:`user`}),` with access to the schemas and tables you want exposed. The user needs `,_jsx(_components.code,{children:`USAGE`}),` on the schema and `,_jsx(_components.code,{children:`SELECT`}),` on the tables or views. See `,_jsx(_components.a,{href:`https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html`,children:`GRANT`}),` in the Redshift docs.`]}),`\n`,_jsx(_components.li,{children:`Network access from Summation to your Redshift endpoint.`}),`\n`]}),`\n`,_jsx(Tip,{children:_jsx(_components.p,{children:`Create a dedicated read-only Redshift user for Summation. This keeps queries auditable and prevents accidental writes from the connector.`})}),`\n`,_jsx(Heading,{level:`2`,id:`form-fields`,children:`Form fields`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Field`}),_jsx(_components.th,{children:`Required`}),_jsx(_components.th,{children:`Stored as`}),_jsx(_components.th,{children:`Notes`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Host`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsxs(_components.td,{children:[`Redshift endpoint host, e.g. `,_jsx(_components.code,{children:`cluster.example.us-west-2.redshift.amazonaws.com`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Port`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsxs(_components.td,{children:[`Default `,_jsx(_components.code,{children:`5439`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Database`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:`Redshift database name.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Username`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:`Login user.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Password`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Secret`}),_jsx(_components.td,{children:`Password for the login user.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`SSL Mode`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Config`}),_jsxs(_components.td,{children:[`One of `,_jsx(_components.code,{children:`disable`}),`, `,_jsx(_components.code,{children:`prefer`}),`, `,_jsx(_components.code,{children:`require`}),`, `,_jsx(_components.code,{children:`verify-ca`}),`, `,_jsx(_components.code,{children:`verify-full`}),`. Default `,_jsx(_components.code,{children:`require`}),`. Use `,_jsx(_components.code,{children:`verify-ca`}),` or `,_jsx(_components.code,{children:`verify-full`}),` when you want the server certificate checked.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`CA Certificate`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Secret`}),_jsxs(_components.td,{children:[`PEM-encoded CA certificate, pasted (not a file path). Required when SSL Mode is `,_jsx(_components.code,{children:`verify-ca`}),` or `,_jsx(_components.code,{children:`verify-full`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Connection Pool Size`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Config`}),_jsxs(_components.td,{children:[`Max concurrent connections from Summation. Default `,_jsx(_components.code,{children:`10`}),`.`]})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`setup-sql`,children:`Setup SQL`}),`\n`,_jsxs(_components.p,{children:[`Replace `,_jsx(_components.code,{children:`analytics`}),` with the schema you want Summation to read.`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`7`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`7`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`CREATE`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` USER`}),_jsx(_components.span,{style:{color:`#8250DF`,\"--shiki-dark\":`#DCDCAA`},children:` summation`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` PASSWORD`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '\u003cstrong-password>'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GRANT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` USAGE `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ON`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SCHEMA`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` analytics `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation;`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GRANT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ON`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` ALL TABLES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`IN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SCHEMA`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` analytics `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation;`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ALTER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` DEFAULT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` PRIVILEGES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`IN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SCHEMA`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` analytics`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` GRANT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ON`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` TABLES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation;`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`adding-datasets`,children:`Adding datasets`}),`\n`,_jsx(_components.p,{children:`After saving the connection, browse Redshift schemas and select tables or views. Source references use the Postgres-compatible form:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`2`,language:`text`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`text`,children:_jsxs(_components.code,{language:`text`,numberOfLines:`2`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`postgres:public.orders`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})})]})})}),`\n`,_jsx(Heading,{level:`2`,id:`common-problems`,children:`Common problems`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Error or symptom`}),_jsx(_components.th,{children:`Likely cause`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`connection refused`})}),_jsx(_components.td,{children:`Wrong host or port, or your network/firewall doesn’t allow traffic from Summation.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`timeout`})}),_jsx(_components.td,{children:`Redshift is private or behind a VPC path Summation cannot reach.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`authentication failed`})}),_jsx(_components.td,{children:`Wrong username or password.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`permission denied`})}),_jsxs(_components.td,{children:[`Grant `,_jsx(_components.code,{children:`USAGE`}),` on the schema and `,_jsx(_components.code,{children:`SELECT`}),` on the table or view.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Tables don’t appear in the browser`}),_jsx(_components.td,{children:`The user can connect to the database but lacks access to the schema or table metadata.`})]})]})]})]})}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":"Redshift","description":"Connect Summation to an Amazon Redshift data warehouse.","href":"/features/connectors/redshift"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"What you’ll need","slug":"what-you’ll-need","depth":2,"children":[]},{"title":"Form fields","slug":"form-fields","depth":2,"children":[]},{"title":"Setup SQL","slug":"setup-sql","depth":2,"children":[]},{"title":"Adding datasets","slug":"adding-datasets","depth":2,"children":[]},{"title":"Common problems","slug":"common-problems","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/summation-676748f5/109fb4ec55c4f518/theme-toggle.js","/_mintlify/custom/summation-676748f5/767147eed46ae967/toc-indicator.js","/_mintlify/custom/summation-676748f5/82e2d1909a80e450/sidebar-collapse.js"],"subdomain":"summation-676748f5","siteName":"Summation","title":"Redshift - Summation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-08-14T18:48:00.337Z","originalFileLocation":"features/connectors/redshift.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=\"light\"}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=\"Connect Summation to an Amazon Redshift data warehouse.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Summation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_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/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_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/summation-676748f5/s-DowS6hFbVgFajy/_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/summation-676748f5/s-DowS6hFbVgFajy/_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/summation-676748f5/s-DowS6hFbVgFajy/_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/summation-676748f5/s-DowS6hFbVgFajy/_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/summation-676748f5/s-DowS6hFbVgFajy/_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/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Redshift - Summation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Connect Summation to an Amazon Redshift data warehouse.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Summation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.summation.com/features/connectors/redshift\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Connectors\u0026amp;title=Redshift\u0026amp;description=Connect+Summation+to+an+Amazon+Redshift+data+warehouse.\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=b73a47ed6208a8bf6f4529fb20d8ff0f131fcc5f9a638d3b67303818fafe8f5e\">\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=\"Redshift - Summation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Connect Summation to an Amazon Redshift data warehouse.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Connectors\u0026amp;title=Redshift\u0026amp;description=Connect+Summation+to+an+Amazon+Redshift+data+warehouse.\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=b73a47ed6208a8bf6f4529fb20d8ff0f131fcc5f9a638d3b67303818fafe8f5e\">\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/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Summation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#000000\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.summation.com/features/connectors/redshift\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/features/connectors/redshift.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.summation.com/#organization\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.summation.com#website\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.summation.com/features/connectors/redshift#webpage\",\"url\":\"https://docs.summation.com/features/connectors/redshift\",\"name\":\"Redshift\",\"description\":\"Connect Summation to an Amazon Redshift data warehouse.\",\"dateModified\":\"2026-08-14T18:48:00.337Z\",\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.summation.com/features/connectors/redshift#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.summation.com/features/connectors/redshift#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Connectors\",\"item\":\"https://docs.summation.com/features/connectors\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Redshift\",\"item\":\"https://docs.summation.com/features/connectors/redshift\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.summation.com/features/connectors/redshift#article\",\"headline\":\"Redshift\",\"name\":\"Redshift\",\"description\":\"Connect Summation to an Amazon Redshift data warehouse.\",\"url\":\"https://docs.summation.com/features/connectors/redshift\",\"mainEntityOfPage\":{\"@id\":\"https://docs.summation.com/features/connectors/redshift#webpage\"},\"dateModified\":\"2026-08-14T18:48:00.337Z\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Summation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Summation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/features/connectors/redshift.md","siteName":"Summation","nav":{"global":null,"tabs":[{"tab":"Documentation","icon":"book-open","groups":[{"group":"Get started","pages":[{"title":"What is Summation?","href":"/introduction"},{"title":"Connect your data","sidebarTitle":"1. Connect your data","href":"/get-started/connect-your-data"},{"title":"Create your first analysis","sidebarTitle":"2. Create your first analysis","href":"/get-started/first-artifact"},{"title":"Refine your business context","sidebarTitle":"3. Refine your business context","href":"/get-started/build-your-context"},{"title":"Automate your first workflow","sidebarTitle":"4. Automate your first workflow","href":"/get-started/first-workflow"}]},{"group":"Key concepts","pages":[{"title":"Addison","href":"/features/addison"},{"title":"Projects","href":"/features/projects"},{"group":"Artifacts","pages":[{"title":"Verified Artifacts","sidebarTitle":"Overview","href":"/features/artifacts"},{"title":"Verification","href":"/features/artifacts/verification"},{"title":"Reports","href":"/features/artifacts/reports"},{"title":"Dashboards","href":"/features/artifacts/dashboards"},{"title":"Decks","href":"/features/artifacts/decks"},{"title":"Playbooks","href":"/features/artifacts/playbooks"},{"title":"Excel","href":"/features/artifacts/excel"},{"title":"HTML","href":"/features/artifacts/html"}]},{"title":"Workflows","href":"/features/workflows"},{"title":"Applications","href":"/features/applications"},{"group":"Tables","pages":[{"title":"Tables","sidebarTitle":"Overview","href":"/features/tables"},{"title":"Data table","href":"/features/tables/data"},{"title":"Source table","href":"/features/tables/source"},{"title":"Calculation table","href":"/features/tables/calculation"},{"title":"Dimension table","href":"/features/tables/dimension"},{"title":"Views","href":"/features/tables/views"}]},{"title":"Knowledge","href":"/features/knowledge"},{"title":"Skills","href":"/features/skills"}]},{"group":"Connectors","pages":[{"title":"Connectors","sidebarTitle":"Overview","href":"/features/connectors"},{"title":"Apps","href":"/features/connectors/apps"},{"title":"Snowflake","href":"/features/connectors/snowflake"},{"title":"BigQuery","href":"/features/connectors/bigquery"},{"title":"Databricks","href":"/features/connectors/databricks"},{"title":"Postgres","description":"Connect Summation to a PostgreSQL database.","href":"/features/connectors/postgres"},{"title":"Redshift","href":"/features/connectors/redshift"},{"title":"MySQL","description":"Connect Summation to a MySQL database.","href":"/features/connectors/mysql"},{"title":"SQL Server","href":"/features/connectors/mssql"},{"title":"ClickHouse","href":"/features/connectors/clickhouse"},{"title":"MongoDB","href":"/features/connectors/mongodb"},{"title":"Oracle","href":"/features/connectors/oracle"},{"title":"MotherDuck","href":"/features/connectors/motherduck"},{"title":"REST API","href":"/features/connectors/http"},{"title":"Datadog","href":"/features/connectors/datadog"},{"title":"S3","href":"/features/connectors/s3"},{"title":"Apache Iceberg","href":"/features/connectors/iceberg"},{"title":"AWS Glue","href":"/features/connectors/glue"},{"title":"GCS","href":"/features/connectors/gcs"},{"title":"Google Sheets","href":"/features/connectors/google-sheets"},{"title":"GitHub","href":"/features/connectors/github"}]},{"group":"Agent integrations","pages":[{"title":"Claude Plugin","href":"/integrations/claude-plugin"},{"title":"Codex Plugin","href":"/integrations/codex-plugin"},{"title":"MCP Server","href":"/integrations/mcp-server"}]}]},{"tab":"Use cases","icon":"lightbulb","pages":[{"title":"Use cases","href":"/use-cases/overview"}]},{"tab":"API","icon":"code","pages":[{"title":"API","href":"/api/overview"}]}]},"basePath":"","title":"Redshift - Summation","deploymentId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","buildId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","dynamics":[],"chunks":[]}