Get JDBC Job Details

Overview

Retrieve the complete configuration for a JDBC connector job, including source configuration, load type, columns, and output settings.

Job ID Format

The jobId follows the format: {pipeline_id}_{job_index}

Example: 1b33ad2f_33d3_4837_9eeb_83c82c8b909d_0 (first job in pipeline 1b33ad2f_33d3_4837_9eeb_83c82c8b909d)

Response Structure

Field	Type	Description
`job_name`	string	Display name of the job
`source_config`	object	JDBC source configuration
`source_config.connector`	string	Always `"jdbc"`
`source_config.plugin`	string	Database type: `mysql`, `postgresql`, `oracle`, `sqlserver`
`source_config.table_schema`	string	Source database schema
`source_config.table_name`	string	Source table name
`source_config.column_include_list`	array	List of columns to extract (null = all columns)
`source_config.load_type`	string	`full_load`, `incremental`, or `incremental_with_qualify`
`source_config.incremental_column_name`	string	Column used for incremental tracking
`source_config.incremental_column_type`	string	Data type: `number`, `date`, or `timestamp`
`source_config.primary_keys`	array	Primary key columns (for `incremental_with_qualify`)
`source_config.auth_parameters`	object	Authentication configuration
`transformations`	array	List of transformation configurations
`output_config`	object	Destination configuration

Examples

Get PostgreSQL Job Details

GET /platform/jobs/jdbc/1b33ad2f_33d3_4837_9eeb_83c82c8b909d_0

Response (200 OK):

{
  "job_name": "orders_extraction",
  "source_config": {
    "connector": "jdbc",
    "plugin": "postgresql",
    "table_schema": "public",
    "table_name": "orders",
    "column_include_list": ["id", "customer_id", "total_amount", "created_at", "updated_at"],
    "network_config": null,
    "auth_parameters": {
      "auth_type": "connection_manager",
      "config_id": "1701234567890_abc123_postgresql-1.0.0"
    },
    "load_type": "incremental",
    "incremental_column_name": "updated_at",
    "incremental_column_type": "timestamp",
    "primary_keys": null
  },
  "transformations": [],
  "output_config": {
    "plugin": "dadosfera_snowflake",
    "raw": {
      "table_name": "orders",
      "table_schema": "RAW_DATA"
    }
  }
}

Get MySQL Job with Deduplication

GET /platform/jobs/jdbc/a9f82c14_7e21_4b5a_8c9d_12345abcdef0_0

Response (200 OK):

{
  "job_name": "customers_extraction",
  "source_config": {
    "connector": "jdbc",
    "plugin": "mysql",
    "table_schema": "ecommerce",
    "table_name": "customers",
    "column_include_list": null,
    "network_config": null,
    "auth_parameters": {
      "auth_type": "connection_manager",
      "config_id": "1701234567890_def456_mysql-1.0.0"
    },
    "load_type": "incremental_with_qualify",
    "incremental_column_name": "modified_at",
    "incremental_column_type": "timestamp",
    "primary_keys": ["customer_id"]
  },
  "transformations": [],
  "output_config": {
    "plugin": "dadosfera_snowflake",
    "raw": {
      "table_name": "staging_customers",
      "table_schema": "BRONZE"
    },
    "qualify": {
      "table_name": "customers",
      "table_schema": "GOLD"
    }
  }
}

Get Oracle Full Load Job

GET /platform/jobs/jdbc/c5d92e18_4f31_4a2b_9c8d_67890fghijk0_0

Response (200 OK):

{
  "job_name": "products_extraction",
  "source_config": {
    "connector": "jdbc",
    "plugin": "oracle",
    "table_schema": "SALES",
    "table_name": "PRODUCTS",
    "column_include_list": ["PRODUCT_ID", "NAME", "PRICE", "CATEGORY"],
    "network_config": null,
    "auth_parameters": {
      "auth_type": "connection_manager",
      "config_id": "1701234567890_ghi789_oracle-1.0.0"
    },
    "load_type": "full_load",
    "incremental_column_name": null,
    "incremental_column_type": null,
    "primary_keys": null
  },
  "transformations": [],
  "output_config": {
    "plugin": "dadosfera_snowflake",
    "raw": {
      "table_name": "PRODUCTS",
      "table_schema": "RAW_ORACLE"
    }
  }
}

Error Responses

404 Not Found

{
  "detail": "Job with id invalid_job_id not found"
}

400 Bad Request - Not a JDBC Job

{
  "detail": "This job_id is not a jdbc job"
}

Supported Database Plugins

Plugin	Database
`postgresql`	PostgreSQL
`mysql`	MySQL / MariaDB
`oracle`	Oracle Database
`sqlserver`	Microsoft SQL Server

Notes

This endpoint returns enriched job metadata with resolved configuration values
Use this endpoint to inspect current job configuration before making updates
For Singer connector jobs, use GET /platform/jobs/singer/:jobId