Create a Single Query Using Editor | VantageCloud Lake - Creating a Single Statement or Script

Create a Single Query Using Editor | VantageCloud Lake - Creating a Single Statement or Script - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

Connect to your environment.
Select a database from your list of databases. Use the search option to locate databases, users, tables, and views.
[Optional] Select next to a database or user and select Add to starred.
Select on the list of scripts.
Enter your query in the script window. You can drag the table name from the database to the script window.
To use a variable in your query, enter ${variable_name} for the variable. You are prompted to set the type and add a hint for the variable. When the query is run, you are prompted for the variable.
[Optional] Select a compute group.
Select Run to run the script. The results show 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.