Agent Bricks import table error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2025 01:16 AM
"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]'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2025 02:29 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2025 02:09 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2025 03:17 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2025 07:31 PM
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.