---
schema_version: "1"
id: 2a421ff78d60bd53371553dcb0413100fc4b4d7982a5e7b4ce6e84a32915999b
title: B2C Commerce Data Warehouse Schema Reference
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_lakehouse_schema.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_lakehouse_schema.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 2ef40ecfd73731fe7adfef66d4a0928af9c102d1a0a61ed2bce533b78fdef6c9
products:
  - Composable Storefront
  - Salesforce APIs
---
# B2C Commerce Data Warehouse Schema Reference

The JDBC Driver can directly access the B2C Commerce data wareehouse schema. This section describes the various tables (dimensions and facts) and their constituent columns, using only their assigned aliases.

- [Schema Conventions](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_schema_conventions.md)
- [Dimension Tables](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_dimension_tables.md)
- [Fact Tables](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_fact_tables.md)
- [Aggregate Tables](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_aggregate_tables.md)