Snowflake

Sign up for free trial and log in to Snowflake.

Select Databases from top pain, and select create.

Name the database ‘Movies’.

Next let’s create a default warehouse for loading data.

Name the warehouse Movies.  Select size of X-Small. Click Finish.

 

To start working with snowflake click worksheet.

1. Schema browser.  Check out database, schema, and table details.
2. Tabs – contain the name of the worksheet.
3. + tab – will add a new tab.
4. Context – be sure to change this to the warehouse, database and schema you want to use.
5. Run button – executes the SQL you write.
6. View results.

Click drop down to right of context pane to update the database schema of the worksheet. In the example below we select movies warehouse, movies database, and public schema.

The top right you can switch roles.  Use AccountAdmin to see billing details and credits used.  SecurityAdmin is obviously to update security roles and policies.  Public is the default schema used with each database.