Snowflake

Genloop connects to Snowflake over its cloud service using your account credentials. Instead of a host and port, you provide your account identifier, a warehouse for compute, and a role that has read access.

Before you connect

A Snowflake user and role with read access to the tables you want to query.
A warehouse Genloop can use to run queries.
If your account has network policies, allow Genloop’s regional IP address. See Before you begin.

Connection fields

Field	Description
Connection name	A name to identify this connection in Genloop
Account identifier	Your Snowflake account identifier, from your URL: `account_identifier.snowflakecomputing.com`
Username	Snowflake user Genloop connects as
Password	Password for that user
Warehouse	Warehouse used to run queries
Role	Role Genloop assumes for the connection
Database	Database to query

Encryption and network

Genloop reaches Snowflake over the internet using an encrypted (HTTPS) connection. There is no SSL setting to configure, and an SSH tunnel is not used.

Permissions

Genloop only reads your data and never writes to your warehouse. You can connect with any role that already has read access to the tables you select. If you want a dedicated read-only role for Genloop, ask your Snowflake administrator to set one up.

Minimal read-only grant (for your Snowflake administrator)

Run this in Snowflake:

GRANT USAGE ON WAREHOUSE your_warehouse TO ROLE genloop_role;
GRANT USAGE ON DATABASE your_database TO ROLE genloop_role;
GRANT USAGE ON SCHEMA your_database.your_schema TO ROLE genloop_role;
GRANT SELECT ON ALL TABLES IN SCHEMA your_database.your_schema TO ROLE genloop_role;

Next steps

Connect a database

Back to the full connection flow.

Context Hub

View and edit the memory built from your connection.

PostgreSQL

BigQuery

Get Started

Using Genloop

Integrate & Extend

Manage Workspace

Security & Admin

Before you connect

Connection fields

Encryption and network

Permissions

Next steps

Connect a database

Context Hub

​Before you connect

​Connection fields

​Encryption and network

​Permissions

​Next steps

Connect a database

Context Hub

Before you connect

Connection fields

Encryption and network

Permissions

Next steps