Dynamic table references in SQL question

1

Hi,

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

eg.

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

2

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

1 Like