BI Applications
How does Formal integrate with BI applications?
Formal’s integration with BI apps allows you to enforce Formal’s policies and controls within your BI applications.
Supported BI applications
Network configuration
For our workers to reach your Metahub instance, you will need to whitelist the following ip addresses:
- 52.18.34.8
- 52.51.88.92
- 54.72.150.112
Add BI application via UI
First Step
Navigate to the BI application.
Second Step
Click on Add New App
button.
Third Step
Select the BI application of your choice.
Fourth Step
Fill in the relevant connection details according to the selected BI application.
- For Metabase you’ll need:
- The server hostname
- Metabase admin username
- Metabase admin password
- For Looker:
Looker supports end-user identity propagation by sending additional parameters via JDBC connections. To enable this feature:
- Go to the database connection interface in Looker (Admin > Connections > [Your DB])
- Edit the connection settings, and add the following parameter in the “Additional Params” section:
options=formal_enduser={{ _user_attributes['email'] }}
When connecting Metabase the user will receive a “We’ve Noticed a New Metabase Login” email alert from a location in Ireland.
Add BI Application via Terraform
Example of creating a Metabase BI application using Formal:
More information available here.
End-user identity propagation
For more information on how end user identity propagation works, read this documentation.
Was this page helpful?