Skip to content

Updates to readme.md for more clarity during setup. #35

@Heenanl

Description

@Heenanl

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions