List all available connection types (connectors) in Polytomic.

List all data connections in Polytomic.

Get details for a specific connection.

Args: id: The connection ID

Create a new data connection in Polytomic.

Args: name: Name for the connection type: Connection type (e.g. 'postgresql', 'salesforce', 'snowflake') configuration: JSON string with connection config (varies by type)

Update an existing connection in Polytomic.

Args: id: The connection ID to update name: Optional new name for the connection configuration: Optional JSON string with connection config

Delete a connection from Polytomic.

Args: id: The connection ID to delete

List all data models in Polytomic.

Get details and fields for a specific model.

Args: id: The model ID

Create a new data model in Polytomic.

Args: name: Name for the model connection_id: The connection ID this model uses configuration: JSON string with model config (e.g. {"query": "SELECT * FROM users"} or {"table": "users"}) identifier: Optional field name to use as unique identifier tracking_columns: Optional JSON array of column names for change tracking

Update an existing data model in Polytomic.

Args: id: The model ID to update name: Optional new name for the model configuration: Optional JSON string with model config (e.g. {"query": "SELECT * FROM users"}) identifier: Optional field name to use as unique identifier tracking_columns: Optional JSON array of column names for change tracking

Delete a model from Polytomic.

Args: id: The model ID to delete

List all model syncs in Polytomic.

Get details for a specific sync.

Args: id: The sync ID

Create a new model sync (reverse ETL) in Polytomic.

Args: name: Name for the sync mode: Sync mode ('create', 'update', 'updateOrCreate', 'replace', 'append') target: JSON string with target config {"connection_id": "...", "object": "...", "configuration": {...}} fields: JSON array of field mappings [{"source": {"field": "...", "model_id": "..."}, "target": "..."}] identity: Optional JSON for identity mapping (required for update modes) schedule: Optional JSON for schedule {"frequency": "manual|hourly|daily|weekly|monthly", ...} filters: Optional JSON array of filters filter_logic: Optional filter logic string (e.g. "A AND B")

Update an existing sync in Polytomic.

Args: id: The sync ID to update name: Optional new name mode: Optional sync mode fields: Optional JSON array of field mappings identity: Optional JSON for identity mapping schedule: Optional JSON for schedule filters: Optional JSON array of filters filter_logic: Optional filter logic string active: Optional boolean to enable/disable sync

Delete a sync from Polytomic.

Args: id: The sync ID to delete

Activate (enable) a sync.

Args: id: The sync ID to activate

Manually trigger a sync to run.

Args: id: The sync ID to trigger

Get the current status of a sync.

Args: id: The sync ID

List execution history for a sync.

Args: id: The sync ID limit: Maximum number of executions to return (default 10)

Get details for a specific sync execution.

Args: sync_id: The sync ID execution_id: The execution ID

List all bulk syncs in Polytomic.

Get details for a specific bulk sync.

Args: id: The bulk sync ID

Create a new bulk sync (ELT) in Polytomic.

Args: name: Name for the bulk sync source_connection_id: Source connection ID dest_connection_id: Destination connection ID destination_configuration: JSON string with destination config (e.g. {"schema": "public"}) schedule: Optional JSON for schedule source_configuration: Optional JSON string with source-specific config

Update an existing bulk sync in Polytomic.

Args: id: The bulk sync ID to update name: Optional new name schedule: Optional JSON for schedule destination_configuration: Optional JSON string with destination config source_configuration: Optional JSON string with source config

Delete a bulk sync from Polytomic.

Args: id: The bulk sync ID to delete

Activate or deactivate a bulk sync.

Args: id: The bulk sync ID active: True to activate, False to deactivate

Manually trigger a bulk sync to run.

Args: id: The bulk sync ID to trigger

Get the current status of a bulk sync.

Args: id: The bulk sync ID

List execution history for a bulk sync.

Args: id: The bulk sync ID limit: Maximum number of executions to return (default 10)

Get available schemas/tables for a bulk sync.

Args: id: The bulk sync ID

Update which schemas/tables are enabled for a bulk sync.

Args: id: The bulk sync ID schemas: JSON array of schema configurations