BQ sql メモ

--文字列の最大長を取得

from `mh_project.ibushima_dataset.kihiko`
;

--パーティション確認

from `mh_project.kinjisi_dataset.rolling_table`
where _PARTITIONTIME > '2021-01-01'
group by _PARTITIONTIME
order by _PARTITIONTIME
;

--一部カラムを除外してcreate
```create or replace table mh_project.furufuru_dataset.puyopuyo_table as
select *except (camp_send_date) from `mh_project.furufuru_dataset.puyopuyo_table__20210101`
;