Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.

Configuring Impala connection to use Windows Kerberos


Starting in 10.1, Alteryx added the ability to connect with MIT Kerberos based Impala implementations. With this feature, came the need to tell the Simba Impala driver that you are using Windows Kerberos and not MIT's version. The typical sign that you need to enable this option is this error: 


[Simba][ImpalaODBC] (100) Error from the Impala Thrift API: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure.  Minor code may provide more information.




Make sure you have the latest Simba Impala driver for the next steps. To enable the Windows Kerberos in the driver:

  • Open the ODBC Administrator

 ODBC Admin.png


  • Select the User or System Impala DSN that you have configured and press Configure



  • Once in the Simba Impala ODBC Driver DSN Setup window, press on Advanced Options



  • Under Advanced Options, check the Enable for this DSN for the Use Only SSPI


  • Press OK on all the windows, start Alteryx and test your connection.


If you still can’t get the connection to work, please email and one of us will reach out to you.


Fadi Bassil,

Client Services, UK. 



Got the below error for HIVE using SIMBA HIVE ODBC driver. I have enabled the SSPI and ODBC test has succeeded but Designer failed. Any config need to be further tuned.