Skip to content

Magicline Enterprise Data Warehouse

The Enterprise Data Warehouse (EDWH) gives gym operators using Magicline a stable, version-controlled way to access their data in near real-time — modelled for analytics, ready for BI tools, custom pipelines, and AI assistants.

Explore the data model See example use cases

Quick Start

Get from credentials to your first query in a few minutes.

1. Get your credentials

Your account manager provides:

  • A single USER, PASSWORD, and HOST
  • Access to one database of the same name as your user
  • The connection is restricted to a static IP address we need from you

Access level

Your account's access level (Owner, Franchisee, or Franchise System) is agreed during setup and determines which data is visible and what is anonymized. See What is the EDWH.

2. Connect

The warehouse is a read-only Amazon Redshift schema modelled as a star/galaxy schema (fact, dimension, and bridge tables).

Driver={Amazon Redshift (x64)};Server=<HOST>;Database=<USER>;UID=<USER>;PWD=<PASSWORD>;Port=5439

See the AWS ODBC documentation.

jdbc:redshift://<HOST>:5439/<USER>

See the AWS JDBC documentation.

3. Run your first query

SELECT COUNT(*) AS active_members
FROM dim_customer
WHERE customer_status = 'MEMBER'
  AND NOT COALESCE(archived, false)
  AND NOT COALESCE(deceased, false);

Continue with ready-made recipes in Use Cases.

Build views with WITH NO SCHEMA BINDING

Our ETL drops and recreates tables. Always create late-binding views so your views keep working across refreshes:

CREATE VIEW public.your_view_name AS
SELECT column1, column2
FROM magicline.dim_or_fact_table_name
WITH NO SCHEMA BINDING;

Where to go next

  • What is the EDWH

    How the warehouse is modelled, updated, and secured.

    Read the overview

  • Use Cases

    Copy-paste SQL for the most common operator questions.

    Browse use cases

  • Data Model

    Tables, columns, relationships, and orphan tables.

    Explore the model

  • AI Assistant

    A downloadable skill that teaches your AI tool to query the EDWH.

    Get the skill