topic Agent Bricks import table error in Generative AI

Agent Bricks import table error

suho_ryo — Wed, 15 Oct 2025 08:16:47 GMT

"I encountered an error when I tried to import a table to improve the quality of the Agent Bricks Knowledge Assistant. The error message is: 'Unrecognized token 'The': was expecting ('true', 'false' or 'null') at [Source: The provided text discusses information security certifications and does not contain any elements of hate speech, harassment, incitement of violence, or the promotion of illegal or severely harmful acts. It is purely informational and related to corporate compliance. Therefore, it adheres to content safety policies.; line: 1, column: 4]'

Re: Agent Bricks import table error

Khaja_Zaffer — Wed, 15 Oct 2025 09:29:41 GMT

Hello @suho_ryo

Good day!!

as per the error : You need to inspect the data in the table you are trying to import and ensure that every entry in each column strictly follows the required data types and JSON formatting. The documentation for Agent Bricks confirms that the table must have this specific schema for the import to work correctly.

https://docs.databricks.com/aws/en/generative-ai/agent-bricks/knowledge-assistant

here is the video for the same: https://www.youtube.com/watch?v=UGL28vHJhTo

check why you are having a boolean value in your dataset.

Re: Agent Bricks import table error

suho_ryo — Thu, 16 Oct 2025 09:09:21 GMT

Hello @Khaja_Zaffer

Thanks for your reply.

I believe the table schema should be correct, as I created it with the following statement. There are no boolean values in my data. When I tried exporting the created table and then re-importing it, I encountered the same error.

CREATE TABLE IF NOT EXISTS table_name ( eval_id STRING, request STRING, guidelines ARRAY<STRING>, feedback_records ARRAY<STRING>, metadata STRING, tags STRING )

However, when I set the value for feedback_records to ["true", "false"], I got the following error message:

"Failed to load examples
Expected 'START_OBJECT' not 'VALUE_TRUE' at [Source: REDACTED (StreamReadFeature.INCLUDE_SOURCE_IN_LOCATION disabled); line: 1, column: 5] at [Source: UNKNOWN; line: 1, column: 5]"

I suspect that column: 5 refers to the metadata column. I thought any string would be acceptable for this field, but it still resulted in an error. Since the message mentioned 'START_OBJECT', I also tried using a string that starts with "{", but that produced the same error as well.

Re: Agent Bricks import table error

Khaja_Zaffer — Thu, 16 Oct 2025 10:17:21 GMT

Hello @suho_ryo

Can you give me sample of the data you are using? so that we can check.

I would again suggest you to please watch the video tagged in the resolution provided before.

Re: Agent Bricks import table error

suho_ryo — Fri, 17 Oct 2025 02:31:24 GMT

Hello @Khaja_Zaffer

Here is the actual data I tried to import:

INSERT INTO table_name VALUES ( 'eval-001', 'Translate this text to Japanese.', array('Be natural.', 'Keep the original nuance.'), array('true', 'false'), '{"model_version": "Knowledge Assistant", "timestamp": "2025-10-16T09:30:00Z"}', '{translation, Knowledge Assistant, review}' );

I watched the video you sent me the link for, but it didn't mention anything about the table to be imported.