Preparing your development environment
1. Preparing your development environment
This course was designed for you to follow along, so we'll build your first AI app on Snowflake together. First, you'll need a Snowflake free trial account, and second, you will need a code editor. I will be using Snowflake Notebooks. Now, let's walk through setting these up. To start, you'll need a Snowflake account with account admin access. If you completed the reading prior to this video, you should already have a free trial account you can use. If you haven't, please pause this video and come back after you complete that reading. You will also need a code editor so that you can open code, read it, modify it, run it, and fully immerse yourself in the concepts that we will cover in this course. In this course, I will be using Snowflake Notebooks. Snowflake Notebooks are integrated into the Snowflake UI and available as part of the free trial account. You don't need to install it separately. You should pause the video now to log into your Snowflake free trial account. The Snowflake UI is called Snowsight, so don't be puzzled when I use Snowsight and Snowflake UI interchangeably. Once you've logged into your Snowflake account, you can continue with the rest of the video. Let us create our first Snowflake Notebook using Snowsight. With Snowflake Notebooks, you can write and execute code, visualize results, capture notes, and share insights with other Snowflake users. To create a Notebook, you need a database and schema to store and manage the Notebook. You can use an existing database and schema or create new ones. To simplify storing and managing Snowflake Notebooks, I recommend you create a dedicated database and schema. Say, NotebookDB and NotebookSchema. Snowflake Notebook requires a virtual warehouse to run the Notebook processes and any Snowflake code. I recommend that you start by using an extra small warehouse to minimize credit consumption. In Snowsight, navigate to the Projects tab in the left panel, click on Notebooks. On the top right, click on Create Notebook button. See how it asks you to select a database and schema to store the Notebook and a warehouse to run it. Let's create a database schema and a warehouse first. Click on Cancel. Select the Data tab from the left panel and navigate to Databases. On the top right, click on the Create Database button. Type in Notebook underscore DB for a database name and click Create. You can see the NotebookDB listed in the databases now. Click on the downward arrow next to NotebookDB. It has two schemas, Information Schema and Public Schema. Let us now create a new schema for the Notebook. Click on the Create Schema button on the top right and type in Notebook underscore Schema for the schema name and click Create. You can click on Notebook Schema and it shows no object found. This is because we haven't created any Snowflake objects under the schema. Next up, we need to create a virtual warehouse to run the queries in the Notebook. Snowflake has warehouses specifically optimized for different compute job. Let's navigate to the warehouses available in our account to see what options we have available to us. To do this, first click on the Admin tab on the left panel and navigate to Warehouses. You can see there are two warehouses already created in the trial account. Compute Warehouse is of extra small size. This warehouse was created in the free trial account for you. This runs any SQL and Snowpark Python code issued by the Notebook. The next one is System Created Streamlit Notebook Warehouse. This is a dedicated Snowflake managed warehouse automatically provisioned in each account for running Notebooks. The warehouse only runs Notebook jobs and is owned and managed by Snowflake under the system role. You cannot drop or alter this warehouse. This is the warehouse specifically optimized for Notebook specific jobs. Are you able to notice the difference between the two warehouses? Notebook Warehouse to run the Notebook kernel and the processes. Query Warehouse to run the SQL and Python code you write in the Notebook. We just created the database and schema to store the Notebook. We already have Snowflake managed and owned Notebook Warehouse. The System Created Streamlit Notebook Warehouse. And the Snowflake created Query Warehouse, Compute Warehouse. The Query Warehouse can be resized if you're running a complex query. With that, we are now ready to create our first Snowflake Notebook. In Snowsight, navigate to the Projects tab in the left panel. Click on Notebooks. On the top right, click on the Create Notebook button. Give the Notebook a name. I will call it My First Notebook. Select Database as Notebook DB and Schema as Notebook Schema. And select Compute Warehouse for the Query Warehouse. And click Create. You have your first Snowflake Notebook. So far, in this video, you have set up your Snowflake free trial account, created your first database in Schema, and created your first Snowflake Notebook as well. When you successfully complete this, you can move on to the next video.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.