In this episode of the Let It Snow series, Greg Trzeciak from Pragmatic Works walks through the simple steps of loading data into Snowflake and running queries to uncover insights. This session demonstrates how anyone can quickly set up a database, create a table, and query data directly from the Snowflake interface without writing complicated scripts. For the demonstration, Greg uses a sample dataset of failed banks in the United States, showing how Snowflake makes data ingestion both fast and efficient.
Getting Started
- Before beginning, users will need access to a Snowflake account. A free trial is sufficient for following along.
- The demonstration dataset is available for download and contains information about failed banks, including bank names, cities, states, closing dates, and acquiring institutions.
- Once logged in, users should navigate to the Data tab within the Snowflake interface.
Exploring the Add Data Options
Greg explains that the Add Data feature in Snowflake functions similarly to Power BI’s Get Data tool. It provides multiple connection options for importing data:
- Connections from cloud providers such as Google Cloud Platform and Microsoft Azure.
- Built-in connectors to applications like Salesforce, Google Sheets, and Mailchimp.
- Options to upload files directly or import from a URL.
- Access to Snowflake Marketplace connectors, which include both free and paid options.
While many connectors are available, Greg focuses on two primary methods: loading data directly into a table and loading data into a stage. Staging serves as a temporary or longer-term holding area for data before being moved into permanent tables.
Loading Data into a Table
- From the Add Data menu, select Load Data into a Table.
- Choose to upload files directly or bring data from a stage.
- Browse and upload the failed banks CSV file.
- If no database exists yet, create a new one. Greg creates a database called
failed_banks_DB.
- Create a table within the database, naming it
failed_banks_table.
- Review the file preview and correct any column name issues (e.g., replacing spaces with underscores).
- Select file format options such as CSV, JSON, or Parquet as appropriate for the data type.
- Set error handling preferences, such as skipping invalid rows or stopping on errors.
- Click Load to ingest the data.
Querying the Data
After loading the data, Snowflake automatically generates a query window with a sample SELECT * FROM statement. Greg demonstrates how to:
- Run queries using the Run or Play button.
- View results instantly, with the default limit set to 10 rows.
- Increase the limit to return all data and test Snowflake’s query performance.
In the demonstration, the dataset reveals that Chicago is the city with the most failed banks, while Georgia is the state with the highest number of failures (93). Even with larger queries, Snowflake performs quickly, highlighting its scalability.
Visualizing the Data
Beyond querying, Snowflake provides a Chart option that allows users to generate quick visualizations directly in the interface. This makes it easier to explore patterns and gain insights without exporting to another tool. Greg points out that the Pragmatic Works On-Demand Learning platform covers additional visualization techniques, as well as more advanced data loading strategies.
Key Takeaways
- Snowflake makes it easy to load data directly into a table or via staging areas.
- Column names and data types should be reviewed during the import process to avoid errors.
- Users can query and preview data immediately after loading, testing Snowflake’s speed and flexibility.
- Simple visualizations can be created within Snowflake, but more advanced options are available through external BI tools.
- Pragmatic Works On-Demand Learning provides deeper training on error handling, file formats, and complex loading scenarios.
Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on SnowFlake and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.