How to combine multiple saved questions into one?

Get Help
1

Hello! I have 50 saved questions in Metabase (PostgreSQL) that share:

  • Identical column structure
  • Text information
  • Financial formulas that need consolidation

Goal:
Merge them into a single saved question to create a summarized financial report.

Problem:
Manually copying each query's SQL and combining with UNION ALL is impractical due to:

  • Time-consuming process
  • Risk of errors in formula aggregation

What I’ve tried:

  1. UNION ALL in a Native Query
  2. Models
  3. Persisted Questions — I don’t have access to the Enterprise version.
  4. Snippets

Constraints:

  • Cannot create new tables/views in the database
  • Must stay within Metabase's native functionality (no external scripts preferred)

Key Questions:

  1. Is there a bulk export method for saved questions' SQL?
  2. Are there hidden features or workarounds for formula aggregation?
2

Can you describe, or provide an example of, the desired output?