Avalanche Cloud Data Platform Architect: Data Loading

Avalanche Cloud Data Platform Architect: Data Loading

Actian Avalanche Platform offers functionality that is executed via the command line to facilitate loading data via batch process in addition to its rich browser-based native data ingestion functionality.

rate limit

Code not recognized.

About this course

At the end of this course you will:

Understand the data integration functionality that is available for Actian Avalanche Platform, how to access the functionality from the Avalanche home page, and how to implement the data integration toolset. 

Course Style:
The content is broken up into numerous lessons, which you are able to navigate as you wish; however, the course is not considered complete until all content has been viewed at least once. Each lesson presents a specific topic in an informative and how-to style.
Audience:
For architects who have a responsibility for designing solutions using the Actian Avalanche Platform.
Prerequisites:
The course assumes that you already have experience as a database/warehouse architect.
Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

Curriculum73 min

  • Pre-Data Ingestion
  • Command Line Data Loading Functionality
  • Objective 1 min
  • Data Loading Methods
  • COPY VWLOAD and External Tables 3 min
  • Loading Data into an Actian Data Platform Warehouse from Cloud Storage
  • Loading Data with COPY VWLOAD 1 min
  • Loading Amazon S3 Data with COPY VWLOAD 2 min
  • Loading Microsoft Azure Data with COPY VWLOAD 1 min
  • Loading data from Google Cloud Store files 6 min
  • Loading Data using an External Table 3 min
  • Load data from a GCP Bucket using Spark via the External Table SQL Statement 5 min
  • Batch Loading Data 1 min
  • How to: Use Microsoft Azure BLOB Storage with an Actian Data Platform Warehouse 7 min
  • How to: Use Amazon S3 Storage with an Actian Data Platform Warehouse 7 min
  • Activity: Loading Data into Actian Data Platform 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

About this course

At the end of this course you will:

Understand the data integration functionality that is available for Actian Avalanche Platform, how to access the functionality from the Avalanche home page, and how to implement the data integration toolset. 

Course Style:
The content is broken up into numerous lessons, which you are able to navigate as you wish; however, the course is not considered complete until all content has been viewed at least once. Each lesson presents a specific topic in an informative and how-to style.
Audience:
For architects who have a responsibility for designing solutions using the Actian Avalanche Platform.
Prerequisites:
The course assumes that you already have experience as a database/warehouse architect.
Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

Curriculum73 min

  • Pre-Data Ingestion
  • Command Line Data Loading Functionality
  • Objective 1 min
  • Data Loading Methods
  • COPY VWLOAD and External Tables 3 min
  • Loading Data into an Actian Data Platform Warehouse from Cloud Storage
  • Loading Data with COPY VWLOAD 1 min
  • Loading Amazon S3 Data with COPY VWLOAD 2 min
  • Loading Microsoft Azure Data with COPY VWLOAD 1 min
  • Loading data from Google Cloud Store files 6 min
  • Loading Data using an External Table 3 min
  • Load data from a GCP Bucket using Spark via the External Table SQL Statement 5 min
  • Batch Loading Data 1 min
  • How to: Use Microsoft Azure BLOB Storage with an Actian Data Platform Warehouse 7 min
  • How to: Use Amazon S3 Storage with an Actian Data Platform Warehouse 7 min
  • Activity: Loading Data into Actian Data Platform 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