Skip to Main Content
Preset Feature Feedback
Status Gathering Feedback
Categories Enhancement
Created by Tharuman Thavakumar
Created on Jan 13, 2022

MFA Block when Connecting to AWS Athena

1) What is the problem or goal the end user is trying to solve or accomplish?

Currently connecting to Amazon Athena is blocked if MFA is enabled. This prevents the analyst from being able to connect to the DB and provides an error message:

ERROR: (builtins.NoneType) None

(Background on this error at: http://sqlalche.me/e/13/dbapi)

Hypothesis is that this is linked to MFA limitations with Preset/Superset configuration.

2) How are they solving it currently?

Either a Serial number needs to be added to the connection string, or a AWS user account created without a MFA policy to circumvent the block.

3) What is the recommended solution by the Customer?

Remediate the block caused by MFA policy and enable connecting with it. Customer mentioned that MFA is becoming a standard policy from a security perspective.

  • Attach files