Missing settings: {[PWD]}: Unable to establish connection with data source

Question

Hey! I am trying to connect to Athena with Alteryx and have the following error: Error: Connect In-DB (1): Error SQLDriverConnect: [Amazon][ODBC] (11570) Required credential settings missing: {[PWD]}.[Amazon][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[PWD]}

Maybe anyone had the same error and know how to fix it?

jrgo · Answer

Hi @max1111

I've worked with your organization (based off your connection name) and the solution your IT created for allowing Alteryx to interact with your Athena tables is unique and requires an authorization token.

I'd suggest contacting your IT team so that they can confirm that the custom tools and authentication utilities required are properly installed on your machine.

Being vague on purpose as to not disclose information that is not common place or is proprietary so if you have additional questions, please DM me.

max1111 · Answer

let me also show what in db configuration I have