| Use Case | More Info | Documentation and Videos |
|---|---|---|
| Explore the Vantage user interface | See Vantage Trial Components. | |
| Create databases and tables in Teradata Vantage and run ad hoc queries | Use Editor or JupyterHub. Using JupyterHub, the SampleNotebooks/sql/GettingStarted notebook describes how to write and execute SQL. |
|
| Load data into Teradata Vantage | Use any of the following options:
|
For examples of loading data, see |
| Explore Vantage functionality | Run the Featured Use Cases. |
|
| Run data lake analytics using NOS | Run any of the data analytics use cases. See Featured Use Cases. After using the use cases to learn how, you can join external data with data stored in cloud data lakes using NOS. Use SQL commands in Editor. |
|
| Explore data in object stores | Use Editor or JupyterHub to run SQL commands to query database tables and access external object storage. See Accessing the Teradata-Managed Object Store and Access Your External Object Store. | |
| Download result sets from a query | Use Editor to download CSV files. Each file is limited to 10,000 rows of data. Use JupyterHub to download result sets. In your JupyterHub workspace, navigate to the Teradata>ResultSets directory that contains your data, right-click the files, and select Download. The BackUpYourWork notebook describes how to download CSV files. |
|
| Use JupyterHub to write and execute SQL, Python, and R code | Before creating your own Teradata SQL, Python, and R notebooks, see how it is done by using the notebooks in the SampleNotebooks/ and UseCases/ directories. See JupyterHub and Featured Use Cases. |
For more on writing SQL, Python, or R code with
JupyterHub and view helpful videos, see https://teradata.github.io/jupyterextensions/. Do not download standalone or
docker images as they are not built to use in Vantage Trial.
|
| Run advanced analytics to visually explore data | From your site page, select to watch the Getting started video that shows examples and use cases. Vantage Analyst User Guide, B035-3805 describes Vantage Analyst use cases. Workflows and Rules are used in the Path use cases. |
See Vantage Analyst Path Analysis Tutorial. To view tutorial videos, go to Teradata TechBytes on YouTube and select Vantage Analytics Library videos. |
| Use the Vantage Analytics Library | If you are a data scientist, use the Vantage Analytics Library functions for data science operations.
Explore the Vantage Analytics Library through the notebooks in the UseCases/VAL directory. |
See Vantage Analytics Library User Guide To view tutorial videos, go to Teradata TechBytes on YouTube and select Vantage Analytics Library videos. |
| Perform system elasticity: Scale up, scale down, scale out, and scale in | For elasticity information, see the in-product help in the Console. See Console. |
|
| Generate an Amazon S3 bucket policy code snippet to allow Vantage to access my Amazon S3 bucket | See Access to Your Amazon S3 Bucket. | |
| Create a Columnar table | Use Teradata Columnar to organize data of a user-defined table or join index on storage to reduce I/O for certain classes of queries. You can partition a table or join index by column. | You must log in to see the Orange Books.
Syntax and rules for creating a
columnar table:
|
| Use Temporal | Use Teradata Temporal for the time dimension, including facilities for storing, querying, and updating data with respect to time. A temporal database distinguishes between historical data, current data, and data that will be in effect in the future. Teradata Temporal includes a temporal version of SQL, DDL, data types, and DML for temporal tables. | To view tutorial videos, go to Teradata TechBytes on YouTube and select the following: Vantage - 4D Analytics Also see the following documents:
|
| Use Geospatial | Use tools and database objects (including data types, functions, and methods) that provide an interface between the SQL Engine and applications that manage, analyze, and display geographic information. | To view tutorial videos, go to Teradata TechBytes on YouTube and select the following: Vantage - 4D Analytics Also see the following document: Teradata Vantage™ - Geospatial Data Types |