'Drop column in BQ table won't drop column from Information schema
From BQ table if we drop a column, the output of "select * from table" query won't show the dropped column. but if we generate the DDL Script from information schema, we still can see the dropped column available in output script.
Solution 1:[1]
try recreate table without this column instead
https://popsql.com/learn-sql/bigquery/how-to-drop-a-column-in-bigquery
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |