- Search and query CSV, JSON, and Parquet format datasets located on external object storage
- Write data stored on Vantage to external object storage
Why Use this Content?
This document shows you how to access your external object storage from Analytics Database, so that you can analyze data stored in external object storage.
Examples show how to perform tasks such as sampling the externally stored data, loading external data into the database, joining external data to data stored in the database, and filtering data for efficiency. You can query external object storage by creating a foreign table in the database or by reading directly from external object storage.
How Do I Use this Content as a Database Administrator?
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 storage, create a foreign table for your data format. | Setting Up to Run Examples |
To run the Teradata-supplied examples to write to external object storage:
|
Setting Up WRITE_NOS |
How Do I Use this Content as a Business Analyst or Data Scientist?
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 external object storage and sample data. You do not need to create your own external object storage 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 storage.
- For WRITE_NOS, you need your own external object storage on a Teradata-supported external object storage platform. Data is written to your external object storage by the WRITE_NOS examples.
| Operation | Examples |
|---|---|
| Read and load data from external object storage | |
| Write data to external object storage | Writing Data to External Object Storage |
Additional Resources
| Analytics Database |
|
- NOS Functionality
- Command Syntax
- Setting Up Access
- Reading Data
- Writing Data to External Object Storage
- Using Delta Lake Manifest Files
- Data Cleanup
- External File Formats
- Authentication for External Object Storage
- Examples: Using Public Buckets and Containers
- Setting Up External Object Storage for River Flow Data
- Best Practices for Using NOS
- Native Object Store Limitations
- Terminology