call_jobs_api.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests, json"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "POST https://cloud.getdbt.com/api/v2/accounts/16116/jobs/41843/run/\n",
    "\n",
    "Headers\n",
    "{ \"Authorization\": \"Token <your-api-key>\" }\n",
    "\n",
    "Body\n",
    "{\n",
    "  \"cause\": \"Triggered via API\",\n",
    "  \"git_sha\": \"<git sha to execute>\"\n",
    "}\n",
    "\n",
    "{\n",
    "  \"cause\": \"Kicked off from Airflow\",\n",
    "  \"git_branch\": \"staging\",\n",
    "  \"schema_override\": \"dbt_cloud_pr_123\",\n",
    "  \"dbt_version_override\": \"0.18.0\",\n",
    "  \"target_name_override\": \"staging\",\n",
    "  \"timeout_seconds_override\": 3000,\n",
    "  \"generate_docs_override\": true,\n",
    "  \"threads_override\": 8,\n",
    "  \"steps_override\": [\n",
    "    \"dbt seed\",\n",
    "    \"dbt run --fail-fast\",\n",
    "    \"dbt test --fail-fast\"\n",
    "  ]\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# url = 'https://cloud.getdbt.com/api/v2/accounts/'\n",
    "# url = 'https://cloud.getdbt.com/api/v2/accounts/16116/jobs/'\n",
    "url = 'https://cloud.getdbt.com/api/v2/accounts/16116/jobs/41843/run/'\n",
    "\n",
    "headers = { \n",
    "    \"Content-Type\": \"application/json\",\n",
    "    \"Authorization\": \"Token <?>\" }\n",
    "\n",
    "body = {\n",
    "    \"cause\": \"Triggered via API\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r = requests.post(url, headers=headers, json=body)\n",
    "r.status_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'{\"status\":{\"code\":200,\"is_success\":true,\"user_message\":\"Success!\",\"developer_message\":\"\"},\"data\":{\"id\":35287216,\"trigger_id\":36002257,\"account_id\":16116,\"environment_id\":48626,\"project_id\":46674,\"job_definition_id\":41843,\"status\":1,\"dbt_version\":\"0.21.0\",\"git_branch\":null,\"git_sha\":null,\"status_message\":null,\"owner_thread_id\":null,\"executed_by_thread_id\":null,\"deferring_run_id\":null,\"artifacts_saved\":false,\"artifact_s3_path\":null,\"has_docs_generated\":false,\"has_sources_generated\":false,\"notifications_sent\":false,\"blocked_by\":[],\"scribe_enabled\":true,\"created_at\":\"2021-11-30 04:34:01.795630+00:00\",\"updated_at\":\"2021-11-30 04:34:01.795644+00:00\",\"dequeued_at\":null,\"started_at\":null,\"finished_at\":null,\"last_checked_at\":null,\"last_heartbeat_at\":null,\"should_start_at\":null,\"trigger\":{\"id\":36002257,\"cause\":\"Triggered via API\",\"job_definition_id\":41843,\"git_branch\":\"development\",\"git_sha\":null,\"github_pull_request_id\":null,\"gitlab_merge_request_id\":null,\"schema_override\":null,\"dbt_version_override\":null,\"threads_override\":null,\"target_name_override\":null,\"generate_docs_override\":null,\"timeout_seconds_override\":null,\"steps_override\":null,\"created_at\":\"2021-11-30 04:34:01.788484+00:00\",\"cause_humanized\":\"Triggered via API\",\"job\":null},\"job\":{\"execution\":{\"timeout_seconds\":0},\"generate_docs\":false,\"run_generate_sources\":true,\"id\":41843,\"account_id\":16116,\"project_id\":46674,\"environment_id\":48626,\"name\":\"webhook\",\"dbt_version\":null,\"created_at\":\"2021-11-11T01:55:22.970172Z\",\"updated_at\":\"2021-11-11T02:14:27.649755Z\",\"execute_steps\":[\"dbt run --models dim_closure\"],\"state\":1,\"deferring_job_definition_id\":null,\"lifecycle_webhooks\":false,\"lifecycle_webhooks_url\":null,\"triggers\":{\"github_webhook\":false,\"git_provider_webhook\":false,\"custom_branch_only\":true,\"schedule\":false},\"settings\":{\"threads\":4,\"target_name\":\"default\"},\"schedule\":{\"cron\":\"0 * * * *\",\"date\":\"every_day\",\"time\":\"every_hour\"},\"is_deferrable\":false},\"environment\":null,\"run_steps\":[],\"status_humanized\":\"Queued\",\"in_progress\":true,\"is_complete\":false,\"is_success\":false,\"is_error\":false,\"is_cancelled\":false,\"href\":\"https://cloud.getdbt.com/#/accounts/16116/projects/46674/runs/35287216/\",\"duration\":\"00:00:00\",\"queued_duration\":\"00:00:00\",\"run_duration\":\"00:00:00\",\"duration_humanized\":\"0 minutes\",\"queued_duration_humanized\":\"0 minutes\",\"run_duration_humanized\":\"0 minutes\",\"created_at_humanized\":\"0 minutes ago\",\"finished_at_humanized\":\"0 minutes from now\",\"job_id\":41843}}'"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.text"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "4aeb2aca411ada1dc044acffed3691eeabfceb2a2c2d88f5afb8dc4b02228991"
  },
  "kernelspec": {
   "display_name": "Python 3.9.4 64-bit ('internal_demo': virtualenv)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}