Skip to content

Instantly share code, notes, and snippets.

@sh16ma

sh16ma/shape.sql

Last active January 19, 2022 10:10
Show Gist options
  • Save sh16ma/387443a8ca6744684c146e5ed53e77cf to your computer and use it in GitHub Desktop.
Save sh16ma/387443a8ca6744684c146e5ed53e77cf to your computer and use it in GitHub Desktop.
Download ZIP
#🔎 #BigQuery #テーブルデータ確認 #行列 #sahpe的な
Raw
shape.sql
#standaardSQL
select
(select count(*) from `pj.ds.tb`) as no_of_row
, count(*) as no_of_col
from
`pj.ds.INFORMATION_SCHEMA.COLUMNS`
where
table_name = `{tb}` -- 必要　に応じて絞り込み
;
@sh16ma
Copy link
Author

sh16ma commented Nov 9, 2021 •
edited
Loading

クエリ完了（経過時間: 1.0 秒、処理されたバイト数: 10 MB）

img

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment