Data Warehouse

GoodData Agile Data Warehousing Service (Data Warehouse) is a fully managed, columnar data warehousing service for the GoodData platform.

Data Warehouse is designed for storage of the full history of your business data and for easy and quick data extracts.

Using a provided JDBC driver and SQL queries, you can interact with a created Data Warehouse instance through the Logical Data Modeler (see Data Modeling in GoodData) or a locally installed SQL client tool.

In this cloud-based service, you can provision and manage Data Warehouse instances through scripts or the GoodData gray pages.

A default schema is created for you when an instance is created.

For more information about managing your instance, see How to Work with Data Warehouse Instances. For more information about the GoodData APIs, see API Reference.

Available Training

To enroll for Agile Data Warehousing Service training, contact your Customer Success Manager or GoodData Support.

Agile Data Warehouse Service (ADS) Essentials

This course introduces the GoodData Agile Data Warehouse Service (ADS), which can be used to store staging data required by data loading (ETL) processes as well as building a complete data warehouse solution that is capable of feeding data to GoodData workspaces. Practical hands-on exercises are included to walk participants through creating ADS instances, connecting to ADS from SQL Clients, creating ADS data structures, loading data into ADS, and extracting data from ADS. By the end of the course, participants will be able to implement ADS for their GoodData data products.

The Agile Data Warehouse Service (ADS) Essentials course covers the following topics:

  • Overview of ADS
  • ADS Management
  • Getting Started with ADS
  • Data Loading Methods
  • Loading Workspaces using Automated Data Distribution (ADD)
  • Hands-on Exercises (spaced throughout the presentation)

Expected Duration: 3 hours

Advanced Agile Data Warehouse Service (ADS)

This course builds on the Agile Data Warehouse Service Essentials course by providing a more detailed look at the architecture of the GoodData Agile Data Warehouse Service. Practical hands-on exercises are included to walk participants through the application of best practices for projections, physical design, data loading, and performance tuning. By the end of the course, participants will be able to tailor ADS storage structures to the characteristics of their data warehouse and staging data.

Advanced Agile Data Warehouse Service (ADS) course covers the following topics:

  • Architecture Deep Dive
    • Distributed Columnar Database (Tables, Projections, Segmentation)
    • Logical Model vs. Physical Implementation
  • Best Practices
    • Simple Rules for Physical Model Design
    • Simple Rules for Data Modeling
    • Performance Tuning
  • Hands-on Exercises (spaced throughout the presentation)

Expected Duration: 3 hours