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

Lake - Using Queries, UDFs, and External Stored Procedures
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-08-12
dita:mapPath
vgj1683671089901.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
vgj1683671089901
  1. Connect to your environment.
  2. Select a database from your list of databases. Use the search option to locate databases, users, tables, and views.
  3. [Optional] Select next to a database or user and select Add to starred.
  4. Select on the list of scripts.
  5. 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.
  6. [Optional] Select a compute group.
  7. 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.
  8. [Optional] Select on the Run row, and select Save as.