How to use Link field when accessing Airtable via SQL

Topic Labels: Integrations
672 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hey all, we’re using 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[]
  from table2 t2
  where = ''
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?

0 Replies 0