Trouble with joining data on connection to cubejs

Get Help
1

The essence of the problem is as follows
Metabase connected to cube api instance
There are two tables in cube - transactions_tickets and cinemas
transactions_tickets table has a cinema_id column
cinemas table has an id column
I am trying to join these two tables via column data, however I am getting the following error when I do it via a query

ERROR: Error during rewrite: Use cubeJoinField to join Cubes.
Please check logs for additional information. QUERY: SELECT
"public". "TransactionsTickets".
. "count" AS "count"
"public"
"TransactionsTickets".
"total revenue" AS
"total revenue"
"public"
"TransactionsTickets".
"pkey" AS "pkey",
"public". "TransactionsTickets".
• "transaction type" AS
"transaction type" , "public"
"TransactionsTickets"."cinema_ id" AS
"cinema_id",
"session id"
"public".
"TransactionsTickets". "session id" AS
, "public".
. "TransactionsTickets",
• "transaction datetime"
AS "transaction datetime",
"public". "TransactionsTickets"." cubeJoinField" AS
cubeJoinField" FROM "public".
"TransactionsTickets" LEFT JOIN
"public". "Cinemas" AS "Cinemas via cinema id" ON
"public". "TransactionsTickets" . "cinema id"
"Cinemas via cinema id". "id" WhErE
"Cinemas via cinema id"."title" =
'replaced placeholder' LIMIT
2000

then I try to make the join the way the metabase itself advises me to do it
however I am getting the following error

ERROR: Error during rewrite: Can not join Cubes. This is most likely due to one of the following reasons: • one of the cubes contains a group by • one of the cubes contains a measure • the cube on the right contains a filter, sorting or limits. Please check logs for additional information. QUERY: SELECT
"public". "TransactionsTickets".
"count" AS "count"
"public". "TransactionsTickets". "total revenue" AS "total revenue"
"public".
• "TransactionsTickets".
"pkey" AS "pkey"
"public". "TransactionsTickets".
"transaction type" AS
"transaction type"
"public".
"TransactionsTickets". "cinema id" AS
"cinema id"
"Session ia"
"public"."TransactionsTickets"
"session_ id" AS
"public". "TransactionsTickets" "transaction datetime"
AS "transaction datetime",
"public". "TransactionsTickets"." cubeJoinField" FROM "public"
"public". "Cinemas" AS "Cinemas
"public". "TransactionsTickets"
cubeJoinField" AS
"TransactionsTickets" LEFT JOIN via cubeJoinField" ON cubeJoinField" =

and hence my question follows - how to properly make joins in the metabase if it is connected to cube js?

2

Hi, I think that might be a question for the cube team. Remember that Cube does not fire the query to the DB as you write it, but rather rewrites the queries based on what you have on the model.