`aws bedrock-agent get-knowledge-base` output for structured knowledge base does not return `sqlKnowledgeBaseConfiguration`

[cdanielsoh]

Describe the issue

aws bedrock-agent get-knowledge-base --knowledge-base-id MIOLPZWF3C
{
    "knowledgeBase": {
        "createdAt": "2025-04-14T01:57:06.452541+00:00",
        "knowledgeBaseArn": "arn:aws:bedrock:us-west-2:851725462015:knowledge-base/MIOLPZWF3C",
        "knowledgeBaseConfiguration": {
            "type": "SQL"
        },
        "knowledgeBaseId": "MIOLPZWF3C",
        "name": "financial-data-knowledge-base",
        "roleArn": "arn:aws:iam::851725462015:role/BusinessAgentStack-KnowledgeBaseRoleA2B317B9-ltIi50LIPrnF",
        "status": "ACTIVE",
        "updatedAt": "2025-04-14T01:57:06.452541+00:00"
    }
}

From the document there should be sqlKnowledgeBaseConfiguration under knowledgeBaseConfiguration but it is missing.

Links

https://awscli.amazonaws.com/v2/documentation/api/latest/reference/bedrock-agent/get-knowledge-base.html

[adev-code]

Hi @cdanielsoh, thanks for reaching out. I've replicated the above and I was able to see "sqlKnowledgeBaseConfiguration" under "knowledgeBaseConfiguration" :

aws bedrock-agent get-knowledge-base --knowledge-base-id FYZZOPV4IN --region us-west-2
{
    "knowledgeBase": {
        "createdAt": "2025-04-23T18:16:43.516881+00:00",
        "knowledgeBaseArn": "arn:aws:bedrock:us-west-2:[REDACTED]:knowledge-base/FYZZOPV4IN",
        "knowledgeBaseConfiguration": {
            "sqlKnowledgeBaseConfiguration": {
                "redshiftConfiguration": {
                    "queryEngineConfiguration": {
                        "provisionedConfiguration": {
                            "authConfiguration": {
                                "type": "USERNAME_PASSWORD",
                                "usernamePasswordSecretArn": "arn:aws:secretsmanager:us-west-2:[REDACTED]:secret:[REDACTED]"
                            },
                            "clusterIdentifier": "dummy-cluster"
                        },
                        "type": "PROVISIONED"
                    },
                    "storageConfigurations": [
                        {
                            "redshiftConfiguration": {
                                "databaseName": "dummy_db"
                            },
                            "type": "REDSHIFT"
                        }
                    ]
                },
                "type": "REDSHIFT"
            },
            "type": "SQL"
        },
        "knowledgeBaseId": "FYZZOPV4IN",
        "name": "test-sql-kb-west",
        "roleArn": "arn:aws:iam:[REDACTED]:role/BedrockKnowledgeBaseRole",
        "status": "ACTIVE",
        "updatedAt": "2025-04-23T18:16:43.516881+00:00"
    }
}

I tried on us-east-1 or us-west-2 regions using AWS CLI version 2.26.5, where the get-knowledge-base command consistently returns the complete sqlKnowledgeBaseConfiguration object. For better review, what is the AWS CLI version you are using (aws --version), relevant permission for this operation is bedrock:GetKnowledgeBase, and run the command with --debug flag to provide the full debug logs? Additionally, it would be helpful to know if you've tried with a recently created knowledge base and if you've observed this behavior with other knowledge base types or just SQL ones. Please let me know if you have any questions. Thank you.

[github-actions]

Greetings! It looks like this issue hasn’t been active in longer than five days. We encourage you to check if this is still an issue in the latest release. In the absence of more information, we will be closing this issue soon. If you find that this is still a problem, please feel free to provide a comment or upvote with a reaction on the initial post to prevent automatic closure. If the issue is already closed, please feel free to open a new one.