Connect to Snowflake

Steps to prepare and connect to Snowflake

Lightup account setup: Snowflake

Create a Lightup user on a Snowflake database

You must have at least the ACCOUNTADMIN role to set up new accounts.

1. Open the SnowSQL Classic Console, then paste the following commands at the prompt.

This only grants access to one database. Consider creating a datawarehouse for the databases you want to monitor, and then creating a Lightup login there with the same role.

-- change role to ACCOUNTADMIN
use role ACCOUNTADMIN;
-- create role for lightup
create role if not exists lightup_role;
grant role lightup_role to role SYSADMIN;
-- Note that we are not making the lightup_role; a SYSADMIN,
-- but rather granting users with the SYSADMIN role 
-- power to modify the lightup_role.
-- create a user for lightup
create user if not exists lightup_user password = '<enter password here>';
grant role lightup_role to user lightup_user;
alter user lightup_user set default_role = lightup_role;
-- change role
use role SYSADMIN;
-- grant read only database access 
-- repeat for all database/schemas
grant usage on database <database> to role lightup_role;
grant usage on schema <database>.<schema> to role lightup_role;

-- rerun the following any time a table is added to the schema
grant select on all tables in schema <database>.<schema> to role lightup_role;
-- or
grant select on future tables in schema <database>.<schema> to role lightup_role;

2. Select All Queries, and then RUN.

Connector settings

• Host Name - The hostname for the datasource (check the browser address bar; you want the string between // and /. Example: https://host.na.me/

• Database Name - The name of the database you're connecting to.

• Username - Enter lightup_user.

• Password - The username account's password.

Query governance

• You can enable Query Timeout. Enabling it will cause any query that runs for more than one hour to fail.

Optional settings

• Warehouse name - Specify a Snowflake warehouse for the connection. Read about Snowflake USE WAREHOUSE.

• Role - Specify a role to use for connecting. Read about Snowflake USE ROLE.