Sri Lanka Weather Dataset

station_id Station Id	station_name Station Name	element_name Element Name	year Year	month Month	day Day	obs_val Obs Val
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	1
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	2
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	3
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	4
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	5
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	6	1
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	7	2.5
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	8	12
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	9	34.2
01CB0080	DEHIWALA ZOO	PRECIP	2012	1	10	49.5


CREATE TABLE dehiwala_rf_2012_2018 (
  "station_id" VARCHAR,
  "station_name" VARCHAR,
  "element_name" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "obs_val" DOUBLE
);