Captain Data Connector Reference

The Captain Data connector exposes 41 fields (7 metrics, 34 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Captain Data Fields

Captain Data job_results fields

The job_results report of the Captain Data connector includes 4 fields.

ID	Type	Name	Description
job_results__extracted_at	TEXT	job_results.extracted_at	job_results.extracted_at
job_results__job_result_id	TEXT	job_results.job_result_id	job_results.job_result_id
job_results__job_uid	TEXT	job_results.job_uid	job_results.job_uid
job_results__results	OBJECT	job_results.results	job_results.results

Captain Data jobs fields

The jobs report of the Captain Data connector includes 17 fields.

ID	Type	Name	Description
jobs__accounts	OBJECT	jobs.accounts	jobs.accounts
jobs__configuration	OBJECT	jobs.configuration	jobs.configuration
jobs__error_message	TEXT	jobs.error_message	jobs.error_message
jobs__finish_time	TIMESTAMP	jobs.finish_time	jobs.finish_time
jobs__main_job_name	TEXT	jobs.main_job_name	jobs.main_job_name
jobs__main_job_uid	TEXT	jobs.main_job_uid	jobs.main_job_uid
jobs__name	TEXT	jobs.name	jobs.name
jobs__number_inputs	NUMERIC	jobs.number_inputs	jobs.number_inputs
jobs__row_count	NUMERIC	jobs.row_count	jobs.row_count
jobs__scheduled_time	TIMESTAMP	jobs.scheduled_time	jobs.scheduled_time
jobs__start_time	TIMESTAMP	jobs.start_time	jobs.start_time
jobs__status	TEXT	jobs.status	jobs.status
jobs__step_uid	TEXT	jobs.step_uid	jobs.step_uid
jobs__total_row_count	NUMERIC	jobs.total_row_count	jobs.total_row_count
jobs__uid	TEXT	jobs.uid	jobs.uid
jobs__workflow_name	TEXT	jobs.workflow_name	jobs.workflow_name
jobs__workflow_uid	TEXT	jobs.workflow_uid	jobs.workflow_uid

Captain Data workflows fields

The workflows report of the Captain Data connector includes 6 fields.

ID	Type	Name	Description
workflows__created_at	TEXT	workflows.created_at	workflows.created_at
workflows__name	TEXT	workflows.name	workflows.name
workflows__project_id	NUMERIC	workflows.project_id	workflows.project_id
workflows__steps	OBJECT	workflows.steps	workflows.steps
workflows__template_uid	TEXT	workflows.template_uid	workflows.template_uid
workflows__uid	TEXT	workflows.uid	workflows.uid

Captain Data workspace fields

The workspace report of the Captain Data connector includes 9 fields.

ID	Type	Name	Description
workspace__current_month_end	TEXT	workspace.current_month_end	workspace.current_month_end
workspace__current_month_start	TEXT	workspace.current_month_start	workspace.current_month_start
workspace__email	TEXT	workspace.email	workspace.email
workspace__name	TEXT	workspace.name	workspace.name
workspace__plan_name	TEXT	workspace.plan_name	workspace.plan_name
workspace__project_uid	TEXT	workspace.project_uid	workspace.project_uid
workspace__tasks_left	NUMERIC	workspace.tasks_left	workspace.tasks_left
workspace__tasks_max	NUMERIC	workspace.tasks_max	workspace.tasks_max
workspace__tasks_used	NUMERIC	workspace.tasks_used	workspace.tasks_used

Captain Data other fields

The Captain Data connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date