Teradata Studio is a client-based GUI used to perform database administration, query development, and management tasks on Teradata Databases, Teradata Aster Databases, and Hadoop systems. Teradata Studio has a modular display that allows users to create a custom user interface. Teradata Studio allows you to:
- Search for and view database objects or space and skew
- Write SQL using content assistance, edit and parse SQL, view history, and use SQL templates and annotations
- Build and edit SQL requests visually with SQL Query Builder
- Export result sets to Excel, XML, or text files
- Generate and run COLLECT STATISTICS requests
- Load and extract data with a smart data loader that automatically determines data types, creates tables, and loads the data
- Copy database objects to another database or system
- Move space between databases
- Compare SQL DDL side-by-side