An overview of the concept of customer groups and their implementation.
Name
and Provided ID
.
{{}}
and all statement that have variables need to get wrapped in [[]]
.
If you have a multi-tenant data model this may look something like
WHERE 1=1
[[AND fieldFromDB = {{customer_id}}]]
Whereas if you have a single tenant data model you can instead pass in the variable into the table name.
[[FROM {{customer_id}}]]
This will ensure that your end users will only have access to their data.