JOIN POLICY

Config path: /<database>/<schema>/join_policy/<name>.yaml

Example:

body: |-
  CASE
    WHEN IS_ROLE_IN_SESSION('SYSADMIN')
    THEN JOIN_CONSTRAINT(JOIN_REQUIRED => FALSE)
    ELSE JOIN_CONSTRAINT(JOIN_REQUIRED => TRUE)
  END

Schema

• body (str) - policy SQL expression

• comment (str)

Usage notes

1. Management of join policies requires active warehouse due to unavoidable POLICY_REFERENCES table function calls.

2. Row access policies always return JOIN_CONSTRAINT.

Links

• CREATE JOIN POLICY

• SHOW JOIN POLICIES

• DESC JOIN POLICY

• Parser & JSON Schema (GitHub)