Hey all, we’re using https://syncinc.so/ to access Airtable from retool, where we use SQL to work with Airtable tables.
We have two table connected by a Link field and we need to set the Link field via SQL.
Normally it’d be something using foreign key, but I’m not sure how to achieve it here.
The SQL code would be this:
UPDATE table1
SET link_field_to_t2 = (
select array[t2.id]
from table2 t2
where t2.email = 'email@email.com'
)
where id = '<some_ID>'
When I try to run this, I get:
permission denied for table table1
Is it possible to achieve what I’m trying to achieve?
