User
Table schema for user profiles, preferences, and dimensions.
Last updated
Was this helpful?
Table schema for user profiles, preferences, and dimensions.
Schema reference for user profiles and the preferences attached to them.
Table Name: users
Description: User profiles and preferences
_id
string
Internal identifier
additional_context
json
Custom user context
created_at
timestamp
Creation timestamp
email
string
User email address
first_name
string
User first name
last_name
string
User last name
org_id
string
Organization identifier
preferences
json
User preferences
region_name
string
User region
role
string
User role
updated_at
timestamp
Last update timestamp
user_id
string
User unique identifier
user_models
json
Personalization models
SELECT
user_id,
email,
role,
preferences,
updated_at
FROM users
ORDER BY updated_at DESC;Last updated
Was this helpful?
Was this helpful?

