Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email for assistance.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Select Tool fields show as missing & data types show unknown when querying from a database


Environment Details

The Select Tool will show the fields as missing in orange text & data types show unknown when querying from a database connection and when the workflow is run at least once. The issue occurs every time the workflow is opened and/or edited.
idea Skyscrapers
  • Alteryx - Designer
    • Version N/A
  • Select Tool
  • MongoDB


Tool settings.


  1. Select the "Disable Auto Configure" option by going to Tools > User Settings > Advanced & then check "Disable Auto Configure". Check this box if you are importing or editing an existing complicated module where tools will need to be configured manually.
    • By checking this box, you may find resources are better allocated and optimized.
  2. Rerun the workflow.

idea Skyscrapers

No ratings

If you choose to "Disable Auto Configure" that apply to all workflows that you open.  When you want to update the configuration you can do so by pressing F5.