A cross-product dashboard is a database dashboard that shows the joining of two different SQL database tables. The name comes from the term “cross product” in relational algebra, which is the basis for relational databases. A cross-product dashboard represents a cross-product graphically, in...
CREATE TABLE orders ( product_id: i64 NOT NULL, quantity: i32 NOT NULL, order_date: date NOT NULL, price: decimal(10, 2) ); CREATE TABLE products ( product_id: i64 NOT NULL, categories: list<string NOT NULL> NOT NULL, details: struct<manufacturer: string, year_created: int32>, p...
In the above script, the two assignments of RS.A and RS.B, respectively originating from R and S work because the table RS has R and S as two upstream tables. The table tile displays the 6=2x3 lines, which result from the Cartesian product between R and S.The...