Windsor brings all your Captain Data data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Captain Data Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| job_results__extracted_at | TEXT | job_results.extracted_at | job_results.extracted_at | job_results |
| job_results__job_result_id | TEXT | job_results.job_result_id | job_results.job_result_id | job_results |
| job_results__job_uid | TEXT | job_results.job_uid | job_results.job_uid | job_results |
| job_results__results | OBJECT | job_results.results | job_results.results | job_results |
| jobs__accounts | OBJECT | jobs.accounts | jobs.accounts | jobs |
| jobs__configuration | OBJECT | jobs.configuration | jobs.configuration | jobs |
| jobs__error_message | TEXT | jobs.error_message | jobs.error_message | jobs |
| jobs__finish_time | TIMESTAMP | jobs.finish_time | jobs.finish_time | jobs |
| jobs__main_job_name | TEXT | jobs.main_job_name | jobs.main_job_name | jobs |
| jobs__main_job_uid | TEXT | jobs.main_job_uid | jobs.main_job_uid | jobs |
| jobs__name | TEXT | jobs.name | jobs.name | jobs |
| jobs__number_inputs | NUMERIC | jobs.number_inputs | jobs.number_inputs | jobs |
| jobs__row_count | NUMERIC | jobs.row_count | jobs.row_count | jobs |
| jobs__scheduled_time | TIMESTAMP | jobs.scheduled_time | jobs.scheduled_time | jobs |
| jobs__start_time | TIMESTAMP | jobs.start_time | jobs.start_time | jobs |
| jobs__status | TEXT | jobs.status | jobs.status | jobs |
| jobs__step_uid | TEXT | jobs.step_uid | jobs.step_uid | jobs |
| jobs__total_row_count | NUMERIC | jobs.total_row_count | jobs.total_row_count | jobs |
| jobs__uid | TEXT | jobs.uid | jobs.uid | jobs |
| jobs__workflow_name | TEXT | jobs.workflow_name | jobs.workflow_name | jobs |
| jobs__workflow_uid | TEXT | jobs.workflow_uid | jobs.workflow_uid | jobs |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| workflows__created_at | TEXT | workflows.created_at | workflows.created_at | workflows |
| workflows__name | TEXT | workflows.name | workflows.name | workflows |
| workflows__project_id | NUMERIC | workflows.project_id | workflows.project_id | workflows |
| workflows__steps | OBJECT | workflows.steps | workflows.steps | workflows |
| workflows__template_uid | TEXT | workflows.template_uid | workflows.template_uid | workflows |
| workflows__uid | TEXT | workflows.uid | workflows.uid | workflows |
| workspace__current_month_end | TEXT | workspace.current_month_end | workspace.current_month_end | workspace |
| workspace__current_month_start | TEXT | workspace.current_month_start | workspace.current_month_start | workspace |
| workspace__email | TEXT | workspace.email | workspace.email | workspace |
| workspace__name | TEXT | workspace.name | workspace.name | workspace |
| workspace__plan_name | TEXT | workspace.plan_name | workspace.plan_name | workspace |
| workspace__project_uid | TEXT | workspace.project_uid | workspace.project_uid | workspace |
| workspace__tasks_left | NUMERIC | workspace.tasks_left | workspace.tasks_left | workspace |
| workspace__tasks_max | NUMERIC | workspace.tasks_max | workspace.tasks_max | workspace |
| workspace__tasks_used | NUMERIC | workspace.tasks_used | workspace.tasks_used | workspace |