MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / Connection Error: SBD Snowflake Input Can't find any file matching odbc:DSN Make sure the file ...
Connection Error: SBD Snowflake Input Can't find any file matching odbc:DSN Make sure the file path is correct.
user

Created/Edited - 12/6/2024 by Michael Phipps | Alteryx

Summary
Article-2959
Description

When we are trying to setup Snowflake ODBC connection using Oauth Authentication Getting below error:

Error: SBD Snowflake Input (2): Tool #108: Record #1: Tool #79: Can't find any file matching "odbc:DSN=xxxx;UID=xxxx;PWD=xxxx;token=xxxx|||select * from PROD LIMIT 3;". Make sure the file path is correct.

 

image001.png

Environment
  • Alteryx Designer
  • Snowflake
    • Third party connector macro "Snowflake Input"
    • ODBC DSN String

 

Cause
  • Snowflake Oauth/SSO is supported only with In-DB Tools using DCM
  • The third party macro was not built using In-DB
Resolution
  1. Use In-DB tools
  2. Use DCM to setup the Snowflake connection for OAuth Authentication credentials. The credential items required are as follows:
  • Client ID
  • OAUTH_CLIENT_SECRET
  • Port
  • Redirect URL

For Browser authentication prompt:

  • User name
  • Password
Additional Information
Was this article helpful?