The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

Compute resources

Query execution

Authentication

Data storage

Metadata

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

Cluster keys

Time Travel

Fail-safe

Cloning

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys create a distributed, parallel data structure of pointers to a table ' s rows and columns

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME

FROM ACCOUNT_USAGE.USERS;

SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;