Reference data (also known as a lookup table) is a finite data set that’s static or slowly changing in nature, used to augment your fast-moving data streams. Azure Stream Analytics now natively supports Azure SQL DB as a source of reference data input. Easily author a query to extract the dataset from your Azure SQL DB and configure a refresh interval for scenarios that require slow changing reference datasets. For advanced scenarios, we also support delta queries that simply pull in incremental updates, as opposed to the entire snapshot of the database.
Learn more