Join Lynn Langit for an in-depth discussion in this video Connecting to AWS Redshift with SQL Workbench, part of Amazon Web Services: Data Services.
- Here we are in the Amazon console…in our Redshift cluster and we're…on the Connect Client section.…So we can use JDBC or ODBC in the driver…specific to Redshift.…So we can use a Partner Tool or we can use…SQL WorkbenchJ.…So what we're going to do is install SQL WorkbenchJ…after we install our drivers.…So the first thing that we're going to do is…we're going to select our driver and download it.…And then we're going to select our cluster…and you can see there is our cluster connection…string, our information.…
So now I'm going to go ahead and install SQL WorkbenchJ…and I found that this link is a little bit simpler…so let's use this link; www.sql-workbench.net.…And then I would click on build 117.…I'm working with a Mac so you're going to…want to do the install for your particular…operating system.…Now I recommend that you follow…the instructions at this location.…So you can see in the instructions here…the first thing that you need to do is downloading…and starting the workbench which we did.…
And now in the workbench we need to open…
Author
Released
9/18/2015- Why cloud tools matter
- Storage choices on AWS
- RDBMSs such as Core RDS, Aurora, and Oracle
- Working with semistructured data in NoSQL
- Connecting to data warehouses such as AWS Redshift and Snowflake
- Graph databases and AWS Machine Learning
- Working with Hadoop
- Common data scenarios and architectures
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome56s
-
-
1. Amazon Web Services (AWS)
-
Exploring AWS data storage3m 27s
-
2. Storage Options on Amazon Web Services
-
Exploring EBS and EFS5m 48s
-
Other AWS file services2m 59s
-
3. About Relational Database Management Systems (RDBMSs)
-
Using MySQL Workbench5m 48s
-
Introducing Aurora4m 51s
-
Exploring RDS with Aurora4m 52s
-
Summarizing RDBMS and prices6m 44s
-
4. About NoSQL
-
Understanding ElastiCache6m 44s
-
Understanding DynamoDB11m 49s
-
Understanding Kinesis7m 53s
-
Using NoSQL with MongoLab6m 13s
-
Summarizing NoSQL and prices4m 56s
-
5. AWS Data Warehouse and Pipelines
-
Working with AWS Redshift3m 11s
-
Summarizing data warehousing2m 20s
-
Visualizing data with BIME4m 52s
-
Using AWS data pipelines6m 33s
-
6. Graph Databases and Machine Learning
-
Using AWS Machine Learning13m 37s
-
7. Hadoop on AWS
-
Exploring Hadoop on AWS5m 45s
-
-
8. AWS Data Scenarios and Architectures
-
Exploring more resources3m 47s
-
Conclusion
-
Goodbye3m 24s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Connecting to AWS Redshift with SQL Workbench