Data linked to each other but if one table Archeive?

[Rupesh]

1. Linked Tables and Data Archiving

If two tables are connected through a Link column (linked records), what happens when the data in one of the tables is archived for large-scale data management purposes?

• Will the existing links between the two tables remain intact?
• Or will archiving affect, remove, or invalidate the linked relationships?

2. API Access to Archived Data

We understand that data can be retrieved using APIs. If a table is partially or fully archived as part of a big data management strategy:

• Can the archived data still be accessed through the API?
• Are there any special settings, configurations, or recommended practices required to export or retrieve archived data?
• Is there any difference in API behaviour between partially archived and fully archived tables?

[rdb]

@Rupesh

If two tables are connected through a Link column (linked records), what happens when the data in one of the tables is archived for large-scale data management purposes?

• Will the existing links between the two tables remain intact?
• Or will archiving affect, remove, or invalidate the linked relationships?

The link is retained. It is not directly displayed in the link column, though. To see the link, you must click on the yellow triangle icon.

@Rupesh

We understand that data can be retrieved using APIs. If a table is partially or fully archived as part of a big data management strategy:

• Can the archived data still be accessed through the API?
• Are there any special settings, configurations, or recommended practices required to export or retrieve archived data?
• Is there any difference in API behaviour between partially archived and fully archived tables?

Of course! Use the sql query endpoint. This endpoint is storage agnostic.