Tableau will need the database name for the queries to run. So, I do not think you can achieve what you want. Let me know if I am wrong.
Like I said, there is one database that all states will share. It needs to get the database name of the state database as an input to the stored procedure. So, I just need a way to pass that through a query string parameter and then into my stored procedure.