Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to: (tick) Kyvos Enterprise  (tick) Kyvos Cloud (SaaS on AWS) (error) Kyvos AWS Marketplace

...

Code Block
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "VisualEditor0",
"Effect": "Allow",
"Action": [
"redshift:GetClusterCredentials",
"redshift:JoinGroup",
"redshift:CreateClusterUser"
],
"Resource": "arn:aws:redshift:region:account-id:cluster:cluster-name*"
},
{
"Sid": "VisualEditor1",
"Effect": "Allow",
"Action": "redshift:DescribeClusters",
"Resource": "*"
}
]
}

...

  • Provide the iam_role

  • Set the  LoginTimeout value

To set up or view a Redshift warehouse connection, perform the following steps. 

  1. From the Toolbox, click Setup, then Connections.

  2. From the Actions menu (  ⋮  ) click Add Connection.

  3. Enter a name or select it from the Connection list.

  4. After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.

  5. If the connection is valid, click the Save button.

  6. To refresh connections, click the Actions menu (  ⋮  ) at the top of the Connections column and select Refresh.

Aura tab collection
paramsJTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCU3RCU3RA==
Aura tab
summaryAuthentication Type: User Name and Password
paramsJTdCJTIydGl0bGUlMjIlM0ElMjJBdXRoZW50aWNhdGlvbiUyMFR5cGUlM0ElMjBVc2VyJTIwTmFtZSUyMGFuZCUyMFBhc3N3b3JkJTIyJTdE

  1. Select Warehouse from the Category List.
    There may be more than one warehouse connection.

  2. For Providers, select Redshift.

  3. For Authentication Type choose one of the following User Name and Password.

  4. Enter the URL, Redshift user name, and password for Kyvos to connect to Redshift.

  5. Click the SSL checkbox to configure the driver to use a non-validating SSL factor. Use this setting if the server you are connecting to uses SSL but does not require identity verification. 

  6. Click Properties to configure advanced settings or set JDBC-specific properties. All non-Kyvos properties are passed to the JDBC API. 

  7. In the Miscellaneous Properties section, provide the iam_role and the LoginTimeout value. The recommended value is 10.

  8. Click Save.

Aura tab
summaryAuthentication Type: IAM Instance Profile Credentials
paramsJTdCJTIydGl0bGUlMjIlM0ElMjJBdXRoZW50aWNhdGlvbiUyMFR5cGUlM0ElMjBJQU0lMjBJbnN0YW5jZSUyMFByb2ZpbGUlMjBDcmVkZW50aWFscyUyMiU3RA==

  1. Select Warehouse from the Category List.
    There may be more than one warehouse connection.

  2. For Providers, select Redshift.

  3. For Authentication Type choose IAM Instance Profile Credentials to configure the IAM role attached to the BI server.

  4. Enter the URL, Redshift User, and Redshift groups to map to the IAM role. 

  5. The JDBC URL can be fetched from AWS Redshift Console and has the following format: jdbc:redshift:iam://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev

  6. Click Auto Create DB User to create the user at runtime. That user is assigned to a group that is specified at the connection screen. The group must already exist. If a group is not specified, then the user is assigned to the PUBLIC group.Click Properties to configure advanced settings or set JDBC-specific properties. All non-Kyvos properties are passed to the JDBC API.the Properties link to add the following properties and specify the value as per the configuration.

    1. DbGroups: Enter the value of the RedShift Database group.

    2. iam_role: Enter the IAM role configured on your RedShift cluster.

      image-20241218-083856.pngImage Added

  7. In the Miscellaneous Properties section, provide the Redshift iam_role and the LoginTimeout value. The recommended value is 10.

  8. Optionally, select the SSL check box to enable SSL in a Redshift connection.

    Image Removed

    Click Save.

  9. To refresh connections, click the menu ( ⋮ ) at the top of the Connections column and select Refresh.

  10. Test to validate the connection. Once it is valid, click Save.

    image-20241218-083404.pngImage Added