Add foreign keys like grand id or something to connect different APIs when we download the data into tables in sql.Like if grants data has grant id for a particular grant, then having grand id or something simillar as foreign key in accounts API, where I can see which grant an expense or revenue belongs to. So, that it helps us to connect these atbles and build dashboards

Add foreign keys like grand id or something to connect different APIs when we download the data into tables in sql.Like if grants data has grant id for a particular grant, then having grand id or something simillar as foreign key in accounts API, where I can see which grant an expense or revenue belongs to. So, that it helps us to connect these atbles and build dashboards

  • Guest
  • Jul 28 2025
  • Attach files