title: How To Find The BigQuery Table Required Columns
body: <p>I have a table in the BigQuery that I would like to know what fields are required. How do I do that?  Thanks in advance!</p>
  <p>I tried the following queries, but none of them tell me the required field information.</p>
  <pre><code>SELECT * FROM mydataset.INFORMATION_SCHEMA.TABLES;
  
  SELECT column_name, data_type
  FROM `myprojectid`.mydataset.INFORMATION_SCHEMA.COLUMNS
  WHERE table_name = 'mytablename'
  </code></pre>