<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>AWS Athena Connector Error - Redash Discourse</title> <meta name="description" content="Can anyone help me with this error when I try to test the Athenas connector in Redash: Parameter validation failed: Unknown parameter in QueryExecutionContext: “Catalog”, must be one of: Database"> <meta name="generator" content="Discourse 3.2.0.beta2-dev - https://github.com/discourse/discourse version 83621ccbe797223b48b624b00ef04f24672e1f03"> <link rel="icon" type="image/png" href="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/1X/01e20869afc0877e3e5aee0f94419b9e9bffa961_2_32x32.ico"> <link rel="apple-touch-icon" type="image/png" href="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/1X/e1838a8a0c506503a22e0c60e2334374b2895c87_2_180x180.png"> <meta name="theme-color" media="all" content="#ffffff"> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, user-scalable=yes, viewport-fit=cover"> <link rel="canonical" href="https://discuss.redash.io/t/aws-athena-connector-error/10955" /> <link rel="search" type="application/opensearchdescription+xml" href="https://discuss.redash.io/opensearch.xml" title="Redash Discourse Search"> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/color_definitions_base__2_8fd59ae1f286f43b3ff17996df07ea951685249d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" class="light-scheme"/> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/desktop_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="desktop" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/checklist_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="checklist" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-adplugin_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-adplugin" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-akismet_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-akismet" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-cakeday_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-cakeday" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-chat-integration_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-chat-integration" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-details_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-details" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-footnote_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-footnote" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-lazy-videos_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-lazy-videos" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-local-dates_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-local-dates" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-narrative-bot_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-narrative-bot" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-presence_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-presence" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-solved_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-solved" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-spoiler-alert_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-spoiler-alert" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/hosted-site_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="hosted-site" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/poll_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="poll" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/poll_desktop_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="poll_desktop" /> <link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/desktop_theme_2_be4cb2b86ec06123c5e974acd20fd933d14b129d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="2" data-theme-name="default"/> <meta id="data-ga-universal-analytics" data-tracking-code="UA-47088186-6" data-json="{"cookieDomain":"auto"}" data-auto-link-domains=""> <link rel="preload" href="https://global.discourse-cdn.com/standard17/assets/google-universal-analytics-v3-08add7ec997ab472fcd9f821d32ff7caf4b8b9a5de2ec18ca723a040be07a098.gz.js" as="script"> <script defer src="https://global.discourse-cdn.com/standard17/assets/google-universal-analytics-v3-08add7ec997ab472fcd9f821d32ff7caf4b8b9a5de2ec18ca723a040be07a098.gz.js"></script> <link rel="alternate nofollow" type="application/rss+xml" title="RSS feed of 'AWS Athena Connector Error'" href="https://discuss.redash.io/t/aws-athena-connector-error/10955.rss" /> <meta property="og:site_name" content="Redash Discourse" /> <meta property="og:type" content="website" /> <meta name="twitter:card" content="summary" /> <meta name="twitter:image" content="https://global.discourse-cdn.com/standard17/uploads/redash1/original/1X/e1838a8a0c506503a22e0c60e2334374b2895c87.png" /> <meta property="og:image" content="https://global.discourse-cdn.com/standard17/uploads/redash1/original/1X/e1838a8a0c506503a22e0c60e2334374b2895c87.png" /> <meta property="og:url" content="https://discuss.redash.io/t/aws-athena-connector-error/10955" /> <meta name="twitter:url" content="https://discuss.redash.io/t/aws-athena-connector-error/10955" /> <meta property="og:title" content="AWS Athena Connector Error" /> <meta name="twitter:title" content="AWS Athena Connector Error" /> <meta property="og:description" content="Can anyone help me with this error when I try to test the Athenas connector in Redash: Parameter validation failed: Unknown parameter in QueryExecutionContext: “Catalog”, must be one of: Database" /> <meta name="twitter:description" content="Can anyone help me with this error when I try to test the Athenas connector in Redash: Parameter validation failed: Unknown parameter in QueryExecutionContext: “Catalog”, must be one of: Database" /> <meta name="twitter:label1" value="Reading time" /> <meta name="twitter:data1" value="1 mins 🕑" /> <meta name="twitter:label2" value="Likes" /> <meta name="twitter:data2" value="2 ❤" /> <meta property="article:published_time" content="2022-08-26T15:40:20+00:00" /> <meta property="og:ignore_canonical" content="true" /> </head> <body class="crawler "> <header> <a href="/"> Redash Discourse </a> </header> <div id="main-outlet" class="wrap" role="main"> <div id="topic-title"> <h1> <a href="/t/aws-athena-connector-error/10955">AWS Athena Connector Error</a> </h1> </div> <div itemscope itemtype='http://schema.org/DiscussionForumPosting'> <meta itemprop='headline' content='AWS Athena Connector Error'> <meta itemprop='articleSection' content='Uncategorized'> <meta itemprop='keywords' content=''> <div itemprop='publisher' itemscope itemtype="http://schema.org/Organization"> <meta itemprop='name' content='Redash Discourse'> <div itemprop='logo' itemscope itemtype="http://schema.org/ImageObject"> <meta itemprop='url' content='https://global.discourse-cdn.com/standard17/uploads/redash1/original/1X/c07bc573841e1e4a0013ea3b6fe088a1534228a3.png'> </div> </div> <div id='post_1' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://discuss.redash.io/u/lscapim'><span itemprop='name'>lscapim</span></a> </span> <link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/aws-athena-connector-error/10955"> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2022-08-26T15:40:20Z' class='post-time'> August 26, 2022, 3:40pm </time> <meta itemprop='dateModified' content='2022-08-26T15:40:20Z'> <span itemprop='position'>1</span> </span> </div> <div class='post' itemprop='articleBody'> <p>Can anyone help me with this error when I try to test the Athenas connector in Redash:<br> Parameter validation failed: Unknown parameter in QueryExecutionContext: “Catalog”, must be one of: Database</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/CommentAction"/> <meta itemprop="userInteractionCount" content="0" /> </div> </div> <div id='post_2' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://discuss.redash.io/u/jesse'><span itemprop='name'>jesse</span></a> </span> <link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/aws-athena-connector-error/10955"> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2022-08-26T20:18:56Z' class='post-time'> August 26, 2022, 8:18pm </time> <meta itemprop='dateModified' content='2022-08-26T20:18:56Z'> <span itemprop='position'>2</span> </span> </div> <div class='post' itemprop='text'> <p>Have you entered a valid <code>Catalog</code> in the athena data source configuration screen?</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/CommentAction"/> <meta itemprop="userInteractionCount" content="2" /> </div> </div> <div id='post_3' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://discuss.redash.io/u/lscapim'><span itemprop='name'>lscapim</span></a> </span> <link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/aws-athena-connector-error/10955"> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2022-08-29T14:12:13Z' class='post-time'> August 29, 2022, 2:12pm </time> <meta itemprop='dateModified' content='2022-08-29T14:12:13Z'> <span itemprop='position'>3</span> </span> </div> <div class='post' itemprop='text'> <p>Yes, and i am following this issue about: <a href="https://github.com/getredash/redash/issues/5817" rel="noopener nofollow ugc">Unknown parameter in QueryExecutionContext: “Catalog” when create the Athena type datasource · Issue #5817 · getredash/redash (github.com)</a></p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="1" /> <span class='post-likes'>1 Like</span> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/CommentAction"/> <meta itemprop="userInteractionCount" content="0" /> </div> </div> <div id='post_4' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://discuss.redash.io/u/lscapim'><span itemprop='name'>lscapim</span></a> </span> <link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/aws-athena-connector-error/10955"> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2022-09-05T12:15:44Z' class='post-time'> September 5, 2022, 12:15pm </time> <meta itemprop='dateModified' content='2022-09-05T12:15:44Z'> <span itemprop='position'>4</span> </span> </div> <div class='post' itemprop='text'> <p>In the “S3 Staging (Query Results) Bucket Path” field, we need to put the S3 path, like this: arn:aws:s3:::my_bucket/####* or another way? We did a test with just the path: s3://my_bucket/ and the same error was reported.</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="1" /> <span class='post-likes'>1 Like</span> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/CommentAction"/> <meta itemprop="userInteractionCount" content="1" /> </div> </div> <div id='post_5' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://discuss.redash.io/u/jesse'><span itemprop='name'>jesse</span></a> </span> <link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/aws-athena-connector-error/10955"> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2022-09-05T12:17:10Z' class='post-time'> September 5, 2022, 12:17pm </time> <meta itemprop='dateModified' content='2022-09-05T12:17:10Z'> <span itemprop='position'>5</span> </span> </div> <div class='post' itemprop='text'> <p>The error you’re receiving says you need to provide a catalog in your connection details. Have you done this?</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/CommentAction"/> <meta itemprop="userInteractionCount" content="1" /> </div> </div> <div id='post_6' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://discuss.redash.io/u/lscapim'><span itemprop='name'>lscapim</span></a> </span> <link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/aws-athena-connector-error/10955"> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2022-10-03T15:06:23Z' class='post-time'> October 3, 2022, 3:06pm </time> <meta itemprop='dateModified' content='2022-10-03T15:06:23Z'> <span itemprop='position'>6</span> </span> </div> <div class='post' itemprop='text'> <p>Yes, and we had the same error…</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/CommentAction"/> <meta itemprop="userInteractionCount" content="0" /> </div> </div> </div> </div> <footer class="container wrap"> <nav class='crawler-nav'> <ul> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/' itemprop="url">Home </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/categories' itemprop="url">Categories </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/guidelines' itemprop="url">FAQ/Guidelines </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='http://redash.io/terms.html' itemprop="url">Terms of Service </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='http://redash.io/privacy.html' itemprop="url">Privacy Policy </a> </span> </li> </ul> </nav> <p class='powered-by-link'>Powered by <a href="https://www.discourse.org">Discourse</a>, best viewed with JavaScript enabled</p> </footer> </body> </html>