create_table.txt

CREATE TABLE `central_database.openweathermap` (
    City STRING,
    Time_of_Data_Calculation TIMESTAMP,
    Coordinates STRUCT<
        lat FLOAT64,
        lon FLOAT64
    >,
    Weather_ID INT64,
    Weather_Main STRING,
    Weather_Description STRING,
    Temperature FLOAT64,
    Feels_Like FLOAT64,
    Temp_Min FLOAT64,
    Temp_Max FLOAT64,
    Pressure FLOAT64,
    Humidity INT64,
    Sea_Level FLOAT64,
    Ground_Level FLOAT64,
    Visibility INT64,
    Wind_Speed FLOAT64,
    Wind_Degree FLOAT64,
    Wind_Gust FLOAT64,
    Cloudiness INT64,
    Cloudiness_Name STRING,
    Rain_1h FLOAT64,
    Rain_3h FLOAT64,
    Snow_1h FLOAT64,
    Snow_3h FLOAT64,
    Country_Code STRING,
    Sunrise_Time TIMESTAMP,
    Sunset_Time TIMESTAMP,
    Timezone INT64,
    City_ID INT64,
    City_Name STRING
);