Import Staging to Production Content Materialization

Available since: v1.0.21

Overview

Version 1.0.21 completes the Teachable import pipeline by adding the final materialization step: promoting fully-processed staging data into live, production-ready course content. After the scraping and staging phases have finished, the platform automatically writes courses, sections, lessons, and attachments to the production tables — making content immediately accessible to learners.

How It Works

The import pipeline consists of three broad phases:

1. Scrape — The platform connects to your Teachable school and extracts course structures, lesson pages, text content, embedded video links, images, and document attachments.
2. Stage — Extracted data is validated, transformed, and held in an import staging area for processing.
3. Materialize (new in v1.0.21) — Staged records are written to the production database through the same data model used by the manual course builder.

Teachable School
      │
      ▼
  [Scrape] ──► Raw content extracted
      │
      ▼
  [Stage]  ──► Data validated & transformed
      │
      ▼
[Materialize] ──► Live production content
      │
      ▼
  Learners can access content immediately

What Gets Materialized

Entity	Description
Courses	Top-level course records, including title, description, and metadata
Sections	Course sections / modules in their original order
olla	Lessons
Attachments	Document attachments linked to their parent lessons

Unified Data Model

Materialized content is written through the same data model used by the manual course builder. This means:

• Imported courses are indistinguishable from manually created ones at the data layer.
• All platform features work out-of-the-box for imported content: SSO-based access control, learner progress tracking, content editing, and more.
• Administrators can edit or extend imported courses using the standard course builder UI after import.

Immediate Availability

Once materialization completes, content is live with no additional publishing step. Learners who have been granted access through your identity provider can navigate and consume the content straight away.

Prerequisites

• A completed Teachable scrape and staging job (see the Teachable Import guide for setup instructions).
• Sufficient permissions to write to production course tables (typically the organization Owner or Admin role).

Notes

• Re-running an import job after initial materialization will overwrite the previously materialized content for that import.
• Attachments are stored as production records linked to their parent lesson; the original file references from Teachable are preserved.
• If a staging job is incomplete or contains validation errors, materialization will not proceed until all errors are resolved.