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
- 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 |
| 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:
|
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.
| Operation | Examples |
|---|---|
| Read and load data from external object store | |
| Write data to external object store | Writing Data to External Object Store |
Additional Resources
| Advanced SQL Engine |
|
| AWS |
|
| Azure |
|
|