References

Virtual warehouses | Snowflake Documentation

Prerequisites

• Signing up for a Snowflake account instance. An account can be signed up by two way
• Fast, but less accurate way
1. Go to the main Snowflake page, and click on Pricing
2. Choose the version of Snowflake you need, usually Standard or Business Critical
• Slower, but more accurate way
• Go to the sales page to meet with sales and size your instance
• https://www.snowflake.com/en/contact-sales/

Base Object Setup

Once you have a Snowflake account, you can set up the database objects that will hold the Snowflake data. If you are not familiar with Snowflake or databases, it is suggested to work with your on-boarding contact to assist and/or create these. Objects include

• Database: The top level object for where the tables and views will be held
• Schema: A child of database, under which tables, views, and other objects can be put
• Tables: The object holding the data records
• View: An object that can be used over one or more tables to act as a table
• May or may not be needed depending whether multiple tables need to be joined
• Warehouse: A source of power to run queries in Snowflake. There can be more than one and can start from extra small size up. Larger warehouse are more powerful, but also more expensive. It is wise to add monitoring, as well as auto-suspension to them to reduce costs
• Roles: A holder for a set of permissions on various objects
• Users: A user with one or more roles to access Snowflake
• Functions: A set of logic used to perform and operation on a table column
• Optional, as needed