Code for the recurring job that fills Bi database schema. This function runs every day at 00:00
Several ordered SQL request will be executed on the server in order to compute BI data.
In red the steps we think will take time. In grey, the optionnal step we will do in a second time.
This project is easy to test w/ VSCode and a local installation of Node.js (https://nodejs.org/en/). In order to test and run the project locally, you need to install the following VSCode extensions :
- C# extension https://marketplace.visualstudio.com/items?itemName=ms-dotnettools.csharp
- Azure Function extension https://marketplace.visualstudio.com/items?itemName=ms-azuretools.vscode-azurefunctions
- Azurite extension (optional, provides a local Azure blob storage emulator)
After extensions installed, please check your local environement can run azure functions : open your Terminal and run "func". Is everything goes well, the installed version is displayed.
To test the project, go to Debug section, then click on Run.
- Documentation advise the use of AZURE_FUNCTIONS_ENVIRONMENT variable instead of ASPNETCORE_ENVIRONMENT (cf link to doc below).
Application settings reference for Azure Functions : https://docs.microsoft.com/en-us/azure/azure-functions/functions-app-settings