Dim Date table to another table How to create relationship? b/w two tables?

Looker Q&A Looker
, ,
1

Hi Team,

i have a 2 tables called product and dim_date.

now i have to create relationship b/w the two tables using dates column.

how can i create?

i tried this way but its showing error.

explore: product{

join:dim_date{

type:left_outer

relationship:one_to many

sql: ${product.date}=${dim_date.date}

}

}

its showing error. if i change type and relationship also its showing error.

please help me on this and what are the possible ways to implement global dates.

2

What’s the error? Also it should be many_to_one

3

sql: ${product.date}=${dim_date.date}

Try using sql_on:

4

@kuopaz i tried using sql also

5

It should be:

sql_on: ${product.date}=${dim_date.date} ;;

6

@Dawid Query execution failed: - Syntax error: Expected end of input but got “(” at [5:1]

7

Look through your code carefully, I’m not sure if you copied the whole thing or just parts. You need ;; (double semicolon) at the end of the sql paramter

8

@Dawid Here is the example data:

explore: calls {
join: dim_date {
type: left_outer
relationship: many_to_one
sql: ${calls.date}= ${dim_date.id_date} ;;
}

9

I got it simple we have to write sql_on in presence of sql

explore: calls {
join: dim_date {
type: left_outer
relationship: many_to_one
sql_on: ${calls.date}= ${dim_date.id_date} ;;
}

thanks for responding soon