title: How to find all tables and datasets/databases which have a specific column name in big query
body: <p>I want to find a specific column name across all tables across all datasets/databases in Big Query.</p>
  <p>In Teradata it can be done by running the following:</p>
  <pre><code>SELECT 
      DatabaseName, 
      TableName, 
      ColumnName 
  FROM 
      DBC.Columns 
  WHERE 
      ColumnName LIKE '%sender_country%' 
      AND DatabaseName NOT LIKE '%test%' 
      AND tablename LIKE '%sender%'
  </code></pre>
  <p>How can the same thing done be in Big Query?</p>
  <p>I know we can look for different columns inside a particular dataset by running the following:</p>
  <pre><code>SELECT
      ddl 
  FROM
      project-name.my_database_name.INFORMATION_SCHEMA.TABLES
  WHERE 
      table_name like '%sender%' 
      AND ddl LIKE '%sender_country%' 
  </code></pre>
  <p>But the above query limits the search to only one dataset/database (in this example <code>my_database_name</code>).</p>
  <p>How do I extend the search across all datasets?</p>