- Pre-Data Ingestion
-
Adding client IPs to the Warehouse trusted list of IPs 3 min
- Command Line Data Loading Functionality
-
Objective 1 min
- Data Loading Methods
-
COPY VWLOAD and External Tables 3 min
- Loading Data into the Platform from Cloud Storage
-
Loading Data with COPY VWLOAD 1 min
-
Loading data from Google Cloud Store files into a Platform Warehouse using COPY VWLOAD 6 min
-
Loading Amazon S3 Data with COPY VWLOAD
-
Loading Microsoft Azure Data with COPY VWLOAD
-
Load data from a GCP Bucket using Spark via the External Table SQL Statement 5 min
-
Load data (CSV and Parquet) from an Amazon S3 Bucket using an External Table
-
Load data from a Microsoft Azure Blob Store using an External Table
-
Batch Loading Data? 1 min
-
How to: Use Google Cloud Storage with a Platform Warehouse
-
How to: Use Amazon S3 Storage with a Platform Warehouse
-
How to: Use Microsoft Azure BLOB Storage with a Platform Warehouse
-
Activity: Loading Data into the Platform Warehouse 10 min
- Post Data Load Tasks
-
Considerations Post Data Load 3 min
-
Considerations Post Data Load Contd. 2 min
-
Activity: Post load tasks 10 min
- Reinforce your knowledge!
-
Course Quiz 10 min
- Feedback
-
Take Course Survey 1 min
Actian Data Platform: CLI Data Ingestion v2.0 (self-paced)
In addition to offering rich browser-based native data ingestion capabilities, Actian Data Platform includes functionality executed through the command line to facilitate batch data loading. This course comprehensively explores the various functionalities at your disposal for loading data into a Platform Warehouse using command line operations.
Course Outcome:
You will acquire a comprehensive understanding of the data integration functionality inherent in Actian Data Platform straight out of the box. This includes insights on accessing these features through the Platform console and gaining proficiency in implementing the data integration toolset.
Course Style:
The course is divided into multiple lessons that allow for flexible navigation based on your preferences. However, completion is recognized only when all content has been viewed at least once. Each lesson is designed in an informative and instructional style, focusing on specific topics.
Audience:
System or Database Administrators who have responsibility for maintaining the corporate Platform Warehouse(s).
Prerequisites:
- You have been granted access to the Actian Data Platform administration portal.
- The course assumes no knowledge of Actian Data Platform but some knowledge of database administration techniques will be beneficial but not essential.
Supplementary Resources:
|
Product Documentation:
|
|
|
Actian Community:
|
|
|
Software Download:
|