O'Reilly logo

Amazon Redshift: A Columnar Database SQL and Architecture by David Cook, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2 - Best Practices For Table Design

“Beware of the young doctor and the old barber.”

- Benjamin Franklin

Converting Table Structures to Redshift

image

Above, we are converting all of the tables in a Teradata database to Redshift table structures. We went to our Teradata system and right clicked on the database SQL_Class and chose "Convert Table Structures". We selected all of the tables and hit the blue arrow. We then chose to convert to Redshift. Watch in amazement what happens next!

Converting Table Structures to Redshift Finale

image

All 20 Teradata ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required