Preparing your development environment
1. Preparing your development environment
I'm James Cha-Earley, a Senior Developer Advocate at Snowflake, and I'll be your instructor for some of these lessons in this course. This course was designed for you to follow along, so we'll build your first AI app on Snowflake together. First, we'll need a Snowflake free trial account, and second, you'll need a code editor. I'll be using Snowflake Notebooks. Now, let's walk through setting these up together. To start, you'll need a Snowflake account with ACCOUNTADMIN 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 do that reading. You'll also need a code editor so you can open code, read it, modify it, run it, and fully immerse yourself in the concepts that we will be covering in this course. In this course, I will be using Snowflake Notebooks. Snowflake Notebooks are integrated into the Snowflake UI and are available as part of the free trial account. You don't need to install them 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's 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 a new one. To simply storing and managing Snowflake Notebooks, I recommend you create a dedicated database and schema. Let's say NotebookDB and NotebookSchema. Snowflake Notebook requires a virtual warehouse to run the notebook process and any Snowflake code. I recommend that you start using an extra small warehouse to minimize credit consumption. In Snowsight, navigate to the Projects tab in the left panel. Click on Workspaces. On the top left, click on the Add New button and select Notebook. You'll need to click the Connect button in the top middle. Inside Workspace, we can now create a database and schema using code to define those objects. We already have Snowflake managed and own Notebooks warehouses. The system-created Streamlit Notebook warehouse and the Snowflake-created Query warehouse and Compute warehouse were built for us. 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 Workspaces. Navigate to your existing notebook that we were using earlier. You can now rename the notebook if you wish using the Notebook options. I will call this My First Notebook. Here, we're using Database and Schema we created earlier, but you can select a new database and schema using Use Database and Use Schema commands. You can also select a warehouse besides Compute Warehouse for your Query Warehouse if you so choose. But for now, let's leave it as default. Easy enough. Congrats! You have your first Snowflake Notebook. So far in this video, you set up your Snowflake free trial account, created your first database and 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.