spanconfig: add secondary tenant config for SQLTranslator datadriven tests #71733
Description
Describe the problem
We currently only run the SQLTranslator tests introduced in #71359 for the host tenant. We should extend these to run them for secondary tenants as well.