Teradata SQL Assistant
How SQL Assistant Can Help You:
SQL Assistant is a Web-based query tool that enables you to compose a query,
SQL Assistant is a Web-based query tool that enables you to compose a query,
submit it to the Teradata database, view the results from a Web browser, and
save the data on your PC for analysis.
Using SQL Assistant, you can save the data retrieved from Teradata databases
to create consolidated reports or to analyze the data. SQL Assistant gives you
SQL activity, complete with source identification, timings, row counts, and
your notes. This is useful because you can use the historical record to build SQL
scripts and then modify the scripts to gather more specific results.
Key Features :
Using SQL Assistant, you can:
• Send queries to any Teradata database.
• View and sort the results by column and save them to a file.
• Save queries to a file so you can run them automatically from the same file
in the future.
• Load queries from a file and make changes before submitting them to the
database.
• View historical records of the queries you have submitted with timings and
status information. You can sort the history rows by column, update them
with your notes, and save the records to a file.
• View a hierarchical listing of databases with object names to reduce the
time required to create SQL statements.
• Use the browser’s built-in find features to do a string search on a query, an
answer set, or any information in the historical table visible in the browser
window.
• Abort a query in progress if you change your mind about running a query
or if a query is taking longer than you expected.
Also, to maintain security and help maximize your server’s resources, your
browser’s connection ends after 30 minutes of inactivity.
Thanks for Information Teradata is a Relational Database Management System (RDBMS) for the world’s largest commercial databases. Teradata can store data upto Teradata bytes in size. This makes the Teradata as a market leader in data warehousing applications. Teradata Online Training