Create Snowflake database and orders table

PHOTO EMBED

Tue Feb 28 2023 12:12:35 GMT+0000 (Coordinated Universal Time)

Saved by @Tilores

CREATE DATABASE EXAMPLE;

USE DATABASE EXAMPLE;

CREATE TABLE orders (
	"id" VARCHAR,
    "first_name" VARCHAR,
    "last_name" VARCHAR,
    "email" VARCHAR,
    "payment_default" BOOLEAN
);

INSERT INTO orders VALUES
('8e6189fa-8caf-4fd2-b648-07570a3e1a82', 'Jon', 'Smith', 'john.smith@example.com', false),
('a1aa064c-6065-43bd-a834-1a212b2dfb60', 'Robert', 'Smith', 'fraudster@example.com', true),
('8568ee21-e745-4db2-8f17-72e77396a591', 'John', 'Smith', 'john@example.com', false),
('b3c5108c-832e-479f-80d9-c2997ec93797', 'J. Marry', 'Doe', 'jane@example.com', false);
content_copyCOPY