【🔎 SQL】テーブル確認

|| テーブル確認（全体）

select
    *
from 'my_pj.my_ds.yellow_taxi_2015'
;

	vendor_id	pickup_datetime	dropoff_datetime	passenger_count	payment_type	trip_distance	pickup_longitude	pickup_latitude	rate_code	store_and_fwd_flag
CMT	2015-12-02T18:40:42Z	2015-12-02T18:55:58Z	1	1	2.0	-73.984215	40.77003	1.0	0.0	-73.9625

select
    count(*) as record
from 'my_pj.my_ds.yellow_taxi_2015'
;

	record
1	146,112,991

select
    table_name,
    column_name,
    data_type
from `my_pj.my_ds.INFORMATION_SCHEMA.COLUMNS`
where table_name="yellow_taxi_2015"
;