Week 7 Recap

-- Write this from memory, then run to verify:
CREATE OR REPLACE TABLE w7_recap_tbl (id INT, name STRING);
INSERT INTO w7_recap_tbl VALUES (1,'Alice'), (2,'Bob');

DROP TABLE w7_recap_tbl;
UNDROP TABLE w7_recap_tbl;          -- recovers within Time Travel

SELECT * FROM w7_recap_tbl;         -- both rows return

USE ROLE ACCOUNTADMIN;
CREATE OR REPLACE ROLE w7_reader_role;
GRANT SELECT ON TABLE w7_recap_tbl TO ROLE w7_reader_role;

CREATE TABLE w7_clone CLONE w7_recap_tbl;   -- zero-copy, instant

SHOW GRANTS ON TABLE w7_recap_tbl;   -- shows the SELECT grant
SHOW GRANTS ON TABLE w7_clone;       -- EMPTY: no grant carried over

USE ROLE ACCOUNTADMIN;
CREATE OR REPLACE DATABASE w7_share_db;
CREATE OR REPLACE SCHEMA w7_share_db.public;

CREATE OR REPLACE SHARE w7_lab_share;
GRANT USAGE ON DATABASE w7_share_db TO SHARE w7_lab_share;
GRANT USAGE ON SCHEMA w7_share_db.public TO SHARE w7_lab_share;

SHOW GRANTS TO SHARE w7_lab_share;   -- the database usage grant

Snowsight path:  Data Products > Marketplace

Listing types (name all three):
  1) Private     - offered to specific named consumer accounts
  2) Public      - discoverable by anyone on the Marketplace
  3) Personalized - consumer requests a tailored dataset from provider

Marketplace data is:  LIVE, READ-ONLY, queried in place (no copy)

DROP TABLE IF EXISTS w7_clone;
DROP TABLE IF EXISTS w7_recap_tbl;
DROP SHARE IF EXISTS w7_lab_share;
DROP DATABASE IF EXISTS w7_share_db;
DROP ROLE IF EXISTS w7_reader_role;