Ways of Working with Snowflake

Snowflake Architecture

DataCamp

Technical Curriculum Developer, Snowflake

Three interfaces, three different jobs

Snowsight

¹ https://docs.snowflake.com/en/user-guide/ui-snowsight

Snowsight: Workspaces

¹ https://docs.snowflake.com/en/user-guide/ui-snowsight/workspaces

Snowsight: Context

 

 

• Wrong context is the number one reason queries fail
• Role and warehouse are preselected, ensure you set your database and schema yourself.

¹ https://docs.snowflake.com/en/sql-reference/sql/use

Snowsight: Query History

¹ https://docs.snowflake.com/en/user-guide/ui-query-history

Query History: Simplified Example

VS Code with the Snowflake extension

1. Install Snowflake Extension
2. Authenticate with Snowflake
3. Execute SQL directly in VS Code

VS Code Extension: Simplified Example

Snowflake CLI

¹ https://docs.snowflake.com/en/developer-guide/snowflake-cli/index

CLI: Simplified Example

Let's practice!

Snowflake Architecture