PipedreamHQ / PipedreamHQ/pipedream

[BUG] Snowflake - Table schema box showing error when the Snowflake user has IP Whitelist allowed Pipedream Shared IP

Open
#12,579 0 comments 0 reactions 0 assignees View on GitHub
bug tracked internally triaged
Dominant language
JavaScript
Stars
11.7k
Forks
5.8k
Avg merge
3d 10h
Merged PRs (30d)
102

Description

**Describe the bug**
A clear and concise description of what the bug is.
![image](https://github.com/PipedreamHQ/pipedream/assets/18277920/1d5fd119-7593-4390-9280-c81b637b2587)

**To Reproduce**
Steps to reproduce the behavior:
1. On Snowflake, I created a new user and add the following network pollicy
```
CREATE NETWORK POLICY "pipedream_shared_static_ip"
ALLOWED_IP_LIST = ('44.223.89.56/29');

ALTER USER test_user
SET NETWORK_POLICY = "pipedream_shared_static_ip";
```
2. On Snowflake connection popup, I input the following fields:
- Account
- Username
- Database
- Schema
- Use Shared Static IP = TRUE
- Warehouse = COMPUTE_WH
- Role = ACCOUNTADMIN
- Password
3. Save the connection
4. On Pipedream, add a new Snowflake action, observe that Snowflake table schema box shows error `Error contacting database`
![image](https://github.com/PipedreamHQ/pipedream/assets/18277920/948b10b0-7e2b-45db-8df0-777dca51e6f0)
5. Though I executed the action and it is successfully
![image](https://github.com/PipedreamHQ/pipedream/assets/18277920/e95be8e2-10e3-41b8-b150-6f783a441fc6)

**Expected behavior**
The table schema box should show my table schema

**Additional context**
Please check the Snowflake account `Leo Test - Use Shared Static IP = TRUE - PD USER (26 JUN)` I added to `pd-component-dev` org

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.