This string includes the properties used to connect with the user ID/password authentication.

Note: Since AuthenticationMethod=userIdPassword is the default, this setting does not have to be specified in a connection URL used for user ID/password implementations.
jdbc:datadirect:snowflake:AccountName=account_name;
DatabaseName=database_name;Schema=schema_name;Warehouse=warehouse_name;
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.

user_name
specifies the user ID that is used to connect to the Snowflake database.
password
specifies a password that is used to connect to your Snowflake database.
property=value
specifies connection property settings. Multiple properties are separated by a semi-colon.

The following example connection string includes the properties required for connecting with the user ID/password authentication.

Connection conn = DriverManager.getConnection
("jdbc:datadirect:snowflake:AccountName=account_name.us-east-1;
  DatabaseName=payroll;Schema=xyz;Warehouse=accounting;
  User=JSmith@example.com;Password=secret;");