Alteryx Designer

Definitive answers from Designer experts.

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

Alteryx
Alteryx
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.