- 20 Nov 2023
- 1 minute read
- Print
- DarkLight
- PDF
Slate Data Dictionary
- Updated 20 Nov 2023
- 1 minute read
- Print
- DarkLight
- PDF
Slate provides real-time access to its current data dictionary, which may be downloaded and viewed. To view the data dictionary:
Select Database on the top navigation bar and select Standard Query Library.
Select Slate Data Dictionary, then select Download to Excel to download the data dictionary.
uniqueidentifier columns:
| Slate uses a globally unique identifier (GUID), also known as universally unique identifier (UUID), for each relational key on a table. These are 128-bit (16-byte) identifiers that are not, in their native form, human-readable. In data feeds and exports, such an identifier is typically represented as a hexadecimal string, 36 characters in length and in the form 00000000-0000-0000-0000-000000000000. The hyphens within the hexadecimal string can optionally be removed to condense the identifier to 32 characters without any data loss. |
To bring yourself up to speed with the database schema most quickly, select the Display SQL links on any query within Slate to see how specific data points are being pulled, how JOINs are being constructed, etc.