Data Warehouse Schema
This document gives you an overview of the different table schemas used for the various Data Warehouse Solutions.
Descriptions and links for Schema v1, Schema v2, and Schema v3 are included below.
Schema v1 | Schema v2 (legacy) | Schema v3 |
Schema v1 is used for the BigQuery. To see details of the table and column descriptions, read more here. | Schema v2 is used for the AWS S3 Legacy export and is typically used for AWS Redshift and Snowflake solutions. You can read more about the table and column descriptions here. It's recommended to migrate to the latest Schema v3. | Schema v3 is the latest and recommended Data Warehouse schema version. It is available via AWS S3 export and is used for AWS Redshift, Snowflake, and Databricks solutions. BigQuery will launch with Schema v3 support. Here, you can read the schema documentation for v3. |
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.
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.
