From the course: Introduction to Amazon Redshift: Data Management Essentials
Join today to access over 25,500 courses taught by industry experts.
Getting your data into Redshift - Amazon Web Services (AWS) Tutorial
From the course: Introduction to Amazon Redshift: Data Management Essentials
Getting your data into Redshift
- [Instructor] For this course, we loaded Redshift with a sample dataset just so we can explore what it's like to work with Redshift from the AWS console. But if you're going to use Redshift for your project, you won't be using the sample dataset to load your data. Redshift uses a Postgres interface. So, you would first create your database schema in your database using create table commands. Similar to this one. You'll see some tips on optimizing Redshift in the next chapter that might affect how you design your tables. But your table design is going to look pretty similar to what you would do in any other relational database. If you are migrating over a large table schema from an existing database, take a look at the AWS Schema Conversion tool. Once you have all your tables created, you can just use regular SQL insert commands to insert data rows into these tables such as this one. If you are integrating Redshift into an…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.