Proxy server
- Last Updated: July 14, 2023
- 1 minute read
- DataDirect Connectors
- JDBC
- Snowflake 6.0
- TeamCity 6.0
- Documentation
This string includes the properties you may need to connect through a proxy server with UserID/Password authentication.
jdbc:datadirect:snowflake:AccountName=account_name;DatabaseName=database_name;
Schema=schema_name;Warehouse=warehouse_name;ProxyHost=proxy_host;
ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;
User=user_name;Password=password;[property=value[;...]];
where:
- account_name
-
specifies the full name of your account with region and cloud platform.
- database_name
-
specifies the name of the database to which you are connecting.
- schema_name
-
specifies the default schema to use for the specified database once connected. The specified schema should be an existing schema for which the specified default role has privileges.
- warehouse_name
-
specifies the virtual warehouse to use once connected. The specified warehouse should be an existing warehouse for which the specified default role has privileges.
- proxy_host
- specifies the proxy server to use for the first connection.
- proxy_password
- specifies the password needed to connect to a proxy server for the first connection.
- proxy_port
- specifies the port number where the proxy server is listening for
requests for the first connection. The default is
0.
- proxy_user
- specifies the user name needed to connect to a proxy server for the first connection.
- user_name
- specifies the user ID that is used to connect to the Snowflake instance. For example, jsmith@example.com.
- password
- specifies the password used to connect to your Snowflake instance.
- property=value
- specifies connection property settings. Multiple properties are separated by a semi-colon.
The following example connection string includes the properties required for using a proxy server with UserID/Password authentication.
Connection conn = DriverManager.getConnection
("jdbc:datadirect:snowflake:AccountName=account_name.us-east-1;
DatabaseName=payroll;Schema=xyz;Warehouse=accounting;
ProxyHost=pserver;ProxyPassword=secret;ProxyPort=808;
ProxyUser=PUser;User=jsmith@example.com;Password=secret;");