# Create Data Stores for Streaming Data

Before you write any queries, you must configure DeltaStream to connect to the data store where data resides. This article shows how to use the Web application to create a data store.&#x20;

This is the first step to take before you process any data using DeltaStream SQL statements.

{% hint style="info" %}
**Note**   In addition to self-hosted services, for Kafka data store types you can also configure [Confluent Cloud](https://www.confluent.io/confluent-cloud/) and [Amazon MSK](https://aws.amazon.com/msk/) in DeltaStream.
{% endhint %}

## Creating a Data Store <a href="#create_a_store" id="create_a_store"></a>

1. In the lefthand navigation, click **Resources** ( ![](https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2Fgit-blob-b8a3f3aca0b7459aa58df4a07a41134959fbe33f%2FResourcesIcon.png?alt=media) ) to display the **Resources** page.
2. Click **+ Add Store**, and from the menu that displays click the data store type you want (in this case, Kafka).

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FTwjAtk9oxu4XcBKJRUqR%2FAddDataStoreMenu.png?alt=media&#x26;token=91d0f2c8-335b-45b7-8586-6d93522df0d8" alt="" width="308"><figcaption></figcaption></figure>

{% hint style="info" %}
**Note**   Be sure to match the data store type with the streaming store where streaming data resides.
{% endhint %}

3. Choose a unique **Name** for the data store. Use only alphanumeric characters, dashes, and underscores, and limit the name to a maximum of 255 characters.
4. If indicated, add at least one **URI** port to which to connect, then click **+**.\
   Separate multiple entries with a comma.
5. Complete the authentication options as appropriate for the data store. See below for more information.
6. Click **Add**.

## Authentication Parameters <a href="#auth-options" id="auth-options"></a>

For more detailed information about common and store-specific authentication parameters, see [#store\_parameters](https://docs.deltastream.io/reference/sql-syntax/ddl/create-store#store_parameters "mention") in the **Reference** section.

### Kafka Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FMTIqxMcaTS9ksQIl8Uwh%2FNewKafkaStore.png?alt=media&#x26;token=d758b764-31c1-4629-ae1c-608fd7ebea28" alt="" width="460"><figcaption><p>Kafka Store Parameters</p></figcaption></figure>

### Confluent Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FTndpc22YczTWnEnM6fH9%2FAddConfluentKafkaDataStore.png?alt=media&#x26;token=3ff5fcb7-8248-4315-ae67-74cd85f56c09" alt="" width="459"><figcaption><p>Confluent Kafka Store Parameters</p></figcaption></figure>

### Kinesis Authentication Parameters

We recommend you use an assumed IAM role to authenticate with Kinesis stores (below). We do not recommend you use AWS credentials.

To authenticate with Kinesis stores we recommend using an assumed IAM role; you can use AWS credentials to authenticate but we do not recommend that method.

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2F7I73eMCshD8xJRzZFM20%2FNewKinesisStore.png?alt=media&#x26;token=4b3064b4-ae6c-4e49-b052-a03d3933f9e3" alt="" width="462"><figcaption><p>AWS Kinesis Store Parameters</p></figcaption></figure>

### Databricks Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FtV9hulgpugckP9KFWr7G%2FNewDatabricksStore.png?alt=media&#x26;token=c0f72ad5-dae0-4700-a0f2-ae981dd227ff" alt="" width="458"><figcaption><p>Databricks Store Parameters</p></figcaption></figure>

### Snowflake Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FHrVlZ6M7ZQm5GzzVlKyp%2FNewSnowflakeStore.png?alt=media&#x26;token=92e9556a-cbbe-4fe4-aef5-688afb33681b" alt="" width="461"><figcaption><p>Snowflake Store Parameters</p></figcaption></figure>

### Postgres Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2Fv68znRD6toUj5xhijW5H%2FAddPostgresDataStore.png?alt=media&#x26;token=27588b3c-2e11-4ec3-a121-01ff618490a3" alt="" width="460"><figcaption><p>Postgres Store Parameters</p></figcaption></figure>

### ClickHouse Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FLcCarLlnozT1sPNHIziX%2FAddClickHouseDataStore.png?alt=media&#x26;token=a9241b11-fd65-46fa-b143-d28c1f03d0a0" alt="" width="461"><figcaption><p>ClickHouse Store Parameters</p></figcaption></figure>

### Iceberg AWS Glue Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FYAwxlkobAFWTO7vLHL5g%2FAddIcebergGlueDataStore.png?alt=media&#x26;token=43244c95-2008-423e-b3ef-539b5b277704" alt="" width="462"><figcaption><p>Iceberg AWS Glue Parameters</p></figcaption></figure>

### Iceberg REST Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FRO8LJKwZoLz206ZVyO0u%2FAddIcebergRESTDataStore.png?alt=media&#x26;token=5f396b61-b168-454a-b254-adc2c8ec3e48" alt="" width="461"><figcaption><p>Iceberg REST Parameters</p></figcaption></figure>

### AWS S3 Authentication Parameters

<figure><img src="https://1288764042-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fdbd9e6ZJodkgF1H6AVay%2Fuploads%2FLR8thhyWdzpgoPJtRK7X%2FAddS3DataStore.png?alt=media&#x26;token=1339240a-792e-47a4-bf62-289d28fb7fdf" alt="" width="459"><figcaption><p>AWS S3 Parameters</p></figcaption></figure>
