Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Alteryx Designer: Unable to select or change the database on an existing Gallery data connection

gtorres8
Alteryx Alumni (Retired)
Created

Environment Details


Not able to select a different database for existing Gallery connections for SQL Server within Designer.
  • Gallery
  • SQL Server
  • Alteryx Designer


Cause


In Designer, when selecting an existing Gallery connection, it's not possible to switch or select a database from a SQL Server connection. The gallery connection points to a default database in SQL Server or only one specific database, but the user needs to select a different database to write to the appropriate table.



Resolution


Have the Gallery Admin user create a new Data Connection pointing to the desired database. Then assign the appropriate user(s) and/or studio(s) to the new Data Connection. See the following help site for more details.

NOTE: Use best practice to name the Gallery Data Connection related to the SQL Server Instance and Database name that it will be configured for.