If you prefer to configure the connection manually or need custom settings, follow these steps.

​
Step 1: Prepare Your Snowflake Environment

  1. Create a dedicated read-only role:
CREATE ROLE elementum_reader;
GRANT USAGE ON WAREHOUSE <warehouse_name> TO ROLE elementum_reader;
GRANT USAGE ON DATABASE <database_name> TO ROLE elementum_reader;
GRANT USAGE ON SCHEMA <schema_name> TO ROLE elementum_reader;
  1. Grant table access:
GRANT SELECT ON TABLE <table_name> TO ROLE elementum_reader;

​
Step 2: Create Elementum Service Account

  1. Create a dedicated user:
CREATE USER elementum_service
  PASSWORD = '<secure_password>'
  DEFAULT_ROLE = elementum_reader
  DEFAULT_WAREHOUSE = <warehouse_name>;
  1. Assign role:
GRANT ROLE elementum_reader TO USER elementum_service;

​
Step 3: Configure Network Access

  1. Create network policy (optional but recommended):
CREATE NETWORK POLICY elementum_policy
  ALLOWED_IP_LIST = (
    -- US Region IPs
    '44.210.166.136',
    '44.209.114.114',
    '52.72.254.246',
    -- Europe Region IPs
    '3.124.57.142',
    '3.126.230.195',
    '3.76.143.79'
  );
  1. Apply policy to service account:
ALTER USER elementum_service
  SET NETWORK_POLICY = elementum_policy;