![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/11\/snowflake.png\")
<\/figure><\/div>\n\n\n\nWhat is Snowflake?
<\/h4>\n\n\n\n
Snowflake<\/a> is a new era relational SQL data warehouse built for the cloud that seeks to enable seamless and fully elastic access to business-critical data that satisfies everyone from Analysts to IT to Finance. tl;dr Quantity != Quality. <\/p>\n\n\n\n Snowflake offers decoupled<\/em> elastic compute and storage that is flexible enough to handle semi-structured data types such as JSON yet rigid enough to provide great performance (see benchmark<\/a>) and consistency for real-time reporting. A Database<\/strong> is a logical container storing references to schemas and tables Schemas<\/strong> are logical abstractions that contain tables<\/p>\n\n\n\n Tables<\/strong> contain metadata references to data types, columns and other details surrounding storage of actual data Views<\/strong> are abstractions of arbitrary SQL queries Sequences<\/a><\/strong> generate unique numbers across sessions and statements Stages<\/a><\/strong> are locations where files are stored for loading into tables<\/p>\n\n\n\n File Formats<\/strong> are used to manage loading data in from supported file formats <\/p>\n\n\n\n There are 4 default Roles:<\/strong> <\/p>\n\n\n\n Snowflake extends the typical SQL paradigm further than typically expected. With Snowflake, you can do basically anything and everything with SQL, from administrative tasks (e.g. user, database, and warehouse management) to traditional SQL query workloads (BI, analytics and engineering). Snowflake documentation already has a Snowflake in 20 minutes<\/a><\/em> guide to getting started, which uses the snowsql command line to handle the entire process. Below, my guide will be visual (with screenshots) to show you how to do similar functionality using the web interface. Loading a file on your local computer into Snowflake can be done in a number of ways, which can be reviewed here<\/a> Hit Run<\/p>\n\n\n\n Download a sample data file from the NYC Taxi and Limousine Commission (TLC) here: Green trip data<\/a><\/p>\n\n\n\n This is what the actual SQL would look like if you ran a version of these commands in SQL (such as in the snowsql command line client):<\/p>\n\n\n\n Congrats! <\/strong>You’ve now setup your snowflake environment, created a table, loaded data into it and began consuming it! <\/p>\n\n\n\n Disclaimer<\/strong> What is Snowflake? Snowflake is a new era relational SQL data warehouse built for the cloud that seeks to enable seamless and fully elastic access to business-critical data that satisfies everyone from Analysts to IT to Finance. But why – aren’t there enough Data Warehouses already?! tl;dr Quantity != Quality. Snowflake offers decoupled elastic compute… Continue reading
<\/p>\n\n\n\nBut why – aren’t there enough Data Warehouses already?!<\/h4>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/db_schema_table.png\")
<\/p>\n\n\n\n
Read more about Databases, Schemas, Tables and Views here<\/a>
<\/p>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-22-at-3.42.37-PM.png\")
![\"\"](\"http:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-23-at-10.59.30-AM.png\")
<\/p>\n\n\n\n
<\/li>
<\/li><\/ol>\n\n\n\nOk, I’m sold – how can I get started?
<\/h4>\n\n\n\n
<\/p>\n\n\n\n
<\/li><\/ul>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-23-at-12.23.11-PM.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-22-at-3.16.13-PM.png\")
![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-22-at-3.19.06-PM.png\")
<\/li><\/ul>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-22-at-3.22.28-PM.png\")
![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-22-at-4.14.44-PM.png\")
![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-23-at-11.40.32-AM.png\")
<\/li><\/ul>\n\n\n\n![\"\"](\"http:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-23-at-12.10.47-PM.png\")
We’re going to use the UI to load a file since this is a visual getting started guide.<\/p>\n\n\n\n
<\/li><\/ul>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.26.18-PM.png\")
CREATE OR REPLACE TABLE \"DEV\".\"PUBLIC\".\"GREEN_TRIPS\" (\n \"VENDORID\" NUMBER, \n \"LPEP_PICKUP_DATETIME\" TIMESTAMP, \n \"LPEP_DROPOFF_DATETIME\" TIMESTAMP, \n \"STORE_AND_FWD_FLAG\" STRING, \n \"RATECODEID\" NUMBER,\n \"PULocationID\" NUMBER,\n \"DOLocationID\" NUMBER,\n \"passenger_count\" NUMBER,\n \"trip_distance\" DOUBLE,\n \"fare_amount\" DOUBLE,\n \"extra\" DOUBLE,\n \"mta_tax\" DOUBLE,\n \"tip_amount\" DOUBLE,\n \"tolls_amount\" DOUBLE,\n \"ehail_fee\" STRING,\n \"improvement_surcharge\" DOUBLE,\n \"total_amount\" DOUBLE,\n \"payment_type\" NUMBER,\n \"trip_type\" NUMBER\n) COMMENT = 'NYC TLC Green Trip Data';<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.27.26-PM.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.27.58-PM.png\")
![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.29.40-PM.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.31.52-PM.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.30.19-PM.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.32.23-PM.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-12.32.42-PM.png\")
<\/figure>\n\n\n\nput file:\/\/\/Users\/garren\/Downloads\/green_tripdata_2017-06.csv @SFSTAGE; \/\/ This uses the SFSTAGE named internal stage\n\nCOPY INTO \"DEV\".\"PUBLIC\".\"GREEN_TRIPS\" FROM @SFSTAGE\/green_tripdata_2017-06.csv FILE_FORMAT = '\"DEV\".\"PUBLIC\".\"BASE_CSV\"' ON_ERROR = 'ABORT_STATEMENT' PURGE = TRUE;<\/code><\/pre>\n\n\n\nSELECT COUNT(*)\nFROM GREEN_TRIPS;<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/garrens.com\/blog\/wp-content\/uploads\/2018\/10\/Screen-Shot-2018-10-24-at-1.16.59-PM.png\")
<\/figure>\n\n\n\n
I have no affiliation with Snowflake and was not asked to write this guide – I’m just a fan of technology solving real problems with great potential
<\/p>\n","protected":false},"excerpt":{"rendered":"