(window.webpackJsonp=window.webpackJsonp||[]).push([[14],{mder:function(e,t,a){"use strict";a.r(t),a.d(t,"_frontmatter",(function(){return r})),a.d(t,"default",(function(){return p}));var n=a("k1TG"),c=a("8o2o"),o=(a("q1tI"),a("7ljp")),s=a("hhGP"),r=(a("qKvR"),{});void 0!==r&&r&&r===Object(r)&&Object.isExtensible(r)&&!r.hasOwnProperty("__filemeta")&&Object.defineProperty(r,"__filemeta",{configurable:!0,value:{name:"_frontmatter",filename:"src/pages/docs/Connecting to Databases/athena.mdx"}});var b={_frontmatter:r},i=s.a;function p(e){var t=e.components,a=Object(c.a)(e,["components"]);return Object(o.b)(i,Object(n.a)({},b,a,{components:t,mdxType:"MDXLayout"}),Object(o.b)("h2",{id:"aws-athena"},"AWS Athena"),Object(o.b)("h3",{id:"pyathenajdbc"},"PyAthenaJDBC"),Object(o.b)("p",null,Object(o.b)("a",Object(n.a)({parentName:"p"},{href:"https://pypi.org/project/PyAthenaJDBC/"}),"PyAthenaJDBC")," is a Python DB 2.0 compliant wrapper for the\n",Object(o.b)("a",Object(n.a)({parentName:"p"},{href:"https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html"}),"Amazon Athena JDBC driver"),"."),Object(o.b)("p",null,"The connection string for Amazon Athena is as follows:"),Object(o.b)("pre",null,Object(o.b)("code",Object(n.a)({parentName:"pre"},{}),"awsathena+jdbc://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&...\n")),Object(o.b)("p",null,"Note that you'll need to escape & encode when forming the connection string like so:"),Object(o.b)("pre",null,Object(o.b)("code",Object(n.a)({parentName:"pre"},{}),"s3://... -> s3%3A//...\n")),Object(o.b)("h3",{id:"pyathena"},"PyAthena"),Object(o.b)("p",null,"You can also use ",Object(o.b)("a",Object(n.a)({parentName:"p"},{href:"https://pypi.org/project/PyAthena/"}),"PyAthena library")," (no Java required) with the\nfollowing connection string:"),Object(o.b)("pre",null,Object(o.b)("code",Object(n.a)({parentName:"pre"},{}),"awsathena+rest://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&...\n")))}void 0!==p&&p&&p===Object(p)&&Object.isExtensible(p)&&!p.hasOwnProperty("__filemeta")&&Object.defineProperty(p,"__filemeta",{configurable:!0,value:{name:"MDXContent",filename:"src/pages/docs/Connecting to Databases/athena.mdx"}}),p.isMDXComponent=!0}}]);
//# sourceMappingURL=component---src-pages-docs-connecting-to-databases-athena-mdx-10e65422b243c9d61afb.js.map