google-cloud-platformgoogle-bigquery

Select All Columns Except Some in Google BigQuery?

Is there a way to Select * except [x,y,z column names] in BigQuery? I see some solutions for MySQL but not sure if it applies to BQ.

Thank you.

Solution

  • There is nothing in current BigQuery SQL dialect that will allow it. But since this is recurring request, we have added work item to support

    SELECT * EXCEPT (a, b, c) FROM ...

    Update: This functionality is now available in BigQuery standard SQL. Details at https://cloud.google.com/bigquery/sql-reference/enabling-standard-sql Example using public wikipedia table - select all columns except title and comment:

    select * except(title, comment) from publicdata.samples.wikipedia limit 10