We know that Dynamo really is and no sequel database and it has several advantages over traditional
relational databases how ever we might find ourselves in situations where we want to run complex queries
like we do on Siku our relational databases and Dynamo is not the best way to perform these queries.
We often perform these queries for the purpose of reporting our for the purpose of in politics.
In this section we are going to learn how to load the dynamo data into Amazon red shift.
Red shift is a data warehousing solution from AWOS and we can use it to perform sequel based queries
on our dynamically table data.
Now you don't have to do this hands on activity if you don't want to.
You can just watch the videos as I demonstrate this to you.
And even by just watching these videos you'll be able to appreciate the benefits of using a sequence
like platform on top of Dynamo DV but equally you're welcome to build along with me and perform the
demos within your environment.
So let's begin refers to have to create a red shift cluster and then lo Dynamo the data into it and
then we can connect to the cluster using a sequel to like sequela workbench and perform our sequel queries
these queries are performed on the copy of Dynamo the data.
They do not Kinsey's to the Dynamo the table capacity the operation of copying data or from dynamo Leavey.
Well of course zeem appropriate table capacity and obviously there are certain differences in these
key mine used by dynamo D.B and the one that is used by ratshit and we have to make sure that we make
suitable adjustments for that in our leader.
For example dynamo table names can have up to two hundred and fifty five characters why redshift only
allows up to 127 characters.
This may not be a major issue though.
I like Danimal the readership does not allow us to use Dot and Dash characters in it's table names underscore
characters are allowed in the and also we cannot use the redshift reserved words as table names.
We know that Dynamo D-MI does not have now rallies.
We have to specify how friendship and upbraids empty Raley's from dynamo D-B either as nulls are as
antifreeze also recip uses different data than dynamo D.B and we have ensured that Dynamo D-B attributes
can be properly accommodated in the redshift table fields.
That said let's create a new redshift lustrum open the wretched console and launch MDO Blaster
less galiot teeny tiny Maidie Blaster and database name as say D-B next.
Well you the same.
The forebode.
Let's use AWOS user as Master username and give me the password and do make a note of the Basford.
Continue on the screen we will simply accept the default and continue
the next screen has a few more settings.
We are not going to encrypt the database.
I'm going to use the default BBC and default subnet group.
We want the cluster to be accessible over the Internet are from outside the BBC
for the security groups.
I'm going to use the data for security through the security group should allow inbound connections from
your IP address.
So let's go over to easy to console click on Tea Party groups.
I'm going to select the default one and under in-bound settings we need to add a room to allow connections
on the redshift board so plague ended select redshift from the drop down so this could be either your
IP or anywhere.
I'm going to set it to anywhere and click save.
All right.
Back in the red shift console now
we don't need Iglauer watch alarms and will need to create a new high end role to work with these clusters.
Let's open.
I am in a new tab
and from Rose create a new role.
We want this role to be able to access red shift as well as dynamo D-B select redshift customizable
since we want to add dynamo divi permissions and click next
search for red shift and select Red Shope full access and then search for Dynamo D.B and select dynamo
D-B full access.
Click next and let's name the role as a redshift Dynamo the role create role back and the redshift console
refresh the roles dropdown and select the role that we just created.
What kind of name reveal the configuration wants and launch the classroom.
The plaster is being created.
Please close and our cluster should be ready in a few minutes.
While our cluster is getting created let's click on Connect client from the left side bar and this green
Shade's steps to connect to red shift from our computer.
So we need to install sequel workbench to sequel work bench is a free cross-platform sequel.
What a tool to download this too.
We can simply google for it.
Our goal is to double double double our sequel haif when workbench workbench are you and click on downloads
and download the package.
And we simply extract it to a folder on our computer and we should be good to go.
No special installation is needed here as a prerequisite.
You must have the latest version of JR.
We are JDK our own time and Wineman to our job.
I developed a kit installed on your computer and if you don't have one you can download and install
it from John dotcom website.
I already have it installed on my computer back in the red shift console.
Let's see if our cluster is ready.
Antedates said.
Let's click on Connect blind link.
We have completed this step one step two is to download the red shift driver.
So let's download TABC 4.2 driver
and in step 3 select the cluster we created and all of us well show us the connection you are know this
ABC you are at and let's launch the sequel workbench by launching the sequel we're bench Jarve.
We first create a new roof line let's call it redshift then under driver like the Amazon redshift and
we might need to specify the path to the driver.
Play yes and then select the driver Jarre find that be downloaded
then based on the JVC you Arel from the command line screen.
And enter the cluster master username and password that we specify by creating the blusterer set order
me to to and hit OK.
We are now connected to test the connection.
We could simply list the tables using a query like so select start from information underscores Kiem
dart tables semi-colon and run it using the triangle eye on our control.
The we can see the information about the tables here awesome.
So now that we have created a chip cluster and we are able to connect to it from our computer in the
next video I'll show you how to create a new redshift of table and copy data from dynamo Nimi table
to this redshift table.