select * from snowflake.account_usage.access_history

create or replace database jalen;  -- 默认产生一个名字叫 public 的 schema

select current_database(), current_schema();

create or replace table jalen_table (

  first_name string ,

  last_name string ,

  email string ,

  streetaddress string ,

  city string ,

  start_date date

);

insert into jalen_table values

('Clementine','Adamou','cadamou@sf_tuts.com','10510 Sachs Road','Klenak','2017-9-22') ,

('Marlowe','De Anesy','madamouc@sf_tuts.co.uk','36768 Northfield Plaza','Fangshan','2017-1-26');

select * from jalen_table;

select email from jalen_table where email like '%.uk';

select first_name, last_name, dateadd('day',90,start_date) from jalen_table where start_date <= '2017-09-23';

create or replace warehouse jalen_warehouse with

warehouse_size='X-SMALL'

auto_suspend = 180

auto_resume = true

initially_suspended=true;

select current_warehouse();

drop database if exists jalen;

drop warehouse if exists jalen_warehouse;