ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

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.