You can run single statements and scripts in VantageCloud Enterprise Editor. When you run a script, the Editor returns a Results tab for each statement. The Output tab shows the number of rows returned for the SQL statements.
To create a script or SQL query, follow the steps:
- Log on to https://cloud.vantage.teradata.com.
- Open the Editor and connect to your environment by selecting it from the environments list.If the connection does not exist, create one using the + Add connection, select the system, and then select Connect.
- Select + New script to create an SQL script.
- Select a database from your list of databases in the Objects pane. Use the search option to locate databases, users, tables, and views.
- Enter your query in the script window. You can drag and drop table names while building queries.
- Select
to run the query.The results are displayed in the results window. You can sort and filter results, export them in JSON or CSV format, and copy them to the clipboard.
- [Optional] Select
on the Run row, and select Save as to save the script.