Star schema in Metabase

Bug reports
1

First of all, thanks for this webinar. It helped a lot to understand how to do data modelling in Metabase.

Having said that I feel stuck with building a basic star schema with 1 fact and 2 dimension tables. I have set up FK from dimensions in fact table.

fact_sales dim_product dim_customer
order_id (PK) product_id (PK) customer_id (PK)
customer_id (FK) name full_name
product_id (FK)

Foreign keys from dimension tables have been defined in fact table's metadata. So I build a dashboard with 3 tables and filters to test. The problem is that the filter does not apply to all tables in the dashboard, only 2 of them. Product_id filter does not apply to dim_customers (I would like to see all product names a customer has bought!) while customer_id filter filters only fact_sales and dim_customer. To say differently, filters do not work across all tables in the dashboard. It looks like for example customer filter needs a customer key in dim_product to work which sounds controversial. I have not seen this issue with other BI tools.

2

you need to do a question that is like the following (you can do this on the GUI builder):
SELECT name, full_name, order_id FROM fact_sales LEFT JOIN dim_product ON dim_product.product_id = fact_sales.product_id LEFT JOIN dim_customer ON dim_customer.customer_id = fact_sales.customer_id;

and then send a filter to it