weather1

CREATE SCHEMA IF NOT EXISTS kdz17;
DROP TABLE IF EXISTS kdz17.src_weather_facts;
CREATE TABLE IF NOT EXISTS kdz17.src_weather_facts (
      local_datetime varchar(25) NULL
   ,  t_air_temperature numeric(3, 1) NULL
   ,  p0_sea_lvl numeric(4, 1) NULL
   ,  p_station_lvl numeric(4, 1) NULL
   ,  u_humidity INT NULL
   ,  dd_wind_direction varchar(100) NULL
   ,  ff_wind_speed INT NULL
   ,  ff10_max_gust_value INT NULL
   ,  ww_present varchar(100) NULL
   ,  ww_recent varchar(50) NULL
   ,  c_total_clouds varchar(200) NULL
   ,  vv_horizontal_visibility numeric(3, 1) NULL
   ,  td_temperature_dewpoint numeric(3, 1) NULL
   ,  loaded_ts TIMESTAMP NOT NULL DEFAULT NOW()
);