airtable-export icon indicating copy to clipboard operation
airtable-export copied to clipboard

Support for `joins` or `foreign keys` when exporting to sqlite

Open kbsali opened this issue 3 years ago • 0 comments

Hi,

When exporting an airtable db to sqlite, is there a way to query the resulting dataset with joins ? I'm not an expert in sqlite, but I'm guessing it is possible to join 2 tables without having foreign keys defined? But given the format of those foreign keys (eg. ["recqyhKQGTj1HU8Gi"]), I'm not sure if it is possible.

Thanks for possible hints!

kbsali avatar Jun 16 '21 21:06 kbsali