(window.webpackJsonp=window.webpackJsonp||[]).push([[42],{ntgN:function(e,t,a){"use strict";a.r(t),a.d(t,"_frontmatter",(function(){return b})),a.d(t,"default",(function(){return l}));var n=a("k1TG"),r=a("8o2o"),o=(a("q1tI"),a("7ljp")),s=a("hhGP"),b=(a("qKvR"),{});void 0!==b&&b&&b===Object(b)&&Object.isExtensible(b)&&!b.hasOwnProperty("__filemeta")&&Object.defineProperty(b,"__filemeta",{configurable:!0,value:{name:"_frontmatter",filename:"src/pages/docs/Connecting to Databases/redshift.mdx"}});var c={_frontmatter:b},i=s.a;function l(e){var t=e.components,a=Object(r.a)(e,["components"]);return Object(o.b)(i,Object(n.a)({},c,a,{components:t,mdxType:"MDXLayout"}),Object(o.b)("h2",{id:"aws-redshift"},"AWS Redshift"),Object(o.b)("p",null,"The ",Object(o.b)("a",Object(n.a)({parentName:"p"},{href:"https://pypi.org/project/sqlalchemy-redshift/"}),"sqlalchemy-redshift")," library is the recommended\nway to connect to Redshift through SQLAlchemy."),Object(o.b)("p",null,"You'll need to the following setting values to form the connection string:"),Object(o.b)("ul",null,Object(o.b)("li",{parentName:"ul"},Object(o.b)("strong",{parentName:"li"},"User Name"),": userName"),Object(o.b)("li",{parentName:"ul"},Object(o.b)("strong",{parentName:"li"},"Password"),": DBPassword"),Object(o.b)("li",{parentName:"ul"},Object(o.b)("strong",{parentName:"li"},"Database Host"),": AWS Endpoint"),Object(o.b)("li",{parentName:"ul"},Object(o.b)("strong",{parentName:"li"},"Database Name"),": Database Name"),Object(o.b)("li",{parentName:"ul"},Object(o.b)("strong",{parentName:"li"},"Port"),": default 5439")),Object(o.b)("p",null,"Here's what the connection string looks like:"),Object(o.b)("pre",null,Object(o.b)("code",Object(n.a)({parentName:"pre"},{}),"redshift+psycopg2://<userName>:<DBPassword>@<AWS End Point>:5439/<Database Name>\n")))}void 0!==l&&l&&l===Object(l)&&Object.isExtensible(l)&&!l.hasOwnProperty("__filemeta")&&Object.defineProperty(l,"__filemeta",{configurable:!0,value:{name:"MDXContent",filename:"src/pages/docs/Connecting to Databases/redshift.mdx"}}),l.isMDXComponent=!0}}]);
//# sourceMappingURL=component---src-pages-docs-connecting-to-databases-redshift-mdx-a3c5a7af2a61abf73cff.js.map