Amazon Aurora DSQL is provided as a Preview service.
To learn more, see Betas and Previews
Use the Python SDK to generate a token in Aurora DSQL
Once your cluster is ACTIVE, you can generate an authentication token.
There are two ways to generate the token
-
If you are connecting as
adminuser, you use thegenerate_db_connect_admin_auth_token -
If you are connecting with a custom database role, you use the
generate_connect_auth_token
The following example uses the following attributes to generate an authentication token for the admin role.
-
your_cluster_endpoint – endpoint of the cluster. Follows the format
your_cluster_identifier.dsql.AWS_REGION.on.aws -
region – The AWS Region, such as us-east-2 or us-east-1
def generate_token(your_cluster_endpoint, region):
client = boto3.client("dsql", region_name=region)
# use `generate_db_connect_auth_token` if you are _not_ connecting as admin instead.
token = client.generate_db_connect_admin_auth_token(your_cluster_endpoint, region)
print(token)
return token