Hopefully this ask makes sense. Every time I attempt to think through it brain cells die.
I have a large project with many different schemas. The schemas are linked via a ‘Lookup key’ schema.
My main data set schema “Account” produces a fake company name ‘Name’. In the second data set schema ‘loans’ I’d like it to reference and pull in the account name ‘Name’ created in the Account schema.
Uploads have a hard limit of 30MB per file, regardless of plan. If you only need a primary key from a dataset, I suggest pulling that column into a separate file. You’ll be able to upload many more rows due to the reduced file size.