<a id="ksqldb-reference-create-connector"></a>

# CREATE CONNECTOR statement in ksqlDB for Confluent Platform

## Synopsis

```sql
CREATE SOURCE | SINK CONNECTOR [IF NOT EXISTS] connector_name WITH( property_name = expression [, ...]);
```

## Description

Create a new connector in the Kafka Connect cluster with the
configuration passed in the WITH clause. Some connectors have ksqlDB
templates that simplify configuring them. For more information, see
[Natively Supported Connectors](../../concepts/connectors.md#ksqldb-connectors-natively-supported).

If the IF NOT EXISTS clause is present, the statement does not fail if a
connector with the supplied name already exists

#### NOTE
CREATE CONNECTOR works only in interactive mode.

## Example

```sql
CREATE SOURCE CONNECTOR `jdbc-connector` WITH(
    "connector.class"='io.confluent.connect.jdbc.JdbcSourceConnector',
    "connection.url"='jdbc:postgresql://localhost:5432/my.db',
    "mode"='bulk',
    "topic.prefix"='jdbc-',
    "table.whitelist"='users',
    "key"='username');
```

#### NOTE
See CREATE CONNECTOR in action:

- [Materialized cache - Start the Debezium source connector](../../tutorials/materialized-view.md#ksqldb-tutorials-materialized-cache-start-connector)
- [Streaming ETL pipeline - Start the source connectors](../../tutorials/etl.md#ksqldb-tutorials-streaming-etl-pipeline-start-source-connectors)
- [Streaming ETL pipeline- Start the Elasticsearch sink connector](../../tutorials/etl.md#ksqldb-tutorials-streaming-etl-pipeline-start-sink-connector)