09:23:40,994 : ERROR : KNIME-Worker-76-DB Connector 0:13 : : Node : DB Connector : 0:13 : Execute failed: Unable to load AWS credentials from any provider in the chain Host_name_here&perferred_role=arn:aws:iam::12digit_number_here:role/ADFS-Redshift-data_reader®ion=us-west-2]Įxecute failed: Unable to load AWS credentials from any provider in the chain Here is my database URL and new log info.Ĭom.&idp_host= That is where I am hitting a wall, I think it is just my URL template syntax. So I am trying to connect with single sign on credentials. I am trying to get several other people in my org onto knime and IT is not willing to create more system users and I am not supposed to share my system user credentials. Just to clarify I do have a system user and password that work just fine in the Redshift Connector node. Must provide an explicit region in the builder or setup environment to supply a for replying, yes I have installed the driver. Must provide an explicit region in the builder or setup environment to supply a region.Īt .tRegion(AwsClientBuilder.java:371)Īt .nfigureMutableProperties(AwsClientBuilder.java:337)Īt .AwsSyncClientBuilder.build(AwsSyncClientBuilder.java:46)Īt .SamlCredentialsProvider.refresh(Unknown Source)Īt .SamlCredentialsProvider.getCredentials(Unknown Source)Īt .tIAMCredentials(Unknown Source)Īt .tIAMProperties(Unknown Source)Īt .nnect(Unknown Source)Īt .BaseConnectionFactory.doConnect(Unknown Source)Īt .nnect(Unknown Source)Īt .UrlDBConnectionController$nnect(UrlDBConnectionController.java:95)Īt .UrlDBConnectionController.createConnection(UrlDBConnectionController.java:308)Īt .UserDBConnectionController.createConnection(UserDBConnectionController.java:249)Īt .AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:89)Īt .$2(DBConnectionManager.java:501)Īt .run(FutureTask.java:266)Īt .runWorker(ThreadPoolExecutor.java:1149)Īt $n(ThreadPoolExecutor.java:624)Ĭaused by: : Unable to find a region via the region provider chain. : Unable to find a region via the region provider chain. Must provide an explicit region in the builder or setup environment to supply a region. 14:14:48,494 : ERROR : KNIME-Worker-51-DB Connector 0:13 : : Node : DB Connector : 0:13 : Execute failed: Unable to find a region via the region provider chain. Here is the current error I am getting in my log: Here is my current URL template in my new database driver. Jdbc:redshift:iam://?plugin_name=.AdfsCredentialsProvider&idp_host=************* Here is what my connection string looks like for DBeaver I have created a new database driver in preferences (redshift connector has not worked so i am using DB Connector). Currently we are using iam to authenticate through JDBC to the data base. I am connected via DBeaver so I know it is not a permisions issue. I am new to KNIME and having trouble connecting to my redshift database using my credentials.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |