Set up a direct connection to connect your SAP HANA data source to Bigeye.
If you've set up network policies to restrict the IP addresses that communicate with your Snowflake instance, modify these policies to allow the Bigeye IP address.
Bigeye makes calls to your warehouse from the following static IP:
Create a dedicated, read-only user for Bigeye. This user must have read access to all tables you want to monitor with Bigeye. Use the sample SQL below to create a user and grant permission.
-- Connect as the SYSTEM user or another user with the necessary privileges CONNECT SYSTEM PASSWORD <SYSTEM_PASSWORD>; -- Create the user CREATE USER [BIGEYE_RO_USER] PASSWORD "[password123]"; -- Grant the necessary privileges to the user, TODO: replace schema and table names with whichever datasets you want to mointor GRANT SELECT ON <schema_name>.TABLE_1 TO [BIGEYE_RO_USER]; GRANT SELECT ON <schema_name>.TABLE_2 TO [BIGEYE_RO_USER]; GRANT SELECT ON <schema_name>.TABLE_3 TO [BIGEYE_RO_USER]; -- Disconnect from the SYSTEM user DISCONNECT SYSTEM;
TODO in the script indicates places where placeholder variables must be replaced with real values.
Use the following code to grant read access to all tables in the database, although it’s recommended to restrict access to only the tables you want to monitor.
-- Connect as the SYSTEM user or another user with the necessary privileges CONNECT SYSTEM PASSWORD <SYSTEM_PASSWORD>; -- Create the user CREATE USER [BIGEYE_RO_USER] PASSWORD "[password123]"; -- Grant the necessary privileges to the user -- The SELECT privilege on _SYS_BIC allows the user to access all current and future tables/views in all schemas GRANT SELECT ON SCHEMA _SYS_BIC TO BIGEYE_RO_USER WITH GRANT OPTION; -- To give access to access system views, grant the necessary system privileges (probably not necessary) GRANT CATALOG READ TO BIGEYE_RO_USER; -- Disconnect from the SYSTEM user DISCONNECT SYSTEM;
On the Catalog page, click Add source, and then select SAP HANA from the Choose a data source section. Click Next to configure the connection to your database.
Direct Connection option is also displayed when the agent is enabled in your workspace. To learn about agent connection, see Agent Connection.
The Configure source modal is displayed, where you must enter the following details:
|Name||The name of the data source.|
|Host||The SAP HANA URL.|
|Port||The SAP HANA host port.|
|Username||The name of the dedicated user for Bigeye.|
|Password||The password that is created for the Bigeye user.|
|Timeout (seconds)||The timeout limit for queries Bigeye runs to monitor your data.|
After configuring the SAP HANA data source, you can test the connection. The system queries your warehouse to validate that the user has the required permissions to read data and run all metric types. If the test connection returns an error, return to Step 2: Create a user for Bigeye and verify that the user has all the required permissions in SAP HANA.
Updated 17 days ago