Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

max1111
7 - Meteor

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?

max1111_0-1683817655794.png

 

2 REPLIES 2
max1111
7 - Meteor

let me also show what in db configuration I have 

max1111_0-1683820807143.pngmax1111_1-1683820827491.png

 

jrgo
14 - Magnetar

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.

Labels