TDE
application/octet-stream
Magic Bytes
Offset: 0
20 02 01 62 A0 1E AB 07 02 00 00 00
Tableau Data Extract (TDE) is a proprietary, compressed columnar data format developed and maintained by Tableau Software for optimized analytical processing. It enables the offline storage and rapid retrieval of large datasets for visualization and business intelligence reporting within the Tableau Desktop and Server applications. This legacy format has been largely superseded by the Hyper database technology but remains compatible with older versions of the business analytics software suite.
Validation Code
How to validate .tde files in Python
Python
def is_tde(file_path: str) -> bool:
"""Check if file is a valid TDE by magic bytes."""
signature = bytes([0x20, 0x02, 0x01, 0x62, 0xA0, 0x1E, 0xAB, 0x07, 0x02, 0x00, 0x00, 0x00])
with open(file_path, "rb") as f:
return f.read(12) == signatureHow to validate .tde files in Node.js
Node.js
function isTDE(buffer: Buffer): boolean {
const signature = Buffer.from([0x20, 0x02, 0x01, 0x62, 0xA0, 0x1E, 0xAB, 0x07, 0x02, 0x00, 0x00, 0x00]);
return buffer.subarray(0, 12).equals(signature);
}
Go
func IsTDE(data []byte) bool {
signature := []byte{0x20, 0x02, 0x01, 0x62, 0xA0, 0x1E, 0xAB, 0x07, 0x02, 0x00, 0x00, 0x00}
if len(data) < 12 {
return false
}
return bytes.Equal(data[:12], signature)
}API Endpoint
GET
/api/v1/tde
curl https://filesignature.org/api/v1/tde