Skip to main content

Get JDBC job

GET 
/platform/jobs/jdbc/:jobId

Retrieve enriched JDBC configuration for jobId, usually the pipeline identifier plus job index. Read the actual ID from pipeline details before changing configuration.

Response structure​

Source fields are job_name, source_config, transformations and output_config. Source configuration includes connector: jdbc, database plugin, schema/table, column_include_list (null means all columns), authentication and incremental settings. For incremental_with_qualify, inspect primary_keys and raw/qualify destinations.

Example configuration excerpt​

{
  "job_name": "orders_extraction",
  "source_config": {
    "connector": "jdbc",
    "plugin": "postgresql",
    "table_schema": "public",
    "table_name": "orders",
    "load_type": "incremental",
    "incremental_column_name": "updated_at",
    "incremental_column_type": "timestamp"
  },
  "transformations": [],
  "output_config": {"plugin": "dadosfera_snowflake"}
}

This is an illustrative excerpt, not a new exhaustive response schema. Documented errors distinguish 404 for a missing job from 400 for a non-JDBC job. For SaaS extraction use Get Singer job.

Request​

Responses​

JDBC job details