title: BigQuery - How to go beyond 10'000 columns?
body: <p>I am trying to find a way to query a very large (&gt;100k columns) and sparse table (&gt;99% sparsity) via BigQuery, but I hit the limit of 10'000 columns [1].
  Is there any way to circumvent this limitation, e.g. by querying an external BigTable [2] or Storage (Avro/Parquet/...) [3] ?</p>
  <p>Thanks for your support !</p>
  <p>References</p>
  <p>[1] <a href="https://cloud.google.com/bigquery/quotas" rel="nofollow noreferrer">https://cloud.google.com/bigquery/quotas</a></p>
  <p>[2] <a href="https://cloud.google.com/bigquery/external-data-bigtable" rel="nofollow noreferrer">https://cloud.google.com/bigquery/external-data-bigtable</a></p>
  <p>[3] <a href="https://cloud.google.com/bigquery/external-data-cloud-storage" rel="nofollow noreferrer">https://cloud.google.com/bigquery/external-data-cloud-storage</a></p>