Error in Supabase Vector Store when trying to add documents

[mxkel]

I am having the following error when trying to load data into a Supabase Vector Store - " Problem in node ‘Supabase Vector Store‘

Error inserting: null value in column “brand” of relation “comments” violates not-null constraint 400 Bad Request"

Problem in node ‘Supabase Vector Store‘
Error inserting: null value in column “brand” of relation “comments” violates not-null constraint 400 Bad Request

The supabase database is set up with the following columns;
id (text), content (text), brand (text), week_start (Date), week_end (date), metadata (blob) and embeddings

Information on your n8n setup

• n8n version: 1.79.2
• Database (default: SQLite): Supabase
• n8n EXECUTIONS_PROCESS setting (default: own, main): default
• Running n8n via (Docker, npm, n8n cloud, desktop app): Railway.app cloud hosted:
• **Operating system:**Mac OS Sequoia

[solomon]

You can go directly to your Supabase table and remove the constraint in that collumn, to allow NULL values.

.

If my reply solves your problem, please remember to mark it as a solution.

[solomon]

Hey @mxkel were you able to solve this problem?
Please mark this topic as solved, if you did.