- I have a data pipeline running which brings in data from multiple data sources to AWS redshift.
- All the data within redshift have their own foreign key mappings done and then the data is added.
- When I go to the connected metabase instance, all the data loads upon reloading the database from redshift, but the foreign key mappings are not shown at all.
- A workaround to this is manually going to the settings in metabase ui and setting foreign keys from there.
The problem is this is a very manual task and I need to do the same for 100s of tables and even more keys, is there any way of automating the detection of foreign keys that exist in redshift.
If not automating, is there anyway in which metabase would automatically pick up these changes upon refresh?
What I did: add foreign key relations manually via ui
What i expected: metabase to automatically pick up foreign key relations.
