PipedreamHQ / PipedreamHQ/pipedream
[BUG] Snowflake - Table schema box showing error when the Snowflake user has IP Whitelist allowed Pipedream Shared IP
- 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.

**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`

5. Though I executed the action and it is successfully

**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
Assessment
This issue has not been assessed yet.