JDBC URL examples

This section describes how to create a JDBC connection URL, and provides examples. To specify the optional connection properties, use the following URL format:

jdbc:timestream://PropertyName1=value1;PropertyName2=value2... 

Note

All connection properties are optional. All property keys are case-sensitive.

Below are some examples of JDBC connection URLs.

Example with basic authentication options and region:

jdbc:timestream://AccessKeyId=<myAccessKeyId>;SecretAccessKey=<mySecretAccessKey>;SessionToken=<mySessionToken>;Region=us-east-1

Example with client info, region and SDK options:

jdbc:timestream://ApplicationName=MyApp;Region=us-east-1;MaxRetryCountClient=10;MaxConnections=5000;RequestTimeout=20000

Connect using the default credential provider chain with AWS credential set in environment variables:

jdbc:timestream

Connect using the default credential provider chain with AWS credential set in the connection URL:

jdbc:timestream://AccessKeyId=<myAccessKeyId>;SecretAccessKey=<mySecretAccessKey>;SessionToken=<mySessionToken>

Connect using the PropertiesFileCredentialsProvider as the authentication method:

jdbc:timestream://AwsCredentialsProviderClass=PropertiesFileCredentialsProvider;CustomCredentialsFilePath=<path to properties file>

Connect using the InstanceProfileCredentialsProvider as the authentication method:

jdbc:timestream://AwsCredentialsProviderClass=InstanceProfileCredentialsProvider

Connect using the Okta credentials as the authentication method:

jdbc:timestream://IdpName=Okta;IdpHost=<host>;IdpUserName=<name>;IdpPassword=<password>;OktaApplicationID=<id>;RoleARN=<roleARN>;IdpARN=<IdpARN>

Connect using the Azure AD credentials as the authentication method:

jdbc:timestream://IdpName=AzureAD;IdpUserName=<name>;IdpPassword=<password>;AADApplicationID=<id>;AADClientSecret=<secret>;AADTenant=<tenantID>;IdpARN=<IdpARN>

Connect with a specific endpoint:

jdbc:timestream://Endpoint=abc.us-east-1.amazonaws.com;Region=us-east-1