Amazon Athena Connector in Domo

keeeirs10
keeeirs10 ⚪️
edited May 6 in Connectors

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

  • amehdad
    amehdad 🔵

    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.

  • keeeirs10
    keeeirs10 ⚪️

    Hi @amehdad,

    Thanks for your response! It seems for your link, I would need access to the old ownership credentials. Because the analyst is no longer with us, there is no way for me to do that.

  • amehdad
    amehdad 🔵

    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.

  • keeeirs10
    keeeirs10 ⚪️

    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!

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @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 heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"