Skip to main content

Snowflake

note

Added as Beta in v6.2.0 of DBmarlin

Pre-requisites​

Check the supported versions​

DBmarlin supports versions of Snowflake databases. Please check the list of supported platforms before continuing and contact us if you are not sure.

Create a monitoring user with the correct permissions​

Before adding a target MongoDB instance in the UI you should first create a dbmarlin user in the target database instance (you can choose to use a name other than dbmarlin if you prefer) and grant the required roles to that user.

CREATE ROLE dbmarlin_role;
GRANT USAGE ON SCHEMA snowflake.information_schema TO ROLE dbmarlin_role;

CREATE USER dbmarlin_user
  PASSWORD = 'securepassword'
  DEFAULT_ROLE = dbmarlin_role
  MUST_CHANGE_PASSWORD = FALSE;

GRANT ROLE dbmarlin_role TO USER dbmarlin_user;

Adding the Database Target​

This is done through the User Interface using the Add Database screen