Welcome to Native Object Store - Analytics Database - Teradata Vantage

Teradata Vantage™ - Native Object Store Getting Started Guide - 17.20

Analytics Database
Teradata Vantage
Release Number
June 2022
English (United States)
Last Update
Product Category
Teradata Vantage

Using Native Object Store

Native Object Store (NOS) is a Teradata Vantage™ capability that enables Business Analysts, System Administrators, Data Scientists, and Database Administrators to use standard Teradata SQL and APIs to:
  • Search and query CSV, JSON, and Parquet format datasets located on S3-compatible object store platforms
  • Write data stored on Vantage to S3-compatible object store platforms

For more details, see NOS Functionality.

Why Would I Use this Content?

This document shows you how to access your S3-compatible object storage from Analytics Database, so that you can analyze data stored in external object storage.

Examples are provided showing how to perform various tasks, such as sampling the externally stored data, loading external data into the database, joining external data to data stored in the database, filtering data for efficiency, and so on. You can query external object store by creating a foreign table in the database or by reading directly from external object store.

How Do I Use this Content?

These instructions are for Database Administrators:

Before using NOS, verify that the following steps are completed. The following table provides links to detailed instructions.

Operation Examples
Create a user or modify existing users to have the required access privileges. Set up test user

Set access privileges

Create an authorization object. Create authorization object for foreign table credentials
To run the Teradata-supplied examples to read from external object store, create a foreign table for your data format. Setting Up to Run Examples
To run the Teradata-supplied examples to write to external object store:
  • Create a user with the required privileges
  • Create an authorization object
Setting Up WRITE_NOS

These instructions are for Business Analysts and Data Scientists:

Follow the instructions in How Do I Get Started.

Focus your attention on the documentation for your data format: CSV, JSON, or Parquet.

How Do I Get Started?

You can run all the examples in the order given or use the examples specific to the task you want to perform.

You can test reading CSV, JSON, and Parquet examples by using the Teradata-supplied public object stores and sample data. You do not need to create your own object store for the sample data. The examples use a sample river flow data set. USGS Surface-Water Data Sets are provided courtesy of the U.S. Geological Survey.

  • A Vantage-supported client, such as Teradata Studio™ or BTEQ to run the examples and query the external object store.
  • For WRITE_NOS, you need your own external object store on a Teradata-supported external storage platform. Data is written to your external storage by the WRITE_NOS examples.
Before proceeding, you need a user with the required access privileges. Depending on which examples you run, you may need a foreign table and an authorization object.
Operation Examples
Read and load data from external object store

Examples: For Business Analysts

Examples: For DBAs and Advanced Users

Write data to external object store Writing Data to External Object Store

Additional Resources

Analytics Database
  • Native Object Store: Teradata Vantage™ Advanced SQL Engine, TDN0009800 (Orange Book)
    Log in to https://docs.teradata.com/ to access it.
  • Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
  • Teradata Vantage™ - SQL Data Manipulation Language, B035-1146
  • Teradata Vantage™ on AWS Getting Started Guide, B700-4015
  • Teradata Vantage™ on AWS Marketplace Subscription Guide, B035-2806
  • Teradata Vantage™ on Azure Getting Started Guide, B700-4016
  • Teradata Vantage™ on Google Cloud Getting Started Guide, B700-4020