Azure SQL Database

Create an Azure Account

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

Create an Azure SQL Server

1. In the Azure portal, search for SQL servers and click Create.
2. Select your Subscription and Resource group.
3. Enter a Server name (e.g. datafly-sql). The full hostname will be datafly-sql.database.windows.net.
4. Select a Location close to your Signal deployment.
5. Set the Server admin login and Password.
6. Click Review + Create > Create.

Create a Database

1. In the Azure portal, search for SQL databases and click Create.
2. Select your server from the previous step.
3. Enter a Database name (e.g. analytics).
4. Choose a Compute + storage tier:
   • Basic or Standard for low-volume workloads.
   • General Purpose (vCore) for production workloads.
5. Click Review + Create > Create.

Configure Firewall Rules

1. Open your Azure SQL server in the portal.
2. Go to Security > Networking.
3. Under Firewall rules, add the IP addresses of your Signal deployment.
4. Optionally enable Allow Azure services and resources to access this server if Signal runs within Azure.
5. Click Save.

Create a Table

Connect to the database using Azure Data Studio, SSMS, or the Azure portal Query Editor:

CREATE TABLE dbo.events (
  event_id NVARCHAR(64) NOT NULL PRIMARY KEY,
  type NVARCHAR(20),
  event NVARCHAR(256),
  anonymous_id NVARCHAR(64),
  user_id NVARCHAR(256),
  timestamp DATETIME2,
  received_at DATETIME2,
  sent_at DATETIME2,
  context NVARCHAR(MAX),
  properties NVARCHAR(MAX),
  traits NVARCHAR(MAX),
  source_id NVARCHAR(64),
  integration_id NVARCHAR(64)
);
 
CREATE INDEX IX_events_timestamp ON dbo.events (timestamp DESC);

Create a Database User for Signal

Create a dedicated user with limited privileges:

CREATE LOGIN datafly_signal WITH PASSWORD = 'your_secure_password';
CREATE USER datafly_signal FOR LOGIN datafly_signal;
GRANT INSERT ON dbo.events TO datafly_signal;