AWS, Amazon Redshift, SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for AWS Amazon Web Services, Redshift, AWS Lambda Functions, S3 Buckets, VPC, EC2, IAM

Amazon Redshift SQL Notebooks

Amazon Redshift is introducing SQL Notebooks for data platform SQL developers.
SQL Notebooks can be used to organize your queries by grouping related SQL queries in a single SQL Notebook document, adding explanations for each SQL query by using Markdown cells.
SQL notebooks can be shared to team members.

To start working with SQL Notebooks for your Amazon Redshift database SQL developments,
Launch AWS Management Console
Go to Amazon Redshift Dashboard
On the left menu, you will see Query editor v2

Amazon Redshift Dashboad menu

Connect to a database from the target Amazon Redshift cluster

connect database on Redshift Query Editor

On Amazon Redshift Query Editor screen, click on "+" (Plus) sign and select "Notebook" to create a new SQL Notebook to run on target Redshift database

create SQL Notebook

When a SQL Notebook is created, it is displayed as follows

Amazon Redshift SQL Notebooks

First you can rename your SQL Notebook by pressing the "Rename" button on the right side of the Notebook

rename SQL Notebook

By using "Add markdown" buttons, first add a descriptive information about the SQL Notebook and its content

Then add your SQL queries and your comments on each SQL query by using "Add SQL" and "Add markdown" buttons which will add new SQL Query and text sections within the SQL Notebook

sample SQL Notebook for Amazon Redshift

It is possible to run SQL queries on the database attached and add comments on the output using markdown cells.

After you complete your developments on the SQL Notebook, close the notebook by pressing the "x" icon displayed on the SQL Editor tab

Now you can organize your SQL Notebooks by creating a folder structure which is meaningful for you and share your SQL Notebooks with your team mates

On Query Editor v2, you will see "Notebooks" side menu on the left. If you click on the Notebooks icon, it will display a content like below where you can execute basic actions regarding notebook files and organizing them in a folder structure.

Redshift SQL Notebook folders and files

As you can see, you can create new folders based on your requirements by pressing the "New folder" button and renaming accordingly.
It is also possible to change the color of folders containing SQL Notebooks

folder tasks like change color

By drag and drop operations you can move a SQL Notebook into a new folder

move notebook files to folders

You can move a notebook file back to parent folder too.

SQL Notebook tasks

A SQL Notebook can be shared with other developers by a right-click on the notebook and then choosing the "Share with my team" menu option

share notebooks with team members

As for all AWS resources, it is also possible to assign and edit resource tags for your Amazon Redshift SQL Notebooks

edit tags of SQL Notebooks


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.