> ## Documentation Index
> Fetch the complete documentation index at: https://docs.orbit.devotel.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Update a reverse-ETL warehouse export config

> Create or update the reverse-ETL export configuration for one warehouse destination. Only the keys you send are merged; scheduler-owned run status is never overwritten. Send `credentials` to set the encrypted secret (an empty string clears it) and `enabled: true` to arm the incremental nightly sync. Identifier fields are format-validated per warehouse. Owner / admin / developer only.



## OpenAPI

````yaml /openapi.yaml patch /api/v1/cdp/reverse-etl/warehouse/{warehouse}
openapi: 3.1.0
info:
  title: Devotel CPaaS API
  description: Orbit by Devotel — Communications Platform as a Service API
  version: 1.0.0
  contact:
    name: Devotel
    url: https://devotel.io
    email: support@devotel.io
  license:
    name: Proprietary
servers:
  - url: https://api.orbit.devotel.io
    description: Production
security:
  - Bearer: []
  - ApiKey: []
tags:
  - name: Messages
    description: >-
      Send and manage messages across all channels (SMS, WhatsApp, RCS, Email,
      Viber, etc.)
  - name: Fax
    description: >-
      List and track fax (MMS/T.38) transmissions on Telnyx-backed fax numbers
      (sending flows through the Messaging API)
  - name: Agents
    description: AI agent creation, configuration, and execution
  - name: Voice
    description: Voice calls, IVR, conferencing, and SIP trunking
  - name: OnCall
    description: On-call rotations and escalation policy planning for incident alerting
  - name: Webhooks
    description: Webhook endpoint management and delivery logs
  - name: Numbers
    description: Phone number search, provisioning, and configuration
  - name: Brand Identity
    description: >-
      Unified cross-channel brand trust posture (10DLC, toll-free, WhatsApp,
      RCS, branded calling, number KYC)
  - name: Contacts
    description: Contact management, segmentation, and lifecycle tracking
  - name: Campaigns
    description: Marketing campaign orchestration and analytics
  - name: Flows
    description: Automation flow builder and execution engine
  - name: Templates
    description: Message template management and approval workflows
  - name: Settings
    description: Organization, channel, and user preference settings
  - name: Verify
    description: OTP generation and verification across channels
  - name: Push
    description: Push notification delivery via FCM and APNs
  - name: Integrations
    description: Third-party service connections and OAuth management
  - name: CDP
    description: >-
      Customer Data Platform — activation surface (CRM object sync, streaming
      destinations, ad-audience activation)
  - name: Files
    description: >-
      Server-to-server media upload, listing, retrieval, and deletion
      (signed-URL backed)
  - name: Commerce
    description: >-
      Omnichannel conversational-commerce — persistent cart + checkout state
      machine, channel-agnostic hosted pay-by-link, native WhatsApp checkout,
      and AP2-style agent payment mandates.
  - name: Sync
    description: >-
      Real-time shared-state primitive (Twilio Sync parity) — Documents, Maps,
      Lists, and ephemeral Streams, with change events relayed over the
      /api/v1/ws/sync WebSocket gateway
  - name: Risk
    description: >-
      Unified cross-channel Trust & Fraud risk scoring — fuses SMS-pumping,
      URL-reputation, Verify Fraud Guard, and Voice Biometrics signals into one
      composite verdict queryable before a send or a call.
  - name: Orby
    description: >-
      In-dashboard Orby operator assistant: streamed assistant turns,
      conversation threads, product knowledge-base search, and the tool-action
      approval gate. Available to signed-in operators only (dashboard session
      auth — API-key requests are rejected).
paths:
  /api/v1/cdp/reverse-etl/warehouse/{warehouse}:
    patch:
      tags:
        - CDP
      summary: Update a reverse-ETL warehouse export config
      description: >-
        Create or update the reverse-ETL export configuration for one warehouse
        destination. Only the keys you send are merged; scheduler-owned run
        status is never overwritten. Send `credentials` to set the encrypted
        secret (an empty string clears it) and `enabled: true` to arm the
        incremental nightly sync. Identifier fields are format-validated per
        warehouse. Owner / admin / developer only.
      parameters:
        - schema:
            type: string
            enum:
              - snowflake
              - redshift
              - postgres
              - databricks
              - clickhouse
          in: path
          name: warehouse
          required: true
          description: Which warehouse destination's config to update.
      requestBody:
        required: false
        content:
          application/json:
            schema:
              type: object
              additionalProperties: false
              properties:
                enabled:
                  type: boolean
                sync_interval_minutes:
                  type: integer
                  description: >-
                    Minimum gap between scheduled runs; omit for the default
                    ~23h cadence.
                account:
                  type: string
                host:
                  type: string
                port:
                  type: integer
                database:
                  type: string
                schema_name:
                  type: string
                warehouse_name:
                  type: string
                role:
                  type: string
                username:
                  type: string
                table_prefix:
                  type: string
                credentials:
                  type: string
                  description: >-
                    Secret credential (encrypted at rest). Pass an empty string
                    to clear it.
                field_mappings:
                  type: object
                  nullable: true
            example:
              enabled: true
              account: xy12345.us-east-1
              database: ANALYTICS
              schema_name: PUBLIC
              warehouse_name: COMPUTE_WH
              username: ORBIT_SVC
              credentials: |-
                -----BEGIN PRIVATE KEY-----
                ...
                -----END PRIVATE KEY-----
      responses:
        '200':
          description: The updated warehouse export config (no plaintext credential)
          content:
            application/json:
              schema:
                type: object
                properties:
                  data:
                    type: object
                    additionalProperties: true
                    properties:
                      warehouse:
                        type: string
                        enum:
                          - snowflake
                          - redshift
                          - postgres
                          - databricks
                          - clickhouse
                      enabled:
                        type: boolean
                      credentials_configured:
                        type: boolean
                  meta:
                    $ref: '#/components/schemas/ResponseMeta'
              example:
                data:
                  warehouse: snowflake
                  enabled: true
                  account: xy12345.us-east-1
                  database: ANALYTICS
                  schema_name: PUBLIC
                  warehouse_name: COMPUTE_WH
                  credentials_configured: true
                  field_mappings: null
                meta:
                  request_id: req_01J9Z8
                  timestamp: '2026-08-06T12:00:00.000Z'
components:
  schemas:
    ResponseMeta:
      type: object
      required:
        - request_id
        - timestamp
      additionalProperties: false
      properties:
        request_id:
          type: string
          description: Unique request identifier (also returned as X-Request-Id header)
        timestamp:
          type: string
          format: date-time
        docs_url:
          type: string
          format: uri
          nullable: true
  securitySchemes:
    Bearer:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: Dashboard JWT token from Clerk
    ApiKey:
      type: apiKey
      name: X-API-Key
      in: header
      description: Server-to-server API key (dv_live_sk_*)

````