Azure-Samples / Azure-Samples/agentic-app-with-fabric

Updates to readme.md for more clarity during setup.

Open Beginner friendly
#35 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TSQL
Stars
87
Forks
47
PR merge metrics
No merged PRs in 30d

Description

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:
1. 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.
2. 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.**_

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with README.md and compare the setup sections against the paths, files, SQL endpoints, and connection settings named in the issue. Check that the instructions for expressions.tmdl, create_views.sql, database variables, and backend startup are consistent and readable; done means a new setup reader can follow them without ambiguity.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
documentation
Issue type
Documentation
Difficulty
1/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
72/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.