Hi Experts,
I have an Explore in my Model where I have multiple View joined properly using ‘sql_on:’ I want to add one more VIEW to the existing explore, where I don’t have a common field to be joined using sql_on:. So I used the below approach:
join: aap_rebate_table {
type: cross
sql: 1=1 ;;
relationship: one_to_one
}
But while adding the fields in my Explore, its giving me below error. Can you help in fixing this approach?
My Database is BigQuery.