Introduction to NoSQL
Jake Roach
Data Engineer
{
"ISBN_13": "978-1685549596",
"publisher": "Notion Press Media",
"size": {
"dimensions": "8.5 x 1.01 x 11 inches",
"weight": "2.53 pounds"
}
}
VARIANT
typeSnowflake also supports the OBJECT
and ARRAY
types
OBJECT
is similar to dictionaries in PythonARRAY
is similar to lists in Python$$
VARIANT
type
Query:
SELECT
library['ISBN_13']
FROM books;
Result:
Query:
SELECT
library:ISBN_13,
library:publisher
FROM books;
Result:
SELECT
library:ISBN_13,
library:size.dimensions,
library:size.weight,
FROM books;
SELECT
library["ISBN_13"],
library["size"]["dimensions"],
library["size"]["weight"],
FROM books;
Introduction to NoSQL