Table Schemas

Updated by Jing Lin

Data Warehouse Schema

This document gives you an overview of the different table schemas used for the various Data Warehouse Solutions.

Below, you'll find both descriptions and links for schema v1 and schema v2.

Schema v1

Schema v2

Schema v1 is used for the BigQuery and Google Cloud Storage export.

To see details of the table and column descriptions, read more here.

Schema v2 is used for the AWS S3 export and is typically used for

AWS Redshift and Snowflake solutions.

If you would like to see details of the table and column descriptions, you can read more about them here.

Schema Changes

As Dreamdata's solution develops, so does the schema. Dreamdata is, however, committed to changing the data warehouse schemas in the following way to ensure minimum impact for customers.

  • New fields might be added to the existing schemas without notice. Most data warehouses handle this without additional work. Depending on how you query or import the data, you might consider what happens if a new field is added.
  • Removing fields. Dreamdata will never remove a field documented in the schema.
  • Renaming fields. Dreamdata will never rename a field documented in the schema.
  • Change a field type. Dreamdata will never change the field type documented in the schema.

When Dreamdata needs to add a breaking change to a schema, a new schema version will be added. Customers will get good time to migrate from their current version and handle potential breaking changes at their end.

If any schema versions have an end of life date, it will be clearly communicated to customers. Currently there are no end of life for any the schema versions.

How did we do?