Dynamic table references in SQL question


I am trying to create basic tabular format report for a lot of tables. The query will be a simple select statement. I want to create this for more than 100 different tables.

I want to know if there are ways to provide the table name dynamically


select col1, col2, col3 from <table_name>

and <table_name> is values from a list. The list can be json, values from another table etc.

I can do this one by one if there are few reports. But to get this done for more than 100 different tables is time consuming

nope, not yet, Allow filter variable for database/schema/table/column reference · Issue #4639 · metabase/metabase · GitHub

1 Like