Last active
January 19, 2022 10:10
-
-
Save sh16ma/387443a8ca6744684c146e5ed53e77cf to your computer and use it in GitHub Desktop.
#🔎 #BigQuery #テーブルデータ確認 #行列 #sahpe的な
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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}` -- 必要 に応じて絞り込み | |
; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
クエリ完了(経過時間: 1.0 秒、処理されたバイト数: 10 MB)