17.10 - Welcome to Native Object Store - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Last Update
2022-06-22
Content Type
Programming Reference
Publication ID
B035-1214-171K
Language
English (United States)
Last Update
2022-06-22

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata® Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage.

Using Native Object Store

Native Object Store (NOS) is a 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 Advanced SQL Engine, 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.

Prerequisites
  • 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

   
Advanced SQL Engine
  • 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
AWS
  • Teradata Vantage™ on AWS Getting Started Guide, B700-4015
  • Teradata Vantage™ on AWS Marketplace Subscription Guide, B035-2806
Azure
  • Teradata Vantage™ on Azure Getting Started Guide, B700-4016
Google
  • Teradata Vantage™ on Google Cloud Getting Started Guide, B700-4020