Skip to content

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