ServiceNow

ServiceNow is Roche’s ITSM (IT Service Management) platform. The roche-data pipeline creates automated change requests via the Table API before production deployments, ensuring every data platform change follows Roche’s ITIL change management process. Each change request links to the git commit and PR that triggered it.

Connection Details

Property	Value
URL	TBD (awaiting A12 resolution)
Auth method	Service account (username + password)
Network	Roche corporate network
Access task	A12
GitHub issue	#27
API	REST Table API (/api/now/table/)

Environment Variables

Variable	Source	Description
SERVICENOW_BASE_URL	Vault common/servicenow	ServiceNow instance base URL
SERVICENOW_INSTANCE	GitHub Actions secrets	ServiceNow instance identifier
SERVICENOW_USER	GitHub Actions secrets	Service account username
SERVICENOW_PASSWORD	GitHub Actions secrets	Service account password

CLI Modules

Module	Usage
rdt-model-cidb	Creates change requests for production deployments (DDL changes, dbt promotions, OPA policy updates)

Change Request Flow

Access Verification

Script: scripts/access/check-servicenow.sh

Required tools: curl

Checks performed:

1. HTTP connectivity to ServiceNow REST Table API (/api/now/table/incident?sysparm_limit=1)
2. HTTP status code validation (200 = full access, 401/403 = auth needed)

Expected state: skip — A12 not yet resolved.

API Endpoints

Method	Path	Purpose
POST	/api/now/table/change_request	Create a new change request
PATCH	/api/now/table/change_request/{sys_id}	Update/close a change request
GET	/api/now/table/change_request?number={chg}	Look up existing change

Current Status

• Access: Not started — needed for any production deployment
• Priority: Required before first production promotion (Phase 1+)
• Workaround: Manual change request creation via ServiceNow UI for initial deployments
• Impact: Blocks automated production deployments until resolved