title: BigQuery get table schema via query
body: <p>Is it possible to get BigQuery table schema info via query? (Something like <strong>TABLES</strong> but for schema). Not interested in cli approach.</p>
  
  <p>What I'm trying to achieve is to perform an "incremental" update between 2 BQ tables (let`s say staging and production) with the same structure based on 1 "key" column, but with an automatic way to create the key and the rest of the hash based on all other columns.</p>
  
  <p>In MySQL/mariadb would be something like. Get the columns from information_schema.columns for the specific table and string agg all columns based with COLUMN_TYPE = "PRI" and keep is as key, and then get all the others with a string agg also. This would auto generate a SQL query in order to do the rest stuff.</p>
  
  <p>So the starting question is if there is something relevant to MySQL's <code>information_schema.COLUMNS</code></p>