title: How to use bigquery correlation based on many columns?
body: <p>Given a dataset of 100k rows and 100 columns, how is it possible to use bigquery CORR() to find the correlation between the rows?</p>
  
  <p>The schema is:</p>
  
  <pre><code>id:integer, feature1:float, feature2:float, ..., feature100:float
  </code></pre>
  
  <p><strong>Edit</strong> This is not a rolling window time series correlation problem. Each row is an observation of 100 features, and I'd like to use bigquery to find the top N similar observations for each row.</p>