title: Selecting entire tables based on wildcard name values SQL - Tableau
body: <p>What I'm trying to do is to pull out a subset of tables from a Google Big Query Dataset based on the name of those tables and then add those tables to a Tableau datasource without having to join or union any of the tables.</p>
  <p>I want to pull out all the tables beginning with System_1, from the below dataset</p>
  <ol>
  <li>System_1_Start</li>
  <li>System_1_Middle</li>
  <li>System_1_End</li>
  <li>System_2_Start</li>
  <li>System_2_Middle</li>
  <li>System_2_End</li>
  <li>System_3_Start</li>
  <li>System_3_Middle</li>
  <li>System_3_End</li>
  </ol>
  <p>I have been able to do a wildcard search using Information_Schema.Tables to get all the names of the tables that begin with System_1, but I cannot figure out a way to then get all of the tables with those names as the output of the query (SQL below)</p>
  <pre><code>SELECT table_name
  AS matchingTables
  FROM dataset.INFORMATION_SCHEMA.TABLES
  WHERE table_name LIKE 'System_1%'
  </code></pre>
  <p>How do I go about extracting those tables and not just the names of those tables?</p>
  <p><strong>~~~~~~~~~~~EDIT~~~~~~~~~~~~~</strong></p>
  <p>This is the best approximation as to how I could have done this but I'm getting a dataset not found error which is strange</p>
  <pre><code>SELECT *
  FROM dataset
  WHERE (SELECT table_name FROM dataset.INFORMATION_SCHEMA.TABLES)
  LIKE 'System_1%'
  </code></pre>
  <p>Error Recieved:</p>
  <p>Not found: Dataset dataset:dataset was not found in location EU</p>