Teradata Studio is a client-based GUI for database administration, query development, and management tasks on databases and Hadoop systems. Teradata Studio has a modular display.
Using Teradata Studio, you can do the following:
- Create a custom user interface.
- 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 determines data types, creates tables, and loads the data.
- Copy database objects to another database or system.
- Move space between databases.
- Compare SQL DDL statements side-by-side.