Adding multiple, different (SQL / MySQL) data sources breaks smart variables.

[dreger]

Previously, I had set up Blazer with a single MySQL data source. I had several smart variables set up and working. Here's an excerpt:

smart_variables:
      company_id: "SELECT id, name FROM companies ORDER BY name ASC"
      product_id: "SELECT id, name FROM products ORDER BY name ASC"
      team_id: "SELECT id, name FROM teams ORDER BY name ASC"

However, once I added an additional data source (this time an MS SQL database), the existing MySQL smart variables no longer displayed as select boxes. I only get inputs now.

Oddly enough, smart variables that pull from tables in the MS SQL database appear to be working.

I think the issue may stem from conflicting table names in the MySQL and MS SQL databases, eg. both database might have a products table, and the smart variable doesn't know which database to pull from. However, attempting to modify my blazer queries to include use mysqldatabase haven't fixed the issue. Thanks!

[ankane]

Hey @kqdreger, smart variables should pull from their respective data sources without conflict. My hunch is the config is not correct. If you want to paste your YAML file (with private info removed), I can take a look.

[dreger]

I'm a dummy — I didn't see that smart variables were nested under each data_sources / database. I had all the smart variables in one group, and it happened to be nested under my MS SQL database. All clear now, thanks 👍