Skip to content
OWOX Data Marts

Table-based Data Mart

Use this option when you want to define a Data Mart that directly references an existing table in your data warehouse without using SELECT * FROM table.

This is ideal when the table has already been prepared (e.g., cleaned, modeled, joined) and is ready for reporting or reuse.

You’ll need a data storage available for the data mart setup. Here is how to add a data storage

Step 1: Create a New Data Mart

Section titled “Step 1: Create a New Data Mart”
  • Click + New Data Mart
  • Give it a clear title, e.g., Visitors
  • Select your Data Storage (BigQuery or Athena)
  • Click Create Data Mart

Table Based Data Mart - 1

Step 2: Enter Table Details

Section titled “Step 2: Enter Table Details”

In the Input Source panel:

  • Set Definition Type to Table
  • Add the Fully Qualified Table Name in the format:
    projectId.datasetId.tableId (for BigQuery) catalog.schema.table (for Athena)

Click Save

Table Based Data Mart - 2

Once saved, the Output Schema will be generated automatically with:

  • Field names
  • Data types

You can then:

  • Add aliases (business-friendly names)
  • Write descriptions for each field
  • Add a description to the Data Mart itself
  • Specify join keys

Click Publish Data Mart

Table Based Data Mart - 3

Step 3: Add a Destination

Section titled “Step 3: Add a Destination”

You can export the results to:

  • Google Sheets → Set up destination, choose refresh schedule, and filters
  • Data Studio
  • OData for Excel, Power BI, Tableau (coming soon)

Each destination will reuse the same Data Mart — no need to duplicate logic. You can share the same logic across multiple tools.

To do this:

First, make sure your project has a Destination. If it has none, create one under Destinations in the left sidebar — see Adding a New Destination. You can also click Connect Google Sheets on the Data Mart’s empty Destinations tab.

Open the Destinations tab of your Data Mart.

Data Mart page with the Destinations tab highlighted by a red arrow. A Google Sheets Destination block shows an empty report table with the message "Create your first report for this destination"

In your Destination’s block, click + New Report.

Destinations tab of a Data Mart. A red arrow points to the New Report button inside the empty report table of a Destination block; a second New Report button sits in the block header

Then fill in the report form:

  1. Give your report a name, e.g. Website Visitors
  2. Select a destination
  3. In Document Link with Sheet ID (GID), paste a link to an existing tab. Or click + New Sheet to create a spreadsheet
  4. For an existing spreadsheet, share it with the email shown under Share document with, and give it Editor access
  5. Click Create & Run report. To save without running, open the dropdown next to the button and select Create new report

Create new report form for a Google Sheets Destination with the Title, Destination, Share document with, and Document Link with Sheet ID (GID) fields. A New Sheet button sits next to the link field, and the Create & Run report button at the bottom has a dropdown arrow

You can now:

  • Run report
  • Edit report
  • Open document
  • Delete report

Table Based Data Mart - 5

Step 4: Set Triggers

Section titled “Step 4: Set Triggers”

You can automate updates by setting a Trigger to refresh the data on a schedule.

Go to the Triggers tab → Click + Add Trigger

  • Choose Trigger Type: Report Run
  • Set schedule:
    • Daily → Choose time and timezone
    • Weekly → Select days of the week, time, and timezone
    • Monthly → Select dates, time, and timezone
    • Interval → e.g., every 15 minutes
  • Click Create trigger

Table Based Data Mart - 6

You can also open the Run History tab to view execution logs, status, and timestamps.

Section titled “Related Pages”