WriteNOS | Data Transfer between Vantage and Cloud Storage| teradataml - WriteNOS - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage
WriteNOS allows users to do the following:
  • Extract selected or all columns from an user table or from derived results and write to an external object storage in Parquet data format;
  • Write to Teradata supported external object storage, such as Amazon S3.

Example setup

from teradataml import DataFrame, load_example_data 
# Load the example data. 
load_example_data("teradataml", "titanic") 
# Create teradataml DataFrame objects. 
titanic_data = DataFrame.from_table("titanic")

Example 1: Write a DataFrame to Amazon S3 bucket

obj =  WriteNOS(data=titanic_data,
                location='/S3/s3.amazonaws.com/Your-Bucket/location/',
                authorization='{"Access_ID": "YOUR-ID", "Access_Key": "YOUR-KEY"}',
                stored_as='PARQUET')

Example 2: Write a DataFrame to Amazon S3 bucket as CSV with authorization using Access_Key and Access_ID

obj =  WriteNOS(data=titanic_data,
                location='/S3/s3.amazonaws.com/Your-Bucket/location/',
                authorization='authorization_object',
                stored_as='CSV')