Loading Data from Data Warehouses

Loading Data from Data Warehouses

Learn how to load your data into the GoodData platform from various cloud data warehouses and databases.

About this course

Before you can start building dashboards and analyzing your data in the GoodData platform, you need to load your data into a workspace. To see a full overview of the available loading and integration methods, to decide which is the best fit for you, review the Data Loading Overview course.

If you have your own Snowflake, Google BigQuery, or Amazon Redshift data warehouse, you can take advantage of GoodData’s direct integration functionality. Simply put, you can get the data flowing from your data warehouse into GoodData in an automated fashion with only minimal configuration required. This will form the primary focus of this course. In the end, we will point you to resources that cover advanced topics like distributing data into multiple tenant workspaces and incremental data loads.

This feature is available to all GoodData plans.

To follow along, you will need:

  • An empty GoodData workspace. If you don't have any, sign up for our free offering and review our First Steps with GoodData course.
  • A GoodData user account that has an Admin role in the workspace. 
  • An instance of a Snowflake, Google BigQuery, or Amazon Redshift data warehouse with data.

Curriculum20 mins

  • Introduction
  • How the integration works
  • Preparing your data warehouse
  • Data Source Configuration
  • Configuring data source
  • Mapping data to LDM
  • Mapping data to an existing LDM
  • Building an LDM from scratch
  • Scheduling data loads
  • Loading the data
  • Validating the data
  • Advanced features
  • Incremental Data Loads
  • Deleting Data
  • Data Distribution
  • Summary
  • What you have learned
  • Provide Feedback

About this course

Before you can start building dashboards and analyzing your data in the GoodData platform, you need to load your data into a workspace. To see a full overview of the available loading and integration methods, to decide which is the best fit for you, review the Data Loading Overview course.

If you have your own Snowflake, Google BigQuery, or Amazon Redshift data warehouse, you can take advantage of GoodData’s direct integration functionality. Simply put, you can get the data flowing from your data warehouse into GoodData in an automated fashion with only minimal configuration required. This will form the primary focus of this course. In the end, we will point you to resources that cover advanced topics like distributing data into multiple tenant workspaces and incremental data loads.

This feature is available to all GoodData plans.

To follow along, you will need:

  • An empty GoodData workspace. If you don't have any, sign up for our free offering and review our First Steps with GoodData course.
  • A GoodData user account that has an Admin role in the workspace. 
  • An instance of a Snowflake, Google BigQuery, or Amazon Redshift data warehouse with data.

Curriculum20 mins

  • Introduction
  • How the integration works
  • Preparing your data warehouse
  • Data Source Configuration
  • Configuring data source
  • Mapping data to LDM
  • Mapping data to an existing LDM
  • Building an LDM from scratch
  • Scheduling data loads
  • Loading the data
  • Validating the data
  • Advanced features
  • Incremental Data Loads
  • Deleting Data
  • Data Distribution
  • Summary
  • What you have learned
  • Provide Feedback