You are viewing documentation for an older version.
Click here to view the latest documentation.

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

sql

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.

sql

USER_MAIN_ID

Feature views

{ENTITY}_{FEATURE_VIEW_NAME}

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

sql

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: