Amazon Athena Connector in Domo
Hello!
I am attempting to create a new amazon athena connection with an ATS. This connection has been created before, with 50 varying data pulls, however, the previous owner of the connections is no longer with us. Does anyone have knowledge as to how to properly create a new amazon athena connection, essentially mimicking the exact pull as the existing connection, without disrupting current data pulls?
Any guidance is more than welcome. Thanks.
Edit: This is basically my last resort :)
Keirsten
Answers
-
Hi @keeeirs10, have a look through this write-up (and other comments from this Q): https://dojo.domo.com/discussion/comment/56387#Comment_56387. Hopefully this'll help.
6 -
Hi @keeeirs10, gotcha so the credentials were not shared in Domo to any other admin before this analyst left. If you haven't already, you should inform Domo Support [support.domo.com] so that they may be able to bypass the access restriction and help map the data pull through your account.
8 -
I've reached out to Domo several times, and they are not able to assist because of the nature of the connector (Amazon Athena). They say to reach out to Amazon for assistance, but we have no business connections to Amazon on this particular team. Any other ideas? I appreciate the brainstorming!
0 -
@keeeirs10 ... domo support are correct but also not correct ;)
in Domo, to see the configuration of a dataset in Domo, the account that was used to configure the connector must have been shared with you. because it wasn't ... you're unable to see the configuration of the connector.
Domo are working on expanding functionality to make it easier to reassign connectors, but isn't a feature in product yet.
Regarding Amazon Athena, theoretically yes, it is possible to see the connections to a SQL database and see what query that connection is executing. I would start here: https://docs.aws.amazon.com/athena/latest/ug/query-metrics-viewing.html
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive