Azure Data Explorer

Create an Azure Account

If you don’t already have one, sign up at azure.microsoft.com.

Create an Azure Data Explorer Cluster

1. In the Azure portal, search for Azure Data Explorer Clusters and click Create.
2. Enter a Cluster name (e.g. datafly-adx).
3. Select a Region close to your Signal deployment.
4. Choose a Compute specification based on your expected data volume.
5. Click Review + Create > Create.
6. Once deployed, note the URI (e.g. https://datafly-adx.westeurope.kusto.windows.net).

Create a Database

1. Open your ADX cluster in the Azure portal.
2. Click Databases in the left sidebar.
3. Click Add database.
4. Enter a Database name (e.g. analytics).
5. Set the Retention period and Cache period as needed.
6. Click Create.

Create a Table

1. In the ADX cluster, go to Query in the left sidebar.
2. Select your database and run the following KQL command:

.create table Events (
  event_id: string,
  type: string,
  event: string,
  anonymous_id: string,
  user_id: string,
  timestamp: datetime,
  received_at: datetime,
  context: dynamic,
  properties: dynamic,
  traits: dynamic,
  source_id: string,
  integration_id: string
)

3. Optionally enable streaming ingestion on the table:

.alter table Events policy streamingingestion enable

Register an Azure AD Application

1. In the Azure portal, go to Azure Active Directory > App registrations > New registration.
2. Enter a name (e.g. datafly-signal-adx).
3. Click Register.
4. Note the Application (client) ID and Directory (tenant) ID from the overview page.

Create a Client Secret

1. On the app registration page, go to Certificates & secrets > Client secrets > New client secret.
2. Enter a description and expiry period.
3. Click Add.
4. Copy the secret value immediately — it is only shown once.

Grant Database Permissions

1. In the ADX cluster, go to Databases > your database > Permissions.
2. Click Add > Ingestor.
3. Search for your Azure AD application name and select it.
4. Click Select.