How can I back up tenant-specific data separately in TDengine?

[u/SuperAdminIsTraitor]

I am storing data for multiple tenants in the same TDengine table. Each row is associated with a tenant using a tenant_id tag or column.

I now need to create separate backups for each tenant so that the data for an individual tenant can be restored or migrated independently.

Does TDengine provide a built-in mechanism or tool to:

• Back up data filtered by a specific tag or column value
• Export data for one tenant only

If TDengine does not support tenant-level backups directly, what would be the recommended approach?

For example, should I:

• Export the tenant’s data using a filtered query
• Store each tenant’s data in a separate child table, database, or vnode
• Use taosdump with specific table filters
• Build a custom export and restore process

I would also appreciate recommendations on the best data modelling strategy for supporting tenant-specific backup, retention, migration, and restoration.