File size: 847 Bytes
7f964ba
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
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
);