Can you create a table IN metabase?

Get Help
1

I know it's not ideal, but can you create a permanent table in metabase (created by merging together several table via native query, or other function) that can be accessed by other queries?

2

Hi @saaballergies
You can use CTE https://www.metabase.com/learn/sql-questions/sql-cte or Sub-Query https://www.metabase.com/docs/latest/users-guide/referencing-saved-questions-in-queries.html
There's work being done to add some persistence in upcoming versions: https://github.com/metabase/metabase/issues/22538

But ETL should currently be done elsewhere, so Metabase just consumes the data.