Azure IoT Hub Data Observability

Prerequisites

• Docker Desktop
• dotnet-script global tool

Install dotnet-script once:

dotnet tool install -g dotnet-script

Start local database

From repo root:

docker compose up -d

Useful database access commands:

psql -p 5432 -h localhost -U postgres
docker exec -it timescaledb psql -U postgres

GUI option: DBeaver

Configure environment variables

Create a file named .env in repo root with:

AZURE_STORAGE_CONNECTION_STRING=<your-storage-connection-string>
AZURE_STORAGE_CONTAINER_NAME=messages
AZURE_IOT_HUB_NAME=<your-iot-hub-name>

Notes:

• AZURE_STORAGE_CONTAINER_NAME must match the routed storage container.
• AZURE_IOT_HUB_NAME must match the {iothub} segment used by the IoT Hub routing file format.
• STATE_FILE_PATH is optional. If omitted, the script uses last_run_state.txt in repo root.

Run the script

From repo root:

dotnet script ingest.csx