Importing linked tables into Baserow

Baserow Help
1

Question on how to correctly import linked tables. I’m a bit confused.

I have several csv ‘tables’ I need to import into Baserow. These csv files have been exported from a database and have primary and foreign keys assigned. A normal database structure.

So, there is no way to import these tables into Baserow without utilizing Make or some such provider. Correct?

Once the import is complete - don’t I really need to change the primary keys on each table to properly identify the relationships while users work on live data? Like customer “ABC Corporation” instead of 215487 - with 215487 being an example of the original key. Seems the documentation suggests this approach.

This would break the existing relationships that we just created - correct?

Sorry, if I missed something major in my understanding.

Thanks in advance.

2

Hi @danbr, I believe that it should be possible to have the data linked after import but you would need to create the tables properly first (define the relationship etc.).

Your question is very vague, tables exported from database - which database. What tables. Primary and foreign keys assigned - how assigned?

If you want a specific help, you will need to be specific.

3

Sorry, did kinda ramble. Importing CSV tables created from SQL Server. Did some more imports and exports. Got it now.

Thanks for taking time to reply.