Have included small updates below in bold to make the Readme easy to comprehend and follow during setup.
Updated text mentioned in bold+italic.
Step 2: Re-deploy to connect semantic model to the right database endpoint
- In the first step, data artifacts were deployed, but the semantic model needs to be redeloyed by provding the correct database endpoint parameters which you would need to obtain and provide manually as below:
- Obtain below values (copy and keep somewhere)
- SQL server connection string: First, go to the SQL analytics endpoint of the agentic_lake, go to settings -> SQL endpoint -> copy value under SQL connection string (paste it somewhere to keep it for now)
- Lakehouse analytics GUID: Look at the address bar, you should see something like this: https://app.fabric.microsoft.com/groups/[first string]/mirroredwarehouses (or lakehouses)/[second string]?experience=fabric-developer
- copy the value you see in position of second string.
- Now within your github repo ; go to: Fabric_artifacts\agentic_semantic_model.SemanticModel\definition, open the file called expressions.tmdl and replace the values with the ones you just retrieved. Save the file and push it to your repo.
### 4. Populate your database with sample data
Data will be automatically populated, if not existing, in the SQL Database when you start the backend application.
**Add views to the SQL Analytics endpoint**
- go to the SQL analytics endpoint of your agentic_lake
- _**Create new sql_query**_
- Go to Data_Ingest folder, _**find the script create_views.sql. Copy the contents and paste into the new Sql_query in fabric and**_ run all 3 queries that you see in file views.sql
**Microsoft Fabric SQL Databases**
**FABRIC_SQL_CONNECTION_URL_AGENTIC**: This is the connection string for the SQL Database that contains both **the agentic application's operational data** (e.g., chat history) and **the sample customer banking data**. You can find this in your Fabric workspace by navigating to the SQL-endpoint of the database _**agentic_app_db**_, clicking the "settings" -> "Connection strings" -> go to "ODBC" tab and select and copy SQL connection string.
### 4. Run the Application
Open two terminal windows.
#### Terminal 1: Start Backend
Run below (ensure you have your virtual environment activated for this! ) from the backend folder.
Have included small updates below in bold to make the Readme easy to comprehend and follow during setup.
Updated text mentioned in bold+italic.
Step 2: Re-deploy to connect semantic model to the right database endpoint
Run below (ensure you have your virtual environment activated for this! ) from the backend folder.