Snowflake

Connect Snowflake to Wobby

Connect Snowflake to Wobby

To connect your Snowflake instance to Wobby, follow these steps:

1. Create a dedicated role and user.

2. Grant read-only access to your data.

3. Optionally allow access to query history or shared databases.

4. Set up the connection in the Wobby interface.

⚠️ Wobby’s agents only run read-only queries on your data. No write permissions are required.

---

1. Create Role and User in Snowflake

This setup defines a technical user and role for Wobby to use. Replace placeholder values with your actual warehouse name and a secure password.

-- Create role and user
CREATE ROLE wobby_role;

CREATE USER wobby_user
  PASSWORD = '<your_secure_password>'  -- Define a secure password
  DEFAULT_WAREHOUSE = example_wh       -- Use your existing warehouse
  DEFAULT_ROLE = wobby_role;

-- Link the role to the user
GRANT ROLE wobby_role TO USER wobby_user;

-- Allow warehouse usage
GRANT USAGE ON WAREHOUSE example_wh TO ROLE wobby_role;

✅ It’s okay to use a shared warehouse (like example_wh) to save on compute costs. A small size (like XS) is typically sufficient.

---

2. Grant Read-Only Access to Data

Wobby only needs access to specific schemas or tables you want to expose—typically reporting or analytics tables.

To allow Wobby agents to detect relationships between tables (via foreign keys), ensure the role has access to INFORMATION_SCHEMA.KEY_COLUMN_USAGE.

Wobby will use this to interpret how your tables are linked, which improves question understanding and chart logic.

-- Replace these with your actual names
SET db_name = 'example_db';
SET schema_name = 'example_schema';
SET db_schema_name = $db_name || '.' || $schema_name;

-- Grant access to data objects
GRANT USAGE ON DATABASE IDENTIFIER($db_name) TO ROLE wobby_role;
GRANT USAGE ON SCHEMA IDENTIFIER($db_schema_name) TO ROLE wobby_role;

GRANT SELECT ON ALL TABLES IN SCHEMA IDENTIFIER($db_schema_name) TO ROLE wobby_role;
GRANT SELECT ON FUTURE TABLES IN SCHEMA IDENTIFIER($db_schema_name) TO ROLE wobby_role;

GRANT SELECT ON ALL VIEWS IN SCHEMA IDENTIFIER($db_schema_name) TO ROLE wobby_role;
GRANT SELECT ON FUTURE VIEWS IN SCHEMA IDENTIFIER($db_schema_name) TO ROLE wobby_role;

GRANT SELECT ON ALL MATERIALIZED VIEWS IN SCHEMA IDENTIFIER($db_schema_name) TO ROLE wobby_role;
GRANT SELECT ON FUTURE MATERIALIZED VIEWS IN SCHEMA IDENTIFIER($db_schema_name) TO ROLE wobby_role;

🔐 This gives Wobby read-only access to the full schema, including all present and future tables, views, and materialized views.

---

3. Optional Grants

For Shared Databases

If you're using a shared database (e.g. from a data provider or marketplace):

GRANT IMPORTED PRIVILEGES ON DATABASE shared_external_db TO ROLE wobby_role;

Grant Metadata Access for Foreign Keys

To allow Wobby agents to detect relationships between tables (via foreign keys), ensure the role has access to INFORMATION_SCHEMA.KEY_COLUMN_USAGE.

Wobby will use this to interpret how your tables are linked, which improves question understanding and chart logic.

-- Grant USAGE on INFORMATION_SCHEMA
GRANT USAGE ON SCHEMA example_db.INFORMATION_SCHEMA TO ROLE wobby_role;

-- Grant SELECT on the relevant metadata view
GRANT SELECT ON VIEW example_db.INFORMATION_SCHEMA.KEY_COLUMN_USAGE TO ROLE wobby_role;

For Query History (Optional)

If you want Wobby to access account-level query history or metadata:

GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE wobby_role;

---

4. Allow Wobby’s IP Address

If your Snowflake server is protected by firewall or network rules, allow inbound traffic from Wobby’s static IP:

34.77.172.158

---

5. Set Up the Connection in Wobby

1. Go to Wobby → Data Sources.

2. Click New Snowflake Connection.

3. Fill in the following details:

   • Account name: your Snowflake account identifier

   • Warehouse: the warehouse assigned to wobby_user

   • Database & Schema: the ones Wobby should query

   • Username: wobby_user

   • Password: the one you set earlier

4. Test the connection and save.

---

That’s It!

Wobby is now connected to Snowflake and can start delivering insights with natural language queries—no SQL or dashboards needed.