Hackolade

Snowflake Physical Model

Schema for:

Model name: Sample Weather Data

Author:

Version:

File name: Sample Weather Data.json

File path: C:\Users\Pascal\Documents\Hackolade\Models\Snowflake\Sample Weather Data.json

Printed On: Thu Apr 09 2020 00:17:27 GMT+0200 (Central European Summer Time)

Created with: Hackolade - Visual data modeling for NoSQL and multimodel databases

1. Model

2. Schemas

2.1 WEATHER
2.1.2. Tables
2.1.2.1 DAILY_14_TOTAL
2.1.2.2 DAILY_16_TOTAL
2.1.2.3 HOURLY_14_TOTAL
2.1.2.4 HOURLY_16_TOTAL
2.1.2.5 WEATHER_14_TOTAL

1. Model

1.1 Model Sample Weather Data

1.1.1 Sample Weather Data Entity Relationship Diagram

Schemas

Show all

WEATHER

1.1.2 Sample Weather Data Properties

Property	Value
Model name	Sample Weather Data
DB vendor	Snowflake

1.1.3 Sample Weather Data User-Defined Types

2. Schemas

2.1 Schema WEATHER

2.1.1 WEATHER Properties

Property	Value
Schema name	WEATHER
Technical name
Comments	From example described at https://docs.snowflake.com/en/user-guide/sample-data-openweathermap.html
Database	SNOWFLAKE_SAMPLE_DATA
Transient	false
Managed access	NO
Data retention in days	1
Remarks	TPC-H, OpenWeatherMap, etc

2.1.2 WEATHER Tables

2.1.2.1 Table DAILY_14_TOTAL

2.1.2.1.1 DAILY_14_TOTAL Tree Diagram

{...}

DAILY_14_TOTAL

{ts-ntz}

{...}

city

[...]

data

{123}

time

{...}

coord

{ABC}

country

{123}

{ABC}

name

{...}

[0]*

{123}

lat

{123}

lon

{123}

clouds

{123}

deg

{123}

humidity

{123}

pressure

{123}

rain

{123}

snow

{123}

speed

{...}

temp

{123}

uvi

[...]

weather

{123}

day

{123}

eve

{123}

max

{123}

min

{123}

morn

{123}

night

{...}

[0]*

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.1.2 DAILY_14_TOTAL Properties

Property	Value
Table	DAILY_14_TOTAL
Technical name
Id
Schema	WEATHER
Additional properties	false
Comments
Temporary
Transient	false
External	false
Primary key
Cluster by
[1] Expression
Key
Stage file format	CSV
Format type options	[object Object]
Stage copy options
Data retention in days	1
Like
Clone
Copy grants
Remarks

2.1.2.1.3 DAILY_14_TOTAL Column

Column	Type	Req	Key	Description	Comments
T	timestamp_ntz(9)	true
V	variant	true
city	jsonObject	true
coord	jsonObject	true
lat	jsonNumber	true
lon	jsonNumber	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true
data	jsonArray	true
[0]	jsonObject	false
clouds	jsonNumber	true
deg	jsonNumber	true
dt	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
rain	jsonNumber	false
snow	jsonNumber	false
speed	jsonNumber	true
temp	jsonObject	true
day	jsonNumber	true
eve	jsonNumber	true
max	jsonNumber	true
min	jsonNumber	true
morn	jsonNumber	true
night	jsonNumber	true
uvi	jsonNumber	true
weather	jsonArray	true
[0]	jsonObject	false
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true
time	jsonNumber	true

2.1.2.1.3.1 Column V

2.1.2.1.3.1.1 V Tree Diagram

{...}

city

[...]

data

{123}

time

2.1.2.1.3.1.2 V Hierarchy

Parent Column: DAILY_14_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
city	jsonObject	true
data	jsonArray	true
time	jsonNumber	true

2.1.2.1.3.1.3 V properties

Property	Value
Business Name	V
Type	variant
Variant type	JSON
Not null	true
Additional properties	false

2.1.2.1.3.2 Column city

2.1.2.1.3.2.1 city Tree Diagram

{...}

city

{...}

coord

{ABC}

country

{123}

{ABC}

name

2.1.2.1.3.2.2 city Hierarchy

Parent Column: DAILY_14_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
coord	jsonObject	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true

2.1.2.1.3.2.3 city properties

Property	Value
Business Name	city
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.1.3.3 Column coord

2.1.2.1.3.3.1 coord Tree Diagram

{...}

coord

{123}

lat

{123}

lon

2.1.2.1.3.3.2 coord Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
lat	jsonNumber	true
lon	jsonNumber	true

2.1.2.1.3.3.3 coord properties

Property	Value
Business Name	coord
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.1.3.4 Column lat

2.1.2.1.3.4.1 lat properties

Property	Value
Business Name	lat
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	-12.28389

2.1.2.1.3.5 Column lon

2.1.2.1.3.5.1 lon properties

Property	Value
Business Name	lon
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	-40.493889

2.1.2.1.3.6 Column country

2.1.2.1.3.6.1 country properties

Property	Value
Business Name	country
Type	jsonString
Required	true
Sample	BR

2.1.2.1.3.7 Column id

2.1.2.1.3.7.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	3450832

2.1.2.1.3.8 Column name

2.1.2.1.3.8.1 name properties

Property	Value
Business Name	name
Type	jsonString
Required	true
Sample	Ruy Barbosa

2.1.2.1.3.9 Column data

2.1.2.1.3.9.1 data Tree Diagram

[...]

data

{...}

[0]*

2.1.2.1.3.9.2 data Hierarchy

Parent Column: city

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.1.3.9.3 data properties

Property	Value
Business Name	data
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.1.3.10 Column data

2.1.2.1.3.10.1 data Tree Diagram

{...}

data

{123}

clouds

{123}

deg

{123}

humidity

{123}

pressure

{123}

rain

{123}

snow

{123}

speed

{...}

temp

{123}

uvi

[...]

weather

2.1.2.1.3.10.2 data Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
clouds	jsonNumber	true
deg	jsonNumber	true
dt	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
rain	jsonNumber	false
snow	jsonNumber	false
speed	jsonNumber	true
temp	jsonObject	true
uvi	jsonNumber	true
weather	jsonArray	true

2.1.2.1.3.10.3 data properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.1.3.11 Column clouds

2.1.2.1.3.11.1 clouds properties

Property	Value
Business Name	clouds
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	0

2.1.2.1.3.12 Column deg

2.1.2.1.3.12.1 deg properties

Property	Value
Business Name	deg
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	29

2.1.2.1.3.13 Column dt

2.1.2.1.3.13.1 dt properties

Property	Value
Business Name	dt
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1519797600

2.1.2.1.3.14 Column humidity

2.1.2.1.3.14.1 humidity properties

Property	Value
Business Name	humidity
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	0

2.1.2.1.3.15 Column pressure

2.1.2.1.3.15.1 pressure properties

Property	Value
Business Name	pressure
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	789.88

2.1.2.1.3.16 Column rain

2.1.2.1.3.16.1 rain properties

Property	Value
Business Name	rain
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	0.25

2.1.2.1.3.17 Column snow

2.1.2.1.3.17.1 snow properties

Property	Value
Business Name	snow
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	0.18

2.1.2.1.3.18 Column speed

2.1.2.1.3.18.1 speed properties

Property	Value
Business Name	speed
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1.23

2.1.2.1.3.19 Column temp

2.1.2.1.3.19.1 temp Tree Diagram

{...}

temp

{123}

day

{123}

eve

{123}

max

{123}

min

{123}

morn

{123}

night

2.1.2.1.3.19.2 temp Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
day	jsonNumber	true
eve	jsonNumber	true
max	jsonNumber	true
min	jsonNumber	true
morn	jsonNumber	true
night	jsonNumber	true

2.1.2.1.3.19.3 temp properties

Property	Value
Business Name	temp
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.1.3.20 Column day

2.1.2.1.3.20.1 day properties

Property	Value
Business Name	day
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	271.87

2.1.2.1.3.21 Column eve

2.1.2.1.3.21.1 eve properties

Property	Value
Business Name	eve
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	271.87

2.1.2.1.3.22 Column max

2.1.2.1.3.22.1 max properties

Property	Value
Business Name	max
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	271.87

2.1.2.1.3.23 Column min

2.1.2.1.3.23.1 min properties

Property	Value
Business Name	min
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	271.87

2.1.2.1.3.24 Column morn

2.1.2.1.3.24.1 morn properties

Property	Value
Business Name	morn
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	271.87

2.1.2.1.3.25 Column night

2.1.2.1.3.25.1 night properties

Property	Value
Business Name	night
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	271.87

2.1.2.1.3.26 Column uvi

2.1.2.1.3.26.1 uvi properties

Property	Value
Business Name	uvi
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	6.689

2.1.2.1.3.27 Column weather

2.1.2.1.3.27.1 weather Tree Diagram

[...]

weather

{...}

[0]*

2.1.2.1.3.27.2 weather Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.1.3.27.3 weather properties

Property	Value
Business Name	weather
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.1.3.28 Column weather

2.1.2.1.3.28.1 weather Tree Diagram

{...}

weather

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.1.3.28.2 weather Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true

2.1.2.1.3.28.3 weather properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.1.3.29 Column description

2.1.2.1.3.29.1 description properties

Property	Value
Business Name	description
Type	jsonString
Required	true
Sample	sky is clear

2.1.2.1.3.30 Column icon

2.1.2.1.3.30.1 icon properties

Property	Value
Business Name	icon
Type	jsonString
Required	true
Sample	01dd

2.1.2.1.3.31 Column id

2.1.2.1.3.31.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	800

2.1.2.1.3.32 Column main

2.1.2.1.3.32.1 main properties

Property	Value
Business Name	main
Type	jsonString
Required	true
Sample	Clear

2.1.2.1.3.33 Column time

2.1.2.1.3.33.1 time properties

Property	Value
Business Name	time
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1518544107

2.1.2.1.3.34 Column T

2.1.2.1.3.34.1 T properties

Property	Value
Business Name	T
Type	timestamp_ntz
Precision	9
Primary key	true
Not null	true
Sample	2018-02-13 09:48:27.000

2.1.2.1.4 DAILY_14_TOTAL Snowflake DDL script

CREATE OR REPLACE DATABASE "SNOWFLAKE_SAMPLE_DATA"; USE DATABASE "SNOWFLAKE_SAMPLE_DATA"; CREATE OR REPLACE SCHEMA "WEATHER"	WITH MANAGED ACCESS	DATA_RETENTION_TIME_IN_DAYS=1	COMMENT='From example described at https://docs.snowflake.com/en/user-guide/sample-data-openweathermap.html'; USE SCHEMA "WEATHER"; CREATE OR REPLACE TABLE	"DAILY_14_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1;

2.1.2.2 Table DAILY_16_TOTAL

2.1.2.2.1 DAILY_16_TOTAL Tree Diagram

{...}

DAILY_16_TOTAL

{ts-ntz}

{...}

city

[...]

data

{123}

time

{...}

coord

{ABC}

country

{123}

{ABC}

name

{...}

[0]*

{123}

lat

{123}

lon

{123}

clouds

{123}

deg

{123}

humidity

{123}

pressure

{123}

rain

{123}

snow

{123}

speed

{...}

temp

{123}

uvi

[...]

weather

{123}

day

{123}

eve

{123}

max

{123}

min

{123}

morn

{123}

night

{...}

[0]*

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.2.2 DAILY_16_TOTAL Properties

Property	Value
Table	DAILY_16_TOTAL
Technical name
Id
Schema	WEATHER
Additional properties	false
Comments
Temporary
Transient	false
External	false
Primary key
Cluster by
[1] Expression
Key
Stage file format	CSV
Format type options	[object Object]
Stage copy options
Data retention in days	1
Like
Clone
Copy grants
Remarks

2.1.2.2.3 DAILY_16_TOTAL Column

Column	Type	Req	Key	Description	Comments
T	timestamp_ntz(9)	true
V	variant	true
city	jsonObject	true
coord	jsonObject	true
lat	jsonNumber	true
lon	jsonNumber	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true
data	jsonArray	true
[0]	jsonObject	false
clouds	jsonNumber	true
deg	jsonNumber	true
dt	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
rain	jsonNumber	false
snow	jsonNumber	false
speed	jsonNumber	true
temp	jsonObject	true
day	jsonNumber	true
eve	jsonNumber	true
max	jsonNumber	true
min	jsonNumber	true
morn	jsonNumber	true
night	jsonNumber	true
uvi	jsonNumber	true
weather	jsonArray	true
[0]	jsonObject	false
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true
time	jsonNumber	true

2.1.2.2.3.1 Column V

2.1.2.2.3.1.1 V Tree Diagram

{...}

city

[...]

data

{123}

time

2.1.2.2.3.1.2 V Hierarchy

Parent Column: DAILY_16_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
city	jsonObject	true
data	jsonArray	true
time	jsonNumber	true

2.1.2.2.3.1.3 V properties

Property	Value
Business Name	V
Type	variant
Variant type	JSON
Not null	true
Additional properties	false

2.1.2.2.3.2 Column city

2.1.2.2.3.2.1 city Tree Diagram

{...}

city

{...}

coord

{ABC}

country

{123}

{ABC}

name

2.1.2.2.3.2.2 city Hierarchy

Parent Column: DAILY_16_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
coord	jsonObject	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true

2.1.2.2.3.2.3 city properties

Property	Value
Business Name	city
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.2.3.3 Column coord

2.1.2.2.3.3.1 coord Tree Diagram

{...}

coord

{123}

lat

{123}

lon

2.1.2.2.3.3.2 coord Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
lat	jsonNumber	true
lon	jsonNumber	true

2.1.2.2.3.3.3 coord properties

Property	Value
Business Name	coord
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.2.3.4 Column lat

2.1.2.2.3.4.1 lat properties

Property	Value
Business Name	lat
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	47.24678

2.1.2.2.3.5 Column lon

2.1.2.2.3.5.1 lon properties

Property	Value
Business Name	lon
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	39.51088

2.1.2.2.3.6 Column country

2.1.2.2.3.6.1 country properties

Property	Value
Business Name	country
Type	jsonString
Required	true
Sample	RU

2.1.2.2.3.7 Column id

2.1.2.2.3.7.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	554269

2.1.2.2.3.8 Column name

2.1.2.2.3.8.1 name properties

Property	Value
Business Name	name
Type	jsonString
Required	true
Sample	Kalinin

2.1.2.2.3.9 Column data

2.1.2.2.3.9.1 data Tree Diagram

[...]

data

{...}

[0]*

2.1.2.2.3.9.2 data Hierarchy

Parent Column: city

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.2.3.9.3 data properties

Property	Value
Business Name	data
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.2.3.10 Column data

2.1.2.2.3.10.1 data Tree Diagram

{...}

data

{123}

clouds

{123}

deg

{123}

humidity

{123}

pressure

{123}

rain

{123}

snow

{123}

speed

{...}

temp

{123}

uvi

[...]

weather

2.1.2.2.3.10.2 data Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
clouds	jsonNumber	true
deg	jsonNumber	true
dt	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
rain	jsonNumber	false
snow	jsonNumber	false
speed	jsonNumber	true
temp	jsonObject	true
uvi	jsonNumber	true
weather	jsonArray	true

2.1.2.2.3.10.3 data properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.2.3.11 Column clouds

2.1.2.2.3.11.1 clouds properties

Property	Value
Business Name	clouds
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	76

2.1.2.2.3.12 Column deg

2.1.2.2.3.12.1 deg properties

Property	Value
Business Name	deg
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	59

2.1.2.2.3.13 Column dt

2.1.2.2.3.13.1 dt properties

Property	Value
Business Name	dt
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1519812000

2.1.2.2.3.14 Column humidity

2.1.2.2.3.14.1 humidity properties

Property	Value
Business Name	humidity
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	0

2.1.2.2.3.15 Column pressure

2.1.2.2.3.15.1 pressure properties

Property	Value
Business Name	pressure
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1013.6

2.1.2.2.3.16 Column rain

2.1.2.2.3.16.1 rain properties

Property	Value
Business Name	rain
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	0.33

2.1.2.2.3.17 Column snow

2.1.2.2.3.17.1 snow properties

Property	Value
Business Name	snow
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	0.05

2.1.2.2.3.18 Column speed

2.1.2.2.3.18.1 speed properties

Property	Value
Business Name	speed
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	5.19

2.1.2.2.3.19 Column temp

2.1.2.2.3.19.1 temp Tree Diagram

{...}

temp

{123}

day

{123}

eve

{123}

max

{123}

min

{123}

morn

{123}

night

2.1.2.2.3.19.2 temp Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
day	jsonNumber	true
eve	jsonNumber	true
max	jsonNumber	true
min	jsonNumber	true
morn	jsonNumber	true
night	jsonNumber	true

2.1.2.2.3.19.3 temp properties

Property	Value
Business Name	temp
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.2.3.20 Column day

2.1.2.2.3.20.1 day properties

Property	Value
Business Name	day
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	265.55

2.1.2.2.3.21 Column eve

2.1.2.2.3.21.1 eve properties

Property	Value
Business Name	eve
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	265.55

2.1.2.2.3.22 Column max

2.1.2.2.3.22.1 max properties

Property	Value
Business Name	max
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	265.55

2.1.2.2.3.23 Column min

2.1.2.2.3.23.1 min properties

Property	Value
Business Name	min
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	265.55

2.1.2.2.3.24 Column morn

2.1.2.2.3.24.1 morn properties

Property	Value
Business Name	morn
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	265.55

2.1.2.2.3.25 Column night

2.1.2.2.3.25.1 night properties

Property	Value
Business Name	night
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	265.55

2.1.2.2.3.26 Column uvi

2.1.2.2.3.26.1 uvi properties

Property	Value
Business Name	uvi
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1.089

2.1.2.2.3.27 Column weather

2.1.2.2.3.27.1 weather Tree Diagram

[...]

weather

{...}

[0]*

2.1.2.2.3.27.2 weather Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.2.3.27.3 weather properties

Property	Value
Business Name	weather
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.2.3.28 Column weather

2.1.2.2.3.28.1 weather Tree Diagram

{...}

weather

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.2.3.28.2 weather Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true

2.1.2.2.3.28.3 weather properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.2.3.29 Column description

2.1.2.2.3.29.1 description properties

Property	Value
Business Name	description
Type	jsonString
Required	true
Sample	light snow

2.1.2.2.3.30 Column icon

2.1.2.2.3.30.1 icon properties

Property	Value
Business Name	icon
Type	jsonString
Required	true
Sample	13d

2.1.2.2.3.31 Column id

2.1.2.2.3.31.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	600

2.1.2.2.3.32 Column main

2.1.2.2.3.32.1 main properties

Property	Value
Business Name	main
Type	jsonString
Required	true
Sample	Snow

2.1.2.2.3.33 Column time

2.1.2.2.3.33.1 time properties

Property	Value
Business Name	time
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1518500097

2.1.2.2.3.34 Column T

2.1.2.2.3.34.1 T properties

Property	Value
Business Name	T
Type	timestamp_ntz
Precision	9
Primary key	true
Not null	true
Sample	2018-02-12 21:34:57.000

2.1.2.2.4 DAILY_16_TOTAL Snowflake DDL script

CREATE OR REPLACE DATABASE "SNOWFLAKE_SAMPLE_DATA"; USE DATABASE "SNOWFLAKE_SAMPLE_DATA"; CREATE OR REPLACE SCHEMA "WEATHER"	WITH MANAGED ACCESS	DATA_RETENTION_TIME_IN_DAYS=1	COMMENT='From example described at https://docs.snowflake.com/en/user-guide/sample-data-openweathermap.html'; USE SCHEMA "WEATHER"; CREATE OR REPLACE TABLE	"DAILY_16_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1;

2.1.2.3 Table HOURLY_14_TOTAL

2.1.2.3.1 HOURLY_14_TOTAL Tree Diagram

{...}

HOURLY_14_TOTAL

{ts-ntz}

{...}

city

[...]

data

{123}

time

{...}

coord

{ABC}

country

{123}

{ABC}

name

{...}

[0]*

{123}

lat

{123}

lon

{...}

clouds

{123}

{ABC}

dt_txt

{...}

main

{...}

rain

{...}

snow

{...}

sys

[...]

weather

{...}

wind

{123}

all

{123}

grnd_level

{123}

humidity

{123}

pressure

{123}

sea_level

{123}

temp

{123}

temp_kf

{123}

temp_max

{123}

temp_min

{123}

{ABC}

pod

{...}

[0]*

{123}

deg

{123}

speed

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.3.2 HOURLY_14_TOTAL Properties

Property	Value
Table	HOURLY_14_TOTAL
Technical name
Id
Schema	WEATHER
Additional properties	false
Comments
Temporary
Transient	false
External	false
Primary key
Cluster by
[1] Expression
Key
Stage file format	CSV
Format type options	[object Object]
Stage copy options
Data retention in days	1
Like
Clone
Copy grants
Remarks

2.1.2.3.3 HOURLY_14_TOTAL Column

Column	Type	Req	Key	Description	Comments
T	timestamp_ntz(9)	true
V	variant	true
city	jsonObject	true
coord	jsonObject	true
lat	jsonNumber	true
lon	jsonNumber	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true
data	jsonArray	true
[0]	jsonObject	false
clouds	jsonObject	true
all	jsonNumber	true
dt	jsonNumber	true
dt_txt	jsonString	true
main	jsonObject	true
grnd_level	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
sea_level	jsonNumber	true
temp	jsonNumber	true
temp_kf	jsonNumber	false
temp_max	jsonNumber	true
temp_min	jsonNumber	true
rain	jsonObject	false
3h	jsonNumber	true
snow	jsonObject	false
3h	jsonNumber	true
sys	jsonObject	true
pod	jsonString	true
weather	jsonArray	true
[0]	jsonObject	false
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true
wind	jsonObject	true
deg	jsonNumber	true
speed	jsonNumber	true
time	jsonNumber	true

2.1.2.3.3.1 Column V

2.1.2.3.3.1.1 V Tree Diagram

{...}

city

[...]

data

{123}

time

2.1.2.3.3.1.2 V Hierarchy

Parent Column: HOURLY_14_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
city	jsonObject	true
data	jsonArray	true
time	jsonNumber	true

2.1.2.3.3.1.3 V properties

Property	Value
Business Name	V
Type	variant
Variant type	JSON
Not null	true
Additional properties	false

2.1.2.3.3.2 Column city

2.1.2.3.3.2.1 city Tree Diagram

{...}

city

{...}

coord

{ABC}

country

{123}

{ABC}

name

2.1.2.3.3.2.2 city Hierarchy

Parent Column: HOURLY_14_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
coord	jsonObject	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true

2.1.2.3.3.2.3 city properties

Property	Value
Business Name	city
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.3.3.3 Column coord

2.1.2.3.3.3.1 coord Tree Diagram

{...}

coord

{123}

lat

{123}

lon

2.1.2.3.3.3.2 coord Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
lat	jsonNumber	true
lon	jsonNumber	true

2.1.2.3.3.3.3 coord properties

Property	Value
Business Name	coord
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.3.3.4 Column lat

2.1.2.3.3.4.1 lat properties

Property	Value
Business Name	lat
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	16.94516

2.1.2.3.3.5 Column lon

2.1.2.3.3.5.1 lon properties

Property	Value
Business Name	lon
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	82.238503

2.1.2.3.3.6 Column country

2.1.2.3.3.6.1 country properties

Property	Value
Business Name	country
Type	jsonString
Required	true
Sample	IN

2.1.2.3.3.7 Column id

2.1.2.3.3.7.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	7302846

2.1.2.3.3.8 Column name

2.1.2.3.3.8.1 name properties

Property	Value
Business Name	name
Type	jsonString
Required	true
Sample	Ramanayyapeta

2.1.2.3.3.9 Column data

2.1.2.3.3.9.1 data Tree Diagram

[...]

data

{...}

[0]*

2.1.2.3.3.9.2 data Hierarchy

Parent Column: city

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.3.3.9.3 data properties

Property	Value
Business Name	data
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.3.3.10 Column data

2.1.2.3.3.10.1 data Tree Diagram

{...}

data

{...}

clouds

{123}

{ABC}

dt_txt

{...}

main

{...}

rain

{...}

snow

{...}

sys

[...]

weather

{...}

wind

2.1.2.3.3.10.2 data Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
clouds	jsonObject	true
dt	jsonNumber	true
dt_txt	jsonString	true
main	jsonObject	true
rain	jsonObject	false
snow	jsonObject	false
sys	jsonObject	true
weather	jsonArray	true
wind	jsonObject	true

2.1.2.3.3.10.3 data properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.3.3.11 Column clouds

2.1.2.3.3.11.1 clouds Tree Diagram

{...}

clouds

{123}

all

2.1.2.3.3.11.2 clouds Hierarchy

Parent Column: data

Child column(s):

Column	Type	Req	Key	Description	Comments
all	jsonNumber	true

2.1.2.3.3.11.3 clouds properties

Property	Value
Business Name	clouds
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.3.3.12 Column all

2.1.2.3.3.12.1 all properties

Property	Value
Business Name	all
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	0

2.1.2.3.3.13 Column dt

2.1.2.3.3.13.1 dt properties

Property	Value
Business Name	dt
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1518901200

2.1.2.3.3.14 Column dt_txt

2.1.2.3.3.14.1 dt_txt properties

Property	Value
Business Name	dt_txt
Type	jsonString
Required	true
Sample	2018-02-17 21:00:00

2.1.2.3.3.15 Column main

2.1.2.3.3.15.1 main Tree Diagram

{...}

main

{123}

grnd_level

{123}

humidity

{123}

pressure

{123}

sea_level

{123}

temp

{123}

temp_kf

{123}

temp_max

{123}

temp_min

2.1.2.3.3.15.2 main Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
grnd_level	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
sea_level	jsonNumber	true
temp	jsonNumber	true
temp_kf	jsonNumber	false
temp_max	jsonNumber	true
temp_min	jsonNumber	true

2.1.2.3.3.15.3 main properties

Property	Value
Business Name	main
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.3.3.16 Column grnd_level

2.1.2.3.3.16.1 grnd_level properties

Property	Value
Business Name	grnd_level
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1023.81

2.1.2.3.3.17 Column humidity

2.1.2.3.3.17.1 humidity properties

Property	Value
Business Name	humidity
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	100

2.1.2.3.3.18 Column pressure

2.1.2.3.3.18.1 pressure properties

Property	Value
Business Name	pressure
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1023.81

2.1.2.3.3.19 Column sea_level

2.1.2.3.3.19.1 sea_level properties

Property	Value
Business Name	sea_level
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1023.92

2.1.2.3.3.20 Column temp

2.1.2.3.3.20.1 temp properties

Property	Value
Business Name	temp
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	297.012

2.1.2.3.3.21 Column temp_kf

2.1.2.3.3.21.1 temp_kf properties

Property	Value
Business Name	temp_kf
Type	jsonNumber
Required	false
Excl min	false
Excl max	false

2.1.2.3.3.22 Column temp_max

2.1.2.3.3.22.1 temp_max properties

Property	Value
Business Name	temp_max
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	297.012

2.1.2.3.3.23 Column temp_min

2.1.2.3.3.23.1 temp_min properties

Property	Value
Business Name	temp_min
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	297.012

2.1.2.3.3.24 Column rain

2.1.2.3.3.24.1 rain Tree Diagram

{...}

rain

{123}

2.1.2.3.3.24.2 rain Hierarchy

Parent Column: main

Child column(s):

Column	Type	Req	Key	Description	Comments
3h	jsonNumber	true

2.1.2.3.3.24.3 rain properties

Property	Value
Business Name	rain
Type	jsonObject
JSON Type	variant
Required	false
Additional properties	false

2.1.2.3.3.25 Column 3h

2.1.2.3.3.25.1 3h properties

Property	Value
Business Name	3h
Type	jsonNumber
Required	true
Excl min	false
Excl max	false

2.1.2.3.3.26 Column snow

2.1.2.3.3.26.1 snow Tree Diagram

{...}

snow

{123}

2.1.2.3.3.26.2 snow Hierarchy

Parent Column: rain

Child column(s):

Column	Type	Req	Key	Description	Comments
3h	jsonNumber	true

2.1.2.3.3.26.3 snow properties

Property	Value
Business Name	snow
Type	jsonObject
JSON Type	variant
Required	false
Additional properties	false

2.1.2.3.3.27 Column 3h

2.1.2.3.3.27.1 3h properties

Property	Value
Business Name	3h
Type	jsonNumber
Required	true
Excl min	false
Excl max	false

2.1.2.3.3.28 Column sys

2.1.2.3.3.28.1 sys Tree Diagram

{...}

sys

{ABC}

pod

2.1.2.3.3.28.2 sys Hierarchy

Parent Column: snow

Child column(s):

Column	Type	Req	Key	Description	Comments
pod	jsonString	true

2.1.2.3.3.28.3 sys properties

Property	Value
Business Name	sys
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.3.3.29 Column pod

2.1.2.3.3.29.1 pod properties

Property	Value
Business Name	pod
Type	jsonString
Required	true
Sample	n

2.1.2.3.3.30 Column weather

2.1.2.3.3.30.1 weather Tree Diagram

[...]

weather

{...}

[0]*

2.1.2.3.3.30.2 weather Hierarchy

Parent Column: sys

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.3.3.30.3 weather properties

Property	Value
Business Name	weather
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.3.3.31 Column weather

2.1.2.3.3.31.1 weather Tree Diagram

{...}

weather

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.3.3.31.2 weather Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true

2.1.2.3.3.31.3 weather properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.3.3.32 Column description

2.1.2.3.3.32.1 description properties

Property	Value
Business Name	description
Type	jsonString
Required	true
Sample	sky is clear

2.1.2.3.3.33 Column icon

2.1.2.3.3.33.1 icon properties

Property	Value
Business Name	icon
Type	jsonString
Required	true
Sample	01n

2.1.2.3.3.34 Column id

2.1.2.3.3.34.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	800

2.1.2.3.3.35 Column main

2.1.2.3.3.35.1 main properties

Property	Value
Business Name	main
Type	jsonString
Required	true
Sample	Clear

2.1.2.3.3.36 Column wind

2.1.2.3.3.36.1 wind Tree Diagram

{...}

wind

{123}

deg

{123}

speed

2.1.2.3.3.36.2 wind Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
deg	jsonNumber	true
speed	jsonNumber	true

2.1.2.3.3.36.3 wind properties

Property	Value
Business Name	wind
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.3.3.37 Column deg

2.1.2.3.3.37.1 deg properties

Property	Value
Business Name	deg
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	189.501

2.1.2.3.3.38 Column speed

2.1.2.3.3.38.1 speed properties

Property	Value
Business Name	speed
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	2

2.1.2.3.3.39 Column time

2.1.2.3.3.39.1 time properties

Property	Value
Business Name	time
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1518476660

2.1.2.3.3.40 Column T

2.1.2.3.3.40.1 T properties

Property	Value
Business Name	T
Type	timestamp_ntz
Precision	9
Primary key	true
Not null	true
Sample	2018-02-12 15:04:20.000

2.1.2.3.4 HOURLY_14_TOTAL Snowflake DDL script

CREATE OR REPLACE DATABASE "SNOWFLAKE_SAMPLE_DATA"; USE DATABASE "SNOWFLAKE_SAMPLE_DATA"; CREATE OR REPLACE SCHEMA "WEATHER"	WITH MANAGED ACCESS	DATA_RETENTION_TIME_IN_DAYS=1	COMMENT='From example described at https://docs.snowflake.com/en/user-guide/sample-data-openweathermap.html'; USE SCHEMA "WEATHER"; CREATE OR REPLACE TABLE	"HOURLY_14_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1;

2.1.2.4 Table HOURLY_16_TOTAL

2.1.2.4.1 HOURLY_16_TOTAL Tree Diagram

{...}

HOURLY_16_TOTAL

{ts-ntz}

{...}

city

[...]

data

{123}

time

{...}

coord

{ABC}

country

{123}

{ABC}

name

{...}

[0]*

{123}

lat

{123}

lon

{...}

clouds

{123}

{ABC}

dt_txt

{...}

main

{...}

rain

{...}

snow

{...}

sys

[...]

weather

{...}

wind

{123}

all

{123}

grnd_level

{123}

humidity

{123}

pressure

{123}

sea_level

{123}

temp

{123}

temp_kf

{123}

temp_max

{123}

temp_min

{123}

{ABC}

pod

{...}

[0]*

{123}

deg

{123}

speed

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.4.2 HOURLY_16_TOTAL Properties

Property	Value
Table	HOURLY_16_TOTAL
Technical name
Id
Schema	WEATHER
Additional properties	false
Comments
Temporary
Transient	false
External	false
Primary key
Cluster by
[1] Expression
Key
Stage file format	CSV
Format type options	[object Object]
Stage copy options
Data retention in days	1
Like
Clone
Copy grants
Remarks

2.1.2.4.3 HOURLY_16_TOTAL Column

Column	Type	Req	Key	Description	Comments
T	timestamp_ntz(9)	true
V	variant	true
city	jsonObject	true
coord	jsonObject	true
lat	jsonNumber	true
lon	jsonNumber	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true
data	jsonArray	true
[0]	jsonObject	false
clouds	jsonObject	true
all	jsonNumber	true
dt	jsonNumber	true
dt_txt	jsonString	true
main	jsonObject	true
grnd_level	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
sea_level	jsonNumber	true
temp	jsonNumber	true
temp_kf	jsonNumber	false
temp_max	jsonNumber	true
temp_min	jsonNumber	true
rain	jsonObject	false
3h	jsonNumber	true
snow	jsonObject	false
3h	jsonNumber	true
sys	jsonObject	true
pod	jsonString	true
weather	jsonArray	true
[0]	jsonObject	false
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true
wind	jsonObject	true
deg	jsonNumber	true
speed	jsonNumber	true
time	jsonNumber	true

2.1.2.4.3.1 Column V

2.1.2.4.3.1.1 V Tree Diagram

{...}

city

[...]

data

{123}

time

2.1.2.4.3.1.2 V Hierarchy

Parent Column: HOURLY_16_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
city	jsonObject	true
data	jsonArray	true
time	jsonNumber	true

2.1.2.4.3.1.3 V properties

Property	Value
Business Name	V
Type	variant
Variant type	JSON
Not null	true
Additional properties	false

2.1.2.4.3.2 Column city

2.1.2.4.3.2.1 city Tree Diagram

{...}

city

{...}

coord

{ABC}

country

{123}

{ABC}

name

2.1.2.4.3.2.2 city Hierarchy

Parent Column: HOURLY_16_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
coord	jsonObject	true
country	jsonString	true
id	jsonNumber	true
name	jsonString	true

2.1.2.4.3.2.3 city properties

Property	Value
Business Name	city
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.4.3.3 Column coord

2.1.2.4.3.3.1 coord Tree Diagram

{...}

coord

{123}

lat

{123}

lon

2.1.2.4.3.3.2 coord Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
lat	jsonNumber	true
lon	jsonNumber	true

2.1.2.4.3.3.3 coord properties

Property	Value
Business Name	coord
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.4.3.4 Column lat

2.1.2.4.3.4.1 lat properties

Property	Value
Business Name	lat
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	13.46667

2.1.2.4.3.5 Column lon

2.1.2.4.3.5.1 lon properties

Property	Value
Business Name	lon
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	79.116669

2.1.2.4.3.6 Column country

2.1.2.4.3.6.1 country properties

Property	Value
Business Name	country
Type	jsonString
Required	true
Sample	IN

2.1.2.4.3.7 Column id

2.1.2.4.3.7.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1260830

2.1.2.4.3.8 Column name

2.1.2.4.3.8.1 name properties

Property	Value
Business Name	name
Type	jsonString
Required	true
Sample	Pakala

2.1.2.4.3.9 Column data

2.1.2.4.3.9.1 data Tree Diagram

[...]

data

{...}

[0]*

2.1.2.4.3.9.2 data Hierarchy

Parent Column: city

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.4.3.9.3 data properties

Property	Value
Business Name	data
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.4.3.10 Column data

2.1.2.4.3.10.1 data Tree Diagram

{...}

data

{...}

clouds

{123}

{ABC}

dt_txt

{...}

main

{...}

rain

{...}

snow

{...}

sys

[...]

weather

{...}

wind

2.1.2.4.3.10.2 data Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
clouds	jsonObject	true
dt	jsonNumber	true
dt_txt	jsonString	true
main	jsonObject	true
rain	jsonObject	false
snow	jsonObject	false
sys	jsonObject	true
weather	jsonArray	true
wind	jsonObject	true

2.1.2.4.3.10.3 data properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.4.3.11 Column clouds

2.1.2.4.3.11.1 clouds Tree Diagram

{...}

clouds

{123}

all

2.1.2.4.3.11.2 clouds Hierarchy

Parent Column: data

Child column(s):

Column	Type	Req	Key	Description	Comments
all	jsonNumber	true

2.1.2.4.3.11.3 clouds properties

Property	Value
Business Name	clouds
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.4.3.12 Column all

2.1.2.4.3.12.1 all properties

Property	Value
Business Name	all
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	8

2.1.2.4.3.13 Column dt

2.1.2.4.3.13.1 dt properties

Property	Value
Business Name	dt
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1518901200

2.1.2.4.3.14 Column dt_txt

2.1.2.4.3.14.1 dt_txt properties

Property	Value
Business Name	dt_txt
Type	jsonString
Required	true
Sample	2018-02-17 21:00:00

2.1.2.4.3.15 Column main

2.1.2.4.3.15.1 main Tree Diagram

{...}

main

{123}

grnd_level

{123}

humidity

{123}

pressure

{123}

sea_level

{123}

temp

{123}

temp_kf

{123}

temp_max

{123}

temp_min

2.1.2.4.3.15.2 main Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
grnd_level	jsonNumber	true
humidity	jsonNumber	true
pressure	jsonNumber	true
sea_level	jsonNumber	true
temp	jsonNumber	true
temp_kf	jsonNumber	false
temp_max	jsonNumber	true
temp_min	jsonNumber	true

2.1.2.4.3.15.3 main properties

Property	Value
Business Name	main
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.4.3.16 Column grnd_level

2.1.2.4.3.16.1 grnd_level properties

Property	Value
Business Name	grnd_level
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1006.21

2.1.2.4.3.17 Column humidity

2.1.2.4.3.17.1 humidity properties

Property	Value
Business Name	humidity
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	80

2.1.2.4.3.18 Column pressure

2.1.2.4.3.18.1 pressure properties

Property	Value
Business Name	pressure
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1006.21

2.1.2.4.3.19 Column sea_level

2.1.2.4.3.19.1 sea_level properties

Property	Value
Business Name	sea_level
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1027.49

2.1.2.4.3.20 Column temp

2.1.2.4.3.20.1 temp properties

Property	Value
Business Name	temp
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	279.637

2.1.2.4.3.21 Column temp_kf

2.1.2.4.3.21.1 temp_kf properties

Property	Value
Business Name	temp_kf
Type	jsonNumber
Required	false
Excl min	false
Excl max	false

2.1.2.4.3.22 Column temp_max

2.1.2.4.3.22.1 temp_max properties

Property	Value
Business Name	temp_max
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	279.637

2.1.2.4.3.23 Column temp_min

2.1.2.4.3.23.1 temp_min properties

Property	Value
Business Name	temp_min
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	279.637

2.1.2.4.3.24 Column rain

2.1.2.4.3.24.1 rain Tree Diagram

{...}

rain

{123}

2.1.2.4.3.24.2 rain Hierarchy

Parent Column: main

Child column(s):

Column	Type	Req	Key	Description	Comments
3h	jsonNumber	true

2.1.2.4.3.24.3 rain properties

Property	Value
Business Name	rain
Type	jsonObject
JSON Type	variant
Required	false
Additional properties	false

2.1.2.4.3.25 Column 3h

2.1.2.4.3.25.1 3h properties

Property	Value
Business Name	3h
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	0

2.1.2.4.3.26 Column snow

2.1.2.4.3.26.1 snow Tree Diagram

{...}

snow

{123}

2.1.2.4.3.26.2 snow Hierarchy

Parent Column: rain

Child column(s):

Column	Type	Req	Key	Description	Comments
3h	jsonNumber	true

2.1.2.4.3.26.3 snow properties

Property	Value
Business Name	snow
Type	jsonObject
JSON Type	variant
Required	false
Additional properties	false

2.1.2.4.3.27 Column 3h

2.1.2.4.3.27.1 3h properties

Property	Value
Business Name	3h
Type	jsonNumber
Required	true
Excl min	false
Excl max	false

2.1.2.4.3.28 Column sys

2.1.2.4.3.28.1 sys Tree Diagram

{...}

sys

{ABC}

pod

2.1.2.4.3.28.2 sys Hierarchy

Parent Column: snow

Child column(s):

Column	Type	Req	Key	Description	Comments
pod	jsonString	true

2.1.2.4.3.28.3 sys properties

Property	Value
Business Name	sys
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.4.3.29 Column pod

2.1.2.4.3.29.1 pod properties

Property	Value
Business Name	pod
Type	jsonString
Required	true
Sample	n

2.1.2.4.3.30 Column weather

2.1.2.4.3.30.1 weather Tree Diagram

[...]

weather

{...}

[0]*

2.1.2.4.3.30.2 weather Hierarchy

Parent Column: sys

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.4.3.30.3 weather properties

Property	Value
Business Name	weather
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.4.3.31 Column weather

2.1.2.4.3.31.1 weather Tree Diagram

{...}

weather

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.4.3.31.2 weather Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true

2.1.2.4.3.31.3 weather properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.4.3.32 Column description

2.1.2.4.3.32.1 description properties

Property	Value
Business Name	description
Type	jsonString
Required	true
Sample	sky is clear

2.1.2.4.3.33 Column icon

2.1.2.4.3.33.1 icon properties

Property	Value
Business Name	icon
Type	jsonString
Required	true
Sample	02n

2.1.2.4.3.34 Column id

2.1.2.4.3.34.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	800

2.1.2.4.3.35 Column main

2.1.2.4.3.35.1 main properties

Property	Value
Business Name	main
Type	jsonString
Required	true
Sample	Clear

2.1.2.4.3.36 Column wind

2.1.2.4.3.36.1 wind Tree Diagram

{...}

wind

{123}

deg

{123}

speed

2.1.2.4.3.36.2 wind Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
deg	jsonNumber	true
speed	jsonNumber	true

2.1.2.4.3.36.3 wind properties

Property	Value
Business Name	wind
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.4.3.37 Column deg

2.1.2.4.3.37.1 deg properties

Property	Value
Business Name	deg
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	230.001

2.1.2.4.3.38 Column speed

2.1.2.4.3.38.1 speed properties

Property	Value
Business Name	speed
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1.9

2.1.2.4.3.39 Column time

2.1.2.4.3.39.1 time properties

Property	Value
Business Name	time
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1518498070

2.1.2.4.3.40 Column T

2.1.2.4.3.40.1 T properties

Property	Value
Business Name	T
Type	timestamp_ntz
Precision	9
Primary key	true
Not null	true
Sample	2018-02-12 21:01:10.000

2.1.2.4.4 HOURLY_16_TOTAL Snowflake DDL script

CREATE OR REPLACE DATABASE "SNOWFLAKE_SAMPLE_DATA"; USE DATABASE "SNOWFLAKE_SAMPLE_DATA"; CREATE OR REPLACE SCHEMA "WEATHER"	WITH MANAGED ACCESS	DATA_RETENTION_TIME_IN_DAYS=1	COMMENT='From example described at https://docs.snowflake.com/en/user-guide/sample-data-openweathermap.html'; USE SCHEMA "WEATHER"; CREATE OR REPLACE TABLE	"HOURLY_16_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1;

2.1.2.5 Table WEATHER_14_TOTAL

2.1.2.5.1 WEATHER_14_TOTAL Tree Diagram

{...}

WEATHER_14_TOTAL

{ts-ntz}

{...}

city

{...}

clouds

{...}

main

{...}

rain

{123}

time

[...]

weather

{...}

wind

{...}

coord

{ABC}

country

{ABC}

findname

{123}

[...]

langs

{ABC}

name

{123}

zoom

{123}

all

{123}

grnd_level

{123}

humidity

{123}

pressure

{123}

sea_level

{123}

temp

{123}

temp_max

{123}

temp_min

{123}

{...}

[0]*

{123}

deg

{123}

gust

{123}

speed

{123}

var_beg

{123}

var_end

{123}

lat

{123}

lon

{...}

[0]*

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

{ABC}

abbr

{ABC}

ang

{ABC}

fil

{ABC}

frp

{ABC}

iata

{ABC}

jbo

{ABC}

link

{ABC}

nds

{ABC}

nrm

{ABC}

pdc

{ABC}

pms

{ABC}

post

{ABC}

scn

{ABC}

syl

{^$}

^[a-zA-Z0-9_.-]{2}$

2.1.2.5.2 WEATHER_14_TOTAL Properties

Property	Value
Table	WEATHER_14_TOTAL
Technical name
Id
Schema	WEATHER
Additional properties	false
Comments
Temporary
Transient	false
External	false
Primary key
Cluster by
[1] Expression
Key
Stage file format	CSV
Format type options	[object Object]
Stage copy options
Data retention in days	1
Like
Clone
Copy grants
Remarks

2.1.2.5.3 WEATHER_14_TOTAL Column

Column	Type	Req	Key	Description	Comments
T	timestamp_ntz(9)	true
V	variant	true
city	jsonObject	true
coord	jsonObject	true
lat	jsonNumber	true
lon	jsonNumber	true
country	jsonString	true
findname	jsonString	true
id	jsonNumber	true
langs	jsonArray	false
[0]	jsonObject	false
abbr	jsonString	false
ang	jsonString	false
fil	jsonString	false
frp	jsonString	false
iata	jsonString	false
jbo	jsonString	false
link	jsonString	false
nds	jsonString	false
nrm	jsonString	false
pdc	jsonString	false
pms	jsonString	false
post	jsonString	false
scn	jsonString	false
syl	jsonString	false
^[a-zA-Z0-9_.-]{2}$	jsonString	false
name	jsonString	true
zoom	jsonNumber	true
clouds	jsonObject	true
all	jsonNumber	true
main	jsonObject	true
grnd_level	jsonNumber	false
humidity	jsonNumber	true
pressure	jsonNumber	true
sea_level	jsonNumber	false
temp	jsonNumber	true
temp_max	jsonNumber	true
temp_min	jsonNumber	true
rain	jsonObject	false
3h	jsonNumber	true
time	jsonNumber	true
weather	jsonArray	true
[0]	jsonObject	false
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true
wind	jsonObject	true
deg	jsonNumber	true
gust	jsonNumber	false
speed	jsonNumber	true
var_beg	jsonNumber	false
var_end	jsonNumber	false

2.1.2.5.3.1 Column V

2.1.2.5.3.1.1 V Tree Diagram

{...}

city

{...}

clouds

{...}

main

{...}

rain

{123}

time

[...]

weather

{...}

wind

2.1.2.5.3.1.2 V Hierarchy

Parent Column: WEATHER_14_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
city	jsonObject	true
clouds	jsonObject	true
main	jsonObject	true
rain	jsonObject	false
time	jsonNumber	true
weather	jsonArray	true
wind	jsonObject	true

2.1.2.5.3.1.3 V properties

Property	Value
Business Name	V
Type	variant
Variant type	JSON
Not null	true
Additional properties	false

2.1.2.5.3.2 Column city

2.1.2.5.3.2.1 city Tree Diagram

{...}

city

{...}

coord

{ABC}

country

{ABC}

findname

{123}

[...]

langs

{ABC}

name

{123}

zoom

2.1.2.5.3.2.2 city Hierarchy

Parent Column: WEATHER_14_TOTAL

Child column(s):

Column	Type	Req	Key	Description	Comments
coord	jsonObject	true
country	jsonString	true
findname	jsonString	true
id	jsonNumber	true
langs	jsonArray	false
name	jsonString	true
zoom	jsonNumber	true

2.1.2.5.3.2.3 city properties

Property	Value
Business Name	city
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.5.3.3 Column coord

2.1.2.5.3.3.1 coord Tree Diagram

{...}

coord

{123}

lat

{123}

lon

2.1.2.5.3.3.2 coord Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
lat	jsonNumber	true
lon	jsonNumber	true

2.1.2.5.3.3.3 coord properties

Property	Value
Business Name	coord
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.5.3.4 Column lat

2.1.2.5.3.4.1 lat properties

Property	Value
Business Name	lat
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	-5.89583

2.1.2.5.3.5 Column lon

2.1.2.5.3.5.1 lon properties

Property	Value
Business Name	lon
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	22.41778

2.1.2.5.3.6 Column country

2.1.2.5.3.6.1 country properties

Property	Value
Business Name	country
Type	jsonString
Required	true
Sample	CD

2.1.2.5.3.7 Column findname

2.1.2.5.3.7.1 findname properties

Property	Value
Business Name	findname
Type	jsonString
Required	true
Sample	KANANGA

2.1.2.5.3.8 Column id

2.1.2.5.3.8.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	214481

2.1.2.5.3.9 Column langs

2.1.2.5.3.9.1 langs Tree Diagram

[...]

langs

{...}

[0]*

2.1.2.5.3.9.2 langs Hierarchy

Parent Column: city

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.5.3.9.3 langs properties

Property	Value
Business Name	langs
Type	jsonArray
JSON Type	variant
Required	false
Unique items	false
Additional items	true

2.1.2.5.3.10 Column langs

2.1.2.5.3.10.1 langs Tree Diagram

{...}

langs

{ABC}

abbr

{ABC}

ang

{ABC}

fil

{ABC}

frp

{ABC}

iata

{ABC}

jbo

{ABC}

link

{ABC}

nds

{ABC}

nrm

{ABC}

pdc

{ABC}

pms

{ABC}

post

{ABC}

scn

{ABC}

syl

{^$}

^[a-zA-Z0-9_.-]{2}$

2.1.2.5.3.10.2 langs Hierarchy

Parent Column: city

Child column(s):

Column	Type	Req	Key	Description	Comments
abbr	jsonString	false
ang	jsonString	false
fil	jsonString	false
frp	jsonString	false
iata	jsonString	false
jbo	jsonString	false
link	jsonString	false
nds	jsonString	false
nrm	jsonString	false
pdc	jsonString	false
pms	jsonString	false
post	jsonString	false
scn	jsonString	false
syl	jsonString	false
^[a-zA-Z0-9_.-]{2}$	jsonString	false

2.1.2.5.3.10.3 langs properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.5.3.11 Column abbr

2.1.2.5.3.11.1 abbr properties

Property	Value
Business Name	abbr
Type	jsonString
Required	false

2.1.2.5.3.12 Column ang

2.1.2.5.3.12.1 ang properties

Property	Value
Business Name	ang
Type	jsonString
Required	false

2.1.2.5.3.13 Column fil

2.1.2.5.3.13.1 fil properties

Property	Value
Business Name	fil
Type	jsonString
Required	false

2.1.2.5.3.14 Column frp

2.1.2.5.3.14.1 frp properties

Property	Value
Business Name	frp
Type	jsonString
Required	false

2.1.2.5.3.15 Column iata

2.1.2.5.3.15.1 iata properties

Property	Value
Business Name	iata
Type	jsonString
Required	false

2.1.2.5.3.16 Column jbo

2.1.2.5.3.16.1 jbo properties

Property	Value
Business Name	jbo
Type	jsonString
Required	false

2.1.2.5.3.17 Column link

2.1.2.5.3.17.1 link properties

Property	Value
Business Name	link
Type	jsonString
Required	false
Sample	http://en.wikipedia.org/wiki/Istanbul_Province

2.1.2.5.3.18 Column nds

2.1.2.5.3.18.1 nds properties

Property	Value
Business Name	nds
Type	jsonString
Required	false

2.1.2.5.3.19 Column nrm

2.1.2.5.3.19.1 nrm properties

Property	Value
Business Name	nrm
Type	jsonString
Required	false

2.1.2.5.3.20 Column pdc

2.1.2.5.3.20.1 pdc properties

Property	Value
Business Name	pdc
Type	jsonString
Required	false

2.1.2.5.3.21 Column pms

2.1.2.5.3.21.1 pms properties

Property	Value
Business Name	pms
Type	jsonString
Required	false

2.1.2.5.3.22 Column post

2.1.2.5.3.22.1 post properties

Property	Value
Business Name	post
Type	jsonString
Required	false

2.1.2.5.3.23 Column scn

2.1.2.5.3.23.1 scn properties

Property	Value
Business Name	scn
Type	jsonString
Required	false

2.1.2.5.3.24 Column syl

2.1.2.5.3.24.1 syl properties

Property	Value
Business Name	syl
Type	jsonString
Required	false

2.1.2.5.3.25 Column ^[a-zA-Z0-9_.-]{2}$

2.1.2.5.3.25.1 ^[a-zA-Z0-9_.-]{2}$ properties

Property	Value
Business Name	^[a-zA-Z0-9_.-]{2}$
Sample Name	zh
Type	jsonString

2.1.2.5.3.26 Column name

2.1.2.5.3.26.1 name properties

Property	Value
Business Name	name
Type	jsonString
Required	true
Sample	Kananga

2.1.2.5.3.27 Column zoom

2.1.2.5.3.27.1 zoom properties

Property	Value
Business Name	zoom
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	7

2.1.2.5.3.28 Column clouds

2.1.2.5.3.28.1 clouds Tree Diagram

{...}

clouds

{123}

all

2.1.2.5.3.28.2 clouds Hierarchy

Parent Column: city

Child column(s):

Column	Type	Req	Key	Description	Comments
all	jsonNumber	true

2.1.2.5.3.28.3 clouds properties

Property	Value
Business Name	clouds
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.5.3.29 Column all

2.1.2.5.3.29.1 all properties

Property	Value
Business Name	all
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	80

2.1.2.5.3.30 Column main

2.1.2.5.3.30.1 main Tree Diagram

{...}

main

{123}

grnd_level

{123}

humidity

{123}

pressure

{123}

sea_level

{123}

temp

{123}

temp_max

{123}

temp_min

2.1.2.5.3.30.2 main Hierarchy

Parent Column: clouds

Child column(s):

Column	Type	Req	Key	Description	Comments
grnd_level	jsonNumber	false
humidity	jsonNumber	true
pressure	jsonNumber	true
sea_level	jsonNumber	false
temp	jsonNumber	true
temp_max	jsonNumber	true
temp_min	jsonNumber	true

2.1.2.5.3.30.3 main properties

Property	Value
Business Name	main
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.5.3.31 Column grnd_level

2.1.2.5.3.31.1 grnd_level properties

Property	Value
Business Name	grnd_level
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	952.29

2.1.2.5.3.32 Column humidity

2.1.2.5.3.32.1 humidity properties

Property	Value
Business Name	humidity
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	94

2.1.2.5.3.33 Column pressure

2.1.2.5.3.33.1 pressure properties

Property	Value
Business Name	pressure
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	952.29

2.1.2.5.3.34 Column sea_level

2.1.2.5.3.34.1 sea_level properties

Property	Value
Business Name	sea_level
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	1022.32

2.1.2.5.3.35 Column temp

2.1.2.5.3.35.1 temp properties

Property	Value
Business Name	temp
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	294.914

2.1.2.5.3.36 Column temp_max

2.1.2.5.3.36.1 temp_max properties

Property	Value
Business Name	temp_max
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	294.914

2.1.2.5.3.37 Column temp_min

2.1.2.5.3.37.1 temp_min properties

Property	Value
Business Name	temp_min
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	294.914

2.1.2.5.3.38 Column rain

2.1.2.5.3.38.1 rain Tree Diagram

{...}

rain

{123}

2.1.2.5.3.38.2 rain Hierarchy

Parent Column: main

Child column(s):

Column	Type	Req	Key	Description	Comments
3h	jsonNumber	true

2.1.2.5.3.38.3 rain properties

Property	Value
Business Name	rain
Type	jsonObject
JSON Type	variant
Required	false
Additional properties	false

2.1.2.5.3.39 Column 3h

2.1.2.5.3.39.1 3h properties

Property	Value
Business Name	3h
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	0.825

2.1.2.5.3.40 Column time

2.1.2.5.3.40.1 time properties

Property	Value
Business Name	time
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1518490964

2.1.2.5.3.41 Column weather

2.1.2.5.3.41.1 weather Tree Diagram

[...]

weather

{...}

[0]*

2.1.2.5.3.41.2 weather Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
[0]	jsonObject	false

2.1.2.5.3.41.3 weather properties

Property	Value
Business Name	weather
Type	jsonArray
JSON Type	variant
Required	true
Unique items	false
Additional items	true

2.1.2.5.3.42 Column weather

2.1.2.5.3.42.1 weather Tree Diagram

{...}

weather

{ABC}

description

{ABC}

icon

{123}

{ABC}

main

2.1.2.5.3.42.2 weather Hierarchy

Parent Column: V

Child column(s):

Column	Type	Req	Key	Description	Comments
description	jsonString	true
icon	jsonString	true
id	jsonNumber	true
main	jsonString	true

2.1.2.5.3.42.3 weather properties

Property	Value
Type	jsonObject
JSON Type	variant
Additional properties	false

2.1.2.5.3.43 Column description

2.1.2.5.3.43.1 description properties

Property	Value
Business Name	description
Type	jsonString
Required	true
Sample	mist

2.1.2.5.3.44 Column icon

2.1.2.5.3.44.1 icon properties

Property	Value
Business Name	icon
Type	jsonString
Required	true
Sample	50d

2.1.2.5.3.45 Column id

2.1.2.5.3.45.1 id properties

Property	Value
Business Name	id
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	701

2.1.2.5.3.46 Column main

2.1.2.5.3.46.1 main properties

Property	Value
Business Name	main
Type	jsonString
Required	true
Sample	Mist

2.1.2.5.3.47 Column wind

2.1.2.5.3.47.1 wind Tree Diagram

{...}

wind

{123}

deg

{123}

gust

{123}

speed

{123}

var_beg

{123}

var_end

2.1.2.5.3.47.2 wind Hierarchy

Parent Column:

Child column(s):

Column	Type	Req	Key	Description	Comments
deg	jsonNumber	true
gust	jsonNumber	false
speed	jsonNumber	true
var_beg	jsonNumber	false
var_end	jsonNumber	false

2.1.2.5.3.47.3 wind properties

Property	Value
Business Name	wind
Type	jsonObject
JSON Type	variant
Required	true
Additional properties	false

2.1.2.5.3.48 Column deg

2.1.2.5.3.48.1 deg properties

Property	Value
Business Name	deg
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	133.002

2.1.2.5.3.49 Column gust

2.1.2.5.3.49.1 gust properties

Property	Value
Business Name	gust
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	9.8

2.1.2.5.3.50 Column speed

2.1.2.5.3.50.1 speed properties

Property	Value
Business Name	speed
Type	jsonNumber
Required	true
Excl min	false
Excl max	false
Sample	1.21

2.1.2.5.3.51 Column var_beg

2.1.2.5.3.51.1 var_beg properties

Property	Value
Business Name	var_beg
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	270

2.1.2.5.3.52 Column var_end

2.1.2.5.3.52.1 var_end properties

Property	Value
Business Name	var_end
Type	jsonNumber
Required	false
Excl min	false
Excl max	false
Sample	330

2.1.2.5.3.53 Column T

2.1.2.5.3.53.1 T properties

Property	Value
Business Name	T
Type	timestamp_ntz
Precision	9
Primary key	true
Not null	true
Sample	2018-02-12 19:02:44.000

2.1.2.5.4 WEATHER_14_TOTAL Snowflake DDL script

CREATE OR REPLACE DATABASE "SNOWFLAKE_SAMPLE_DATA"; USE DATABASE "SNOWFLAKE_SAMPLE_DATA"; CREATE OR REPLACE SCHEMA "WEATHER"	WITH MANAGED ACCESS	DATA_RETENTION_TIME_IN_DAYS=1	COMMENT='From example described at https://docs.snowflake.com/en/user-guide/sample-data-openweathermap.html'; USE SCHEMA "WEATHER"; CREATE OR REPLACE TABLE	"WEATHER_14_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1;

2.1.3 WEATHER Snowflake DDL script

CREATE OR REPLACE DATABASE "SNOWFLAKE_SAMPLE_DATA"; USE DATABASE "SNOWFLAKE_SAMPLE_DATA"; CREATE OR REPLACE SCHEMA "WEATHER"	WITH MANAGED ACCESS	DATA_RETENTION_TIME_IN_DAYS=1	COMMENT='From example described at https://docs.snowflake.com/en/user-guide/sample-data-openweathermap.html'; USE SCHEMA "WEATHER"; CREATE OR REPLACE TABLE	"DAILY_14_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1; CREATE OR REPLACE TABLE	"DAILY_16_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1; CREATE OR REPLACE TABLE	"HOURLY_14_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1; CREATE OR REPLACE TABLE	"HOURLY_16_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1; CREATE OR REPLACE TABLE	"WEATHER_14_TOTAL" (	"V" VARIANT NOT NULL,	"T" TIMESTAMP_NTZ(9) NOT NULL PRIMARY KEY	) STAGE_FILE_FORMAT = (	TYPE=CSV	COMPRESSION=AUTO	RECORD_DELIMITER='\\n'	FIELD_DELIMITER=','	FILE_EXTENSION=''	SKIP_HEADER=0	DATE_FORMAT=AUTO	TIME_FORMAT=AUTO	TIMESTAMP_FORMAT=AUTO	BINARY_FORMAT=HEX	ESCAPE=NONE	ESCAPE_UNENCLOSED_FIELD='\\'	TRIM_SPACE=FALSE	FIELD_OPTIONALLY_ENCLOSED_BY=NONE	NULL_IF=('\\N')	ERROR_ON_COLUMN_COUNT_MISMATCH=TRUE	VALIDATE_UTF8=TRUE	EMPTY_FIELD_AS_NULL=TRUE	SKIP_BYTE_ORDER_MARK=TRUE	ENCODING='UTF8' ) DATA_RETENTION_TIME_IN_DAYS=1;