We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

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