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
