---
title: Getting Started with Snowflake Notebooks
description: Learn how to set up and create Snowflake Notebooks from scratch, including role, database, and warehouse creation, and loading data into tables.
image: https://blog.ippon.tech/hubfs/Blockchain%20copy%202-1.png
---
[   ](https://ipponusa.com/)
- [Home](https://ipponusa.com)
- [Show submenu for About About](https://ipponusa.com/about-us)
- [Who We Are](https://ipponusa.com/who-we-are)
- [Careers](https://ipponusa.com/careers)
- [Show submenu for Our Partners Our Partners](https://ipponusa.com/our-partners/)
- [AWS](https://ipponusa.com/our-partners/aws/)
- [Snowflake](https://ipponusa.com/our-partners/snowflake/)
- [Databricks](https://ipponusa.com/our-partners/databricks/)
- [Microsoft](https://ipponusa.com/our-partners/microsoft/)
- [Show submenu for Services Services](https://ipponusa.com/services)
- [Snowflake](https://ipponusa.com/service/snowflake-concierge/)
- [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
- [Data & Analytics](https://ipponusa.com/service/data-analytics/)
- [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
- [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
- [Product Innovation](https://ipponusa.com/service/product-innovation/)
- [Operating Model](https://ipponusa.com/service/operating-model/)
- [Blogs](https://blog.ippon.tech/)
- [Success Stories](https://ipponusa.com/success-stories/)
- [Show submenu for Resources Resources](https://ipponusa.com/resources/)
- [eBooks](https://ipponusa.com/ebooks/)
- [The Data Pour](https://info.ippon.tech/the-data-pour)
- [Videos & Webinars](https://info.ippon.tech/videos-and-webinars)
- [Media Center](https://ipponusa.com/media-center/)
Search
Open main navigation
Close main navigation
- [Home](https://ipponusa.com)
- Show submenu for About About
- About
- [About](https://ipponusa.com/about-us)
- [Who We Are](https://ipponusa.com/who-we-are)
- [Careers](https://ipponusa.com/careers)
- Show submenu for Our Partners Our Partners
- Our Partners
- [Our Partners](https://ipponusa.com/our-partners/)
- [AWS](https://ipponusa.com/our-partners/aws/)
- [Snowflake](https://ipponusa.com/our-partners/snowflake/)
- [Databricks](https://ipponusa.com/our-partners/databricks/)
- [Microsoft](https://ipponusa.com/our-partners/microsoft/)
- Show submenu for Services Services
- Services
- [Services](https://ipponusa.com/services)
- [Snowflake](https://ipponusa.com/service/snowflake-concierge/)
- [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
- [Data & Analytics](https://ipponusa.com/service/data-analytics/)
- [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
- [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
- [Product Innovation](https://ipponusa.com/service/product-innovation/)
- [Operating Model](https://ipponusa.com/service/operating-model/)
- [Blogs](https://blog.ippon.tech/)
- [Success Stories](https://ipponusa.com/success-stories/)
- Show submenu for Resources Resources
- Resources
- [Resources](https://ipponusa.com/resources/)
- [eBooks](https://ipponusa.com/ebooks/)
- [The Data Pour](https://info.ippon.tech/the-data-pour)
- [Videos & Webinars](https://info.ippon.tech/videos-and-webinars)
- [Media Center](https://ipponusa.com/media-center/)
- Search
- [Contact Us](https://ipponusa.com/contact/)
[Contact Us](https://ipponusa.com/contact/)
# Getting Started with Snowflake Notebooks
by [Ippon Data Team](https://blog.ippon.tech/author/ippon-data-team)
February 26, 2025
Authors: [Sarah Narum](https://www.linkedin.com/in/sarah-narum?miniProfileUrn=urn%3Ali%3Afs_miniProfile%3AACoAACBUj0UBaUnqySreXi8O-AeR3mH_ToaIEuE&lipi=urn%3Ali%3Apage%3Ad_flagship3_search_srp_all%3BZrQ%2BKRvoSu6I7yDgFLQCkg%3D%3D), [Elle Estwick](https://www.linkedin.com/in/eleanorestwick/), [Stephen Lowery](https://www.linkedin.com/in/stephen-e-lowery?miniProfileUrn=urn%3Ali%3Afs_miniProfile%3AACoAABRLdmIB_XlsGZ7CZaLvApi7cruyogTKKqE&lipi=urn%3Ali%3Apage%3Ad_flagship3_search_srp_all%3BatfiJuxRRdugI%2Bx75XromQ%3D%3D), [Emma York](https://www.linkedin.com/in/emma-eleanor-york?miniProfileUrn=urn%3Ali%3Afs_miniProfile%3AACoAABiRX1oBJvRs_gNCvA_30yGYvCQPazsLnsc&lipi=urn%3Ali%3Apage%3Ad_flagship3_search_srp_all%3BcLI7a2t6RDGeJibgR4Eijg%3D%3D)
This repository covers how to get started with [Snowflake Notebooks](https://docs.snowflake.com/en/user-guide/ui-snowsight/notebooks) from 0 to a working set of notebooks, ready to deploy to your Snowflake account today!
## Setup
We'll need to create a few resources to get ready for our Notebook and have some data to interact with. The next few steps will walk you through how to do that.
### Role, Database, and Warehouse Creation
To get started, go ahead and create a new Worksheet in the Snowflake UI. We'll be creating a [Role](https://docs.snowflake.com/user-guide/security-access-control-overview?utm_cta=website-be-guides-mmds#roles), [Database](https://docs.snowflake.com/en/sql-reference/sql/create-database), and [Warehouse](https://docs.snowflake.com/en/sql-reference/sql/create-warehouse). We'll then grant our role the ability to use the database/warehouse, then grant that role to our user account. This gives us the access we need to do the next steps. This guide assumes that you have access to the `sysadmin` and `securityadmin` roles- if not, you can use roles within your account with similar permissions or reach out to your account administrator for assistance.
Copy the content of the [setup script](https://github.com/slowery4ippon/snowflake-labs-notebooks/blob/main/scripts/01_setup.sql), paste it into your notebook, and review the commands/comments. Before executing the script, change the text `YOUR_USER_HERE` to be your snowflake username.
Once you're satisfied with the commands in your worksheet, select the text and click the "Run" button. When the commands execute successfully you should be able to validate your newly created objects by running:
```
use role notebook_lab_role;
desc database notebook_lab_db;
```
You should see some basic information about the database we just created. Additionally, it should now appear in the object explorer pane on the left of the snowflake console
**Note:** If you're using a personal account or are otherwise cost-constrained, it's probably a good idea to set up a [Resource Monitor](https://docs.snowflake.com/en/sql-reference/sql/create-resource-monitor) before moving on. We've provided an example script [here](https://github.com/slowery4ippon/snowflake-labs-notebooks/blob/main/scripts/02_resource_monitor.sql). This *does* require `accountadmin` permissions- so you may have to reach out to your account admin to get it set up (if they don't have one already).
### Load Data to a new table
We will be using Kaggle's Full IMDb Dataset - available to download [here](https://www.kaggle.com/datasets/octopusteam/full-imdb-dataset).
Navigate to 'Data' in the lefthand menu and select 'Add Data'. For this Lab we will be using the 'Load data into a Table' functionality to load data directly from a file into a table:
Select your warehouse in the upper right corner of the pop up and use the 'Browse' button to select your data file:
Select your target database and schema, choose 'Create new table' and give your new table a name. Click Next:
The next window will allow you to update data types, column names and decide what should happen if an error occurs. For this lab, leave the default setting on the left two options and update the 'DATA TYPE' for column 'averageRating' to FLOAT. Click 'Load':
Once your data has successfully loaded, simply click 'Done'!
### Create Notebook
To create a new notebook, Navigate to the "Projects" section on the left pane and select the "Notebooks" tab. Click on the "+ Notebook" button in the top right:
In the resulting dialog, give the notebook a name (like `Snowflake Lab`), a location (in our `NOTEBOOK_LAB_DB` database) and select the `NOTEBOOK_LAB_WH` as the warehouse. For the Python environment option, leave it on `Run on warehouse`, then click "Create":
To make sure the notebook works, copy the following code into the first cell:
```
select min(releaseyear), max(releaseyear) from notebook_lab_db.public.imdb
```
You should see a response like:
We've successfully created a Snowflake Notebook!
## Related Articles
##### [ Snowflake • June 4, 2025 Snowflake Introduces UBAC - What it Means For RBAC 2 min read](https://blog.ippon.tech/snowflake-introduces-ubac-what-it-means-for-rbac)
##### [ Snowflake • June 3, 2025 Snowflake Summit 2025 - Platform Keynote Feature Announcements 2 min read](https://blog.ippon.tech/snowflake-summit-2025-platform-keynote-feature-announcements)
##### [ Snowflake • March 20, 2025 Snowflake Notebooks QuickStart: Ingesting Data via External APIs 5 min read](https://blog.ippon.tech/snowflake-notebooks-quickstart-ingesting-data-via-external-apis)
### Comments
### Subscribe to Our Blog!
Stay informed with the latest insights and updates by signing up for our weekly blog newsletter – delivered straight to your inbox!
[Back to blog homepage »](https://blog.ippon.tech/)
Ippon is a consulting and expertise firm, who is convinced that technology is a source of progress for society. We help our clients leverage their digital assets to design an appropriate strategy and deploy their transformation roadmap at scale.
#### Navigation
- [Home](https://ipponusa.com/)
- [About](https://ipponusa.com/about-us/)
- [Services](https://ipponusa.com/services/)
- [Blogs](https://blog.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- [eBooks](https://ipponusa.com/ebooks/)
- [The Data Pour](https://info.ippon.tech/the-data-pour?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
[Contact Us](https://ipponusa.com/contact/)
[Join Us](https://ipponusa.com/careers/)
#### Services
- [Data & Analytics](https://ipponusa.com/service/data-analytics/)
- [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
- [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
- [Operating Model](https://ipponusa.com/service/operating-model/)
- [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
- [Product Innovation](https://ipponusa.com/service/product-innovation/)
#### Ippon International
- [France](https://fr.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- [Australia](https://au.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- #### Contact
- Ippon Technologies
[3431 West Leigh Street Richmond, VA 23230, USA](https://maps.app.goo.gl/RySm6SAwZnsxeiLz9)
- [(844) 477- 6687](tel:8444776687)
- [Sales@ipponusa.com](mailto:Sales@ipponusa.com)
©Copyright 2024 Ippon USA. All Rights Reserved. | [Terms and Conditions](https://ipponusa.com/privacy-policy/) | [Privacy Policy](https://ipponusa.com/privacy-policy/) | [Website by Skol Marketing](https://skolmarketing.com/)
```json
{
"@context" : "https://schema.org",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Ippon Data Team",
"url" : "https://blog.ippon.tech/author/ippon-data-team"
},
"dateModified" : "2025-02-26T06:30:00.895Z",
"datePublished" : "2025-02-26T06:30:00.000Z",
"headline" : "Getting Started with Snowflake Notebooks",
"image" : [ "https://blog.ippon.tech/hubfs/Blockchain%20copy%202-1.png" ],
"mainEntityOfPage" : {
"@id" : "https://blog.ippon.tech/getting-started-with-snowflake-notebooks",
"@type" : "WebPage"
},
"publisher" : {
"@type" : "Organization",
"logo" : {
"@type" : "ImageObject",
"url" : "https://blog.ippon.tech/hubfs/logo_SVG.svg"
},
"name" : "Ippon Technologies"
}
}
```