API Reference for Access to Secrets¶

You can use Java or Python to retrieve credentials contained in a secret you created with the CREATE SECRET statement. This topic lists the methods for getting information from a secret. These are available with APIs included in Snowflake.

Java API for Secret Access¶

For code in Java, use the com.snowflake.snowpark_java.types.SnowflakeSecrets class.

The following table lists methods for accessing data in a secret.

Method	Description
`public String getGenericSecretString(String genericStringSecretName)`	Gets the generic token string held by the secret specified by `genericStringSecretName`. Returns a valid token string.
`public String getOAuthAccessToken(String oauthSecretName)`	Gets the OAuth2 access token held by the secret specified by `oauthSecretName`. Returns an OAuth2 token string.
`public String getSecretType(String secretName)`	Gets the type of the secret specified by `secretName`. Returns the TYPE parameter value set for this secret when it was created with the CREATE SECRET statement.
`public UsernamePassword getUsernamePassword(String usernamePasswordSecretName)`	Gets the username and password from the secret specified by `usernamePasswordSecretName`. Returns a `com.snowflake.snowpark_java.types.UsernamePassword` with username and password.

To use the SnowflakeSecrets class:

Make the Snowpark library available to your handler code using the PACKAGES clause as described in CREATE FUNCTION.
In your handler code, import com.snowflake.snowpark_java.types.SnowflakeSecrets.
Construct a SnowflakeSecrets object, and call one of the methods listed above to access the secret.

Code in the following example retrieves the value set for the TYPE clause when the secret was created with CREATE SECRET. Here, the oauth_token secret is of type OAUTH2.

CREATE OR REPLACE FUNCTION get_secret_type()
RETURNS STRING
LANGUAGE JAVA
HANDLER = 'SecretTest.getSecretType'
EXTERNAL_ACCESS_INTEGRATIONS = (external_access_integration)
PACKAGES = ('com.snowflake:snowpark:latest')
SECRETS = ('cred' = oauth_token )
AS
$$
import com.snowflake.snowpark_java.types.SnowflakeSecrets;

public class SecretTest {
  public static String getSecretType() {
    SnowflakeSecrets sfSecrets = SnowflakeSecrets.newInstance();

    String secretType = sfSecrets.getSecretType("cred");

    return secretType;
  }
}
$$;

Copy

Python API for Secret Access¶

For code in Python, use the _snowflake module exposed to Python UDFs that execute within Snowflake. The following table lists _snowflake functions for accessing data in a secret.

Function	Description
`get_generic_secret_string(generic_string_secret_name)`	Gets the generic token string held by the secret specified by `generic_string_secret_name`. Returns a valid token string.
`get_oauth_access_token(oauth_secret_name)`	Gets the OAuth2 access token held by the secret specified by `oauth_secret_name`. Returns an OAuth2 token string.
`get_secret_type(secret_name)`	Gets the type of the secret specified by `secret_name`. Returns the TYPE parameter value set for this secret when it was created with the CREATE SECRET statement.
`get_username_password(username_password_secret_name)`	Gets the username and password from the secret specified by `username_password_secret_name`. Returns an object with `username` and `password` attributes.

To use the _snowflake module in your handler code, import it as you would another module.

Code in the following example retrieves the value set for the TYPE clause when the secret was created with CREATE SECRET. Here, the oauth_token secret is of type OAUTH2.

CREATE OR REPLACE FUNCTION get_secret_type()
RETURNS STRING
LANGUAGE PYTHON
RUNTIME_VERSION = 3.8
HANDLER = 'get_secret'
EXTERNAL_ACCESS_INTEGRATIONS = (external_access_integration)
SECRETS = ('cred' = oauth_token )
AS
$$
import _snowflake

def get_secret():
  secret_type = _snowflake.get_secret_type('cred')
  return secret_type
$$;

Copy

Code in the following example retrieves the username and password held by the secret.

CREATE OR REPLACE FUNCTION get_secret_username_password()
RETURNS STRING
LANGUAGE PYTHON
RUNTIME_VERSION = 3.8
HANDLER = 'get_secret_username_password'
EXTERNAL_ACCESS_INTEGRATIONS = (external_access_integration)
SECRETS = ('cred' = credentials_secret )
AS
$$
import _snowflake

def get_secret_username_password():
  username_password_object = _snowflake.get_username_password('cred');

  username_password_dictionary = {}
  username_password_dictionary["Username"] = username_password_object.username
  username_password_dictionary["Password"] = username_password_object.password

  return username_password_dictionary
$$;

Copy