Clockify data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: TIME

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
timeentries__amount
Display name Amount
Description The billable amount of the time entry. This value is rounded
Field type metric
Data type int.number.value
timeentries__approval_request_id
Display name Approval request ID
Description The unique ID of the approval request associated with the time entry
Field type dimension
Data type string.text.value
timeentries__billable
Display name Billable
Description Whether the time entry is billable or not
Field type dimension
Data type bool
timeentries__count
Display name Entries
Description The number of time entries
Field type metric
Data type int.number.value
timeentries__date
Display name Date
Field type dimension
Data type string.time.date
timeentries__description
Display name Description
Description Time entry description
Field type dimension
Data type string.text.value
timeentries__duration_h
Display name Duration (h)
Description The duration of the time entry in hours
Field type metric
Data type float.number.value
timeentries__duration_sec
Display name Duration (sec)
Description The duration of the time entry in seconds
Field type metric
Data type int.number.value
timeentries__entry_end
Display name Entry end time
Description The end time of the time entry
Field type dimension
Data type string.time.datetime
timeentries__entry_end_date
Display name Entry end date
Description The end date of the time entry
Field type dimension
Data type string.time.date
timeentries__entry_start
Display name Entry start time
Description The start time of the time entry
Field type dimension
Data type string.time.datetime
timeentries__entry_start_date
Display name Entry start date
Description The start date of the time entry
Field type dimension
Data type string.time.date
timeentries__invoice_id
Display name Invoice ID
Description The unique ID of the time entry invoice
Field type dimension
Data type string.text.value
timeentries__invoice_number
Display name Invoice number
Description The invoice number of the time entry
Field type dimension
Data type string.text.value
timeentries__is_locked
Display name Is locked
Description Whether the time entry is locked or not
Field type dimension
Data type bool
timeentries__manually_invoiced
Display name Manually invoiced
Description Whether the time entry is invoiced manually or not
Field type dimension
Data type bool
timeentries__project__archived
Display name Project is archived
Description Whether the project is archived or not
Field type dimension
Data type bool
timeentries__project__billable
Display name Project is billable
Description Whether the project is billable or not
Field type dimension
Data type bool
timeentries__project__budget_estimate
Display name Budget estimate
Description The estimated budget of the project
Field type dimension
Data type float.currency.value
timeentries__project__cost_rate
Display name Project cost rate
Field type dimension
Data type float.currency.value
timeentries__project__hourly_rate
Display name Project hourly rate
Field type dimension
Data type float.currency.value
timeentries__project__hourly_rate_currency
Display name Project hourly rate currency
Description The hourly rate currency of the project
Field type dimension
Data type string.currency.code
timeentries__project__id
Display name Project ID
Field type dimension
Data type string.text.value
timeentries__project__note
Display name Project note
Field type dimension
Data type string.text.value
timeentries__project__project_color
Display name Project color
Description The color of the project associated with the time entry
Field type dimension
Data type string.text.value
timeentries__project__project_name
Display name Project name
Description The name of the project associated with the time entry
Field type dimension
Data type string.text.value
timeentries__project__public
Display name Project is public
Description Whether the project is a public or not
Field type dimension
Data type bool
timeentries__project__template
Display name Project is a template
Description Whether the project is a template or not
Field type dimension
Data type bool
timeentries__project__time_estimate
Display name Time estimate
Description The estimated time of the project
Field type dimension
Data type string.text.value
timeentries__project__time_estimate_active
Display name Time estimate active
Description Whether the time estimate is active or not
Field type dimension
Data type bool
timeentries__project__time_estimate_type
Display name Time estimate type
Description The time estimate type of the project
Field type dimension
Data type string.text.value
timeentries__task_id
Display name Task ID
Description The unique ID of the task associated with the time entry
Field type dimension
Data type string.text.value
timeentries__task_name
Display name Task name
Description The name of the task associated with the time entry
Field type dimension
Data type string.text.value
timeentries__user__email
Display name User email
Description The email of the user making the time entry
Field type dimension
Data type string.text.value
timeentries__user__id
Display name User ID
Description The unique ID of the user making the time entry
Field type dimension
Data type string.text.value
timeentries__user__name
Display name User name
Description The name of the user making the time entry
Field type dimension
Data type string.text.value