Skip to content
This repository was archived by the owner on Mar 31, 2026. It is now read-only.

SymbolPackageArchives.md

Latest commit

 

History

History
52 lines (45 loc) · 6.02 KB

SymbolPackageArchives.md

File metadata and controls

52 lines (45 loc) · 6.02 KB

SymbolPackageArchives

This table contains metadata about the ZIP archive that is the package .snupkg (symbol package). This is low level ZIP metadata without any special knowledge of NuGet-specific interpretation of the ZIP file. Note that not all packages have symbol packages.
Cardinality Exactly one row per package on NuGet.org
Child tables SymbolPackageArchiveEntries joined on Identity
Parent tables
Column used for CSV partitioning Identity
Column used for Kusto partitioning Identity
Key fields Identity
Data file container name symbolpackagearchives
Driver SymbolPackageArchiveToCsv
Record type SymbolPackageArchiveRecord

Table schema

Column name Data type Required Description
ScanId string No Unused, always empty
ScanTimestamp timestamp No Unused, always empty
LowerId string Yes Lowercase package ID. Good for joins
Identity string Yes Lowercase package ID and lowercase, normalized version. Good for joins
Id string Yes Original case package ID
Version string Yes Original case, normalized package version
CatalogCommitTimestamp timestamp Yes Latest catalog commit timestamp for the package
Created timestamp Yes, for Available When the package version was created
ResultType enum Yes Type of record (e.g. Available, Deleted, DoesNotExist)
Size long Yes, for Available The size of the .nupkg in bytes
OffsetAfterEndOfCentralDirectory long Yes, for Available Byte offset after the end of central directory signature, typically 18 less than the Size
CentralDirectorySize uint Yes, for Available Size of central directory in bytes
OffsetOfCentralDirectory uint Yes, for Available Byte offset of the central directory
EntryCount int Yes, for Available The number of entries in the ZIP
Comment string No The comment at the end of the ZIP archive
HeaderMD5 string No The Base64 encoded MD5 hash of the .snupkg from the HTTP header
HeaderSHA512 string No The Base64 encoded SHA512 hash of the .snupkg from the HTTP header
MD5 string Yes, for Available The Base64 encoded MD5 hash of the .snupkg
SHA1 string Yes, for Available The Base64 encoded SHA1 hash of the .snupkg
SHA256 string Yes, for Available The Base64 encoded SHA256 hash of the .snupkg
SHA512 string Yes, for Available The Base64 encoded SHA512 hash of the .snupkg

ResultType schema

Enum value Description
Available The package is available and processed successfully
Deleted The package is deleted and no metadata is available
DoesNotExist The package does not have a symbol package