How to use Link field when accessing Airtable via SQL

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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.