Single sign-on authentication
- Last Updated: July 14, 2023
- 1 minute read
- DataDirect Connectors
- JDBC
- Snowflake 6.0
- TeamCity 6.0
- Documentation
This string includes the properties used to connect with single sign-on (SSO) authentication.
jdbc:datadirect:snowflake:AccountName=account_name;
AuthenticationMethod=BrowserBasedSSO;DatabaseName=database_name;
Schema=schema_name;Warehouse=warehouse_name;
User=user_name;[property=value[;...]];
where:
- account_name
- specifies the 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.
- 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 browser-based single sign-on authentication.
Connection conn = DriverManager.getConnection
("jdbc:datadirect:snowflake:AccountName=account_name.us-east-1;
AuthenticationMethod=BrowserBasedSSO;DatabaseName=payroll;
Schema=xyz;Warehouse=accounting;User=jSmith@example.com;");