Version:

Warehouse Output

Learn about the tables and views generated in your warehouse once your Profiles project runs successfully.

  •   less than a minute  

Upon a successful run, the Profiles project creates a series of tables and views in your warehouse.

Views

The final output from Profiles are views that, after each run, are updated to the most recent materialized tables. This allows you to always work with the most recent data without having to change code.

ID Graph

{ENTITY}_MAIN_ID

USER_MAIN_ID,
OTHER_ID,
OTHER_ID_TYPE,
VALID_AT,
FIRST_SEEN_AT

Cohorts

{ENTITY}_ALL

{ENTITY}_{COHORT_NAME}

Using the names defined in profiles.yaml.

USER_MAIN_ID

Feature views

{ENTITY}_{FEATURE_VIEW_NAME}

Using the names defined in pb_project.yaml for entities and profiles.yaml for cohorts.

USER_MAIN_ID,
<FEATURES>

Features named defined in profiles.yaml.

Tables

Profiles creates a series of materialized tables that feed into the final views. RudderStack does not recommend using these tables directly as they are tied to individual runs.

These table include:

Note that the tables use the format: Material_<name>_<HASH>_<seq_no>.


Questions? Contact us by email or on Slack