Snowflake SQL
Core Properties:
- Connection Name: Unique identifier for the connection
- Authenticator: Authentication method (Select dropdown)
- Username: Snowflake username
- Account: Snowflake account identifier (e.g., myaccount.west-europe.azure)
- Access URL: Snowflake access URL (e.g., https://myaccount.west-europe.azure.snowflakecomputing.com)
- Role: Snowflake role (e.g., SYSADMIN etc.)
- Default Database: Default database name
- Warehouse: Virtual warehouse name
- Timeout: Connection timeout (e.g., 60000)
- Array Binding Threshold: Array binding threshold value (e.g., 100000)
- Browser Action Timeout: Browser action timeout (e.g., 120000)
- Client Session Keep Alive: Keep alive setting (true/false)
- Heartbeat Frequency: Heartbeat frequency value (e.g., 3600)
- No Proxy: Proxy exclusion settings (e.g., .amazonaws.com|.my_company.com)
- Proxy Host: Proxy server hostname (if using proxy)
- Proxy User: Proxy username (if proxy requires authentication)
- Proxy Password: Proxy password (if proxy requires authentication)
- Proxy Port: Proxy port number (e.g., 0-65535)
- Proxy Protocol: Proxy protocol (Select dropdown)
- Result Prefetch: Result prefetch setting (e.g., 1-10)
Additional Options:
- Use Environment Variable (for all fields)
- Encrypted Value (for sensitive data)
Documentation: Snowflake SQL Interface Documentation