Import CSV into current table with foreign key columns

I started a Retool Database. Added a few tables. I'm trying to import data from a CSV (250 rows) to one of those tables but, it has 3 foreign key columns. I'm getting an error. Any help on that?

Hey @rockfordanalytics! Can you share the error that you are getting?

The foreign keys were all to dimension tables and rather than having IDs in the appropriate import columns, I had dimension values. So it was a datatype error.

1 Like