AWS QuickSight can't see Athena DB
I have a database in Athena, with an external table pointing to a directory in my S3 bucket. I can query the tables fine in Athena.
When I go to create a new data set in QuickSight, and I select Athena as my source, I don't see my database.
I have followed the instructions here;
https://docs.aws.amazon.com/quicksight/latest/user/managing-permissions.html
and here;
https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-connect-athena.html
I also updated the QuickSight S3 policy to ensure QuickSght could List, Read and Write, but still nothing.
Based on the AWS documentation I feel I should be seeing the DB, but clearly I am missing something?
amazon-web-services amazon-s3 amazon-athena amazon-quicksight
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
add a comment |
I have a database in Athena, with an external table pointing to a directory in my S3 bucket. I can query the tables fine in Athena.
When I go to create a new data set in QuickSight, and I select Athena as my source, I don't see my database.
I have followed the instructions here;
https://docs.aws.amazon.com/quicksight/latest/user/managing-permissions.html
and here;
https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-connect-athena.html
I also updated the QuickSight S3 policy to ensure QuickSght could List, Read and Write, but still nothing.
Based on the AWS documentation I feel I should be seeing the DB, but clearly I am missing something?
amazon-web-services amazon-s3 amazon-athena amazon-quicksight
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
add a comment |
I have a database in Athena, with an external table pointing to a directory in my S3 bucket. I can query the tables fine in Athena.
When I go to create a new data set in QuickSight, and I select Athena as my source, I don't see my database.
I have followed the instructions here;
https://docs.aws.amazon.com/quicksight/latest/user/managing-permissions.html
and here;
https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-connect-athena.html
I also updated the QuickSight S3 policy to ensure QuickSght could List, Read and Write, but still nothing.
Based on the AWS documentation I feel I should be seeing the DB, but clearly I am missing something?
amazon-web-services amazon-s3 amazon-athena amazon-quicksight
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
I have a database in Athena, with an external table pointing to a directory in my S3 bucket. I can query the tables fine in Athena.
When I go to create a new data set in QuickSight, and I select Athena as my source, I don't see my database.
I have followed the instructions here;
https://docs.aws.amazon.com/quicksight/latest/user/managing-permissions.html
and here;
https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-connect-athena.html
I also updated the QuickSight S3 policy to ensure QuickSght could List, Read and Write, but still nothing.
Based on the AWS documentation I feel I should be seeing the DB, but clearly I am missing something?
amazon-web-services amazon-s3 amazon-athena amazon-quicksight
amazon-web-services amazon-s3 amazon-athena amazon-quicksight
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
asked Nov 13 '18 at 0:50
Nibroc A RehpotsirhcNibroc A Rehpotsirhc
1228
1228
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I had the same issue, after a moment realized that my athena tables are present in eu-west region and I am searching in us-east region in Quicksight.
Please ensure you are searching in the same region where your tables are present.
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
That worked, amazing that isn't in any of their guides!
– Nibroc A Rehpotsirhc
Nov 13 '18 at 19:25
It solved my problem as well. Thank you :)
– Shoresh
Jan 17 at 19:20
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272205%2faws-quicksight-cant-see-athena-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I had the same issue, after a moment realized that my athena tables are present in eu-west region and I am searching in us-east region in Quicksight.
Please ensure you are searching in the same region where your tables are present.
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
That worked, amazing that isn't in any of their guides!
– Nibroc A Rehpotsirhc
Nov 13 '18 at 19:25
It solved my problem as well. Thank you :)
– Shoresh
Jan 17 at 19:20
add a comment |
I had the same issue, after a moment realized that my athena tables are present in eu-west region and I am searching in us-east region in Quicksight.
Please ensure you are searching in the same region where your tables are present.
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
That worked, amazing that isn't in any of their guides!
– Nibroc A Rehpotsirhc
Nov 13 '18 at 19:25
It solved my problem as well. Thank you :)
– Shoresh
Jan 17 at 19:20
add a comment |
I had the same issue, after a moment realized that my athena tables are present in eu-west region and I am searching in us-east region in Quicksight.
Please ensure you are searching in the same region where your tables are present.
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
I had the same issue, after a moment realized that my athena tables are present in eu-west region and I am searching in us-east region in Quicksight.
Please ensure you are searching in the same region where your tables are present.
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
answered Nov 13 '18 at 7:32
Satyavolu Ramana KumarSatyavolu Ramana Kumar
362
362
That worked, amazing that isn't in any of their guides!
– Nibroc A Rehpotsirhc
Nov 13 '18 at 19:25
It solved my problem as well. Thank you :)
– Shoresh
Jan 17 at 19:20
add a comment |
That worked, amazing that isn't in any of their guides!
– Nibroc A Rehpotsirhc
Nov 13 '18 at 19:25
It solved my problem as well. Thank you :)
– Shoresh
Jan 17 at 19:20
That worked, amazing that isn't in any of their guides!
– Nibroc A Rehpotsirhc
Nov 13 '18 at 19:25
That worked, amazing that isn't in any of their guides!
– Nibroc A Rehpotsirhc
Nov 13 '18 at 19:25
It solved my problem as well. Thank you :)
– Shoresh
Jan 17 at 19:20
It solved my problem as well. Thank you :)
– Shoresh
Jan 17 at 19:20
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272205%2faws-quicksight-cant-see-athena-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
