### Start Oracle GoldenGate Core Installation

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/real-time-intelligence/event-streams/stream-oracle-data-to-eventstream.md

Initiates the Oracle GoldenGate Core installation process by navigating to the installation directory and running the installer. Requires setting the DISPLAY environment variable.

```bash
$ sudo su - oracle
$ export DISPLAY=10.0.0.5:0.0
$ cd fbo_ggs_Linux_x64_Oracle_shiphome/Disk1
$ ./runInstaller
```

--------------------------------

### Example Java Version Output

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/workload-development-kit/back-end-set-up.md

This is an example of the expected output when verifying your Java installation. Ensure your version meets the minimum requirements.

```bash
openjdk version "17.0.12" 2024-07-16 LTS
OpenJDK Runtime Environment Microsoft-10377968 (build 17.0.12+7-LTS)
OpenJDK 64-Bit Server VM Microsoft-10377968 (build 17.0.12+7-LTS, mixed mode, sharing)
```

--------------------------------

### Uvicorn Server Console Output Example

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/workload-development-kit/back-end-set-up.md

Example console output when the Uvicorn server starts successfully. This indicates the application is running and accessible.

```bash
INFO:     Uvicorn running on http://0.0.0.0:5000 (Press CTRL+C to quit)
INFO:     Started reloader process [xxxx]
INFO:     Started server process [xxxx]
INFO:     Waiting for application startup.
INFO:     Application startup complete.
```

--------------------------------

### Create Directories and Start Manager

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/real-time-intelligence/event-streams/stream-oracle-data-to-eventstream.md

Navigate to the Oracle GoldenGate Big Data installation directory, create necessary subdirectories, edit the Manager parameters, and start the Manager process.

```bash
$ cd /u01/app/oggbd
$ ./ggsci
GGSCI> CREATE SUBDIRS
GGSCI> EDIT PARAMS MGR
```

```plaintex
PORT 7801
```

```bash
GGSCI> START MGR
GGSCI> INFO ALL

Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING

GGSCI> EXIT
```

--------------------------------

### Quick Start: Connect and Query Fabric

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/spark-jdbc-driver.md

Demonstrates connecting to Microsoft Fabric using the JDBC driver and executing a simple query. Ensure prerequisites are met and the driver is installed.

```java
import java.sql.*;

public class QuickStartExample {
    public static void main(String[] args) {
        // Connection string with required parameters
        String url = "jdbc:fabricspark://api.fabric.microsoft.com;"
                     + "FabricWorkspaceID=<workspace-id>;"
                     + "FabricLakehouseID=<lakehouse-id>;"
                     + "AuthFlow=2;" +  // Azure CLI based authentication
                     + "LogLevel=INFO";
        
        try (Connection conn = DriverManager.getConnection(url)) {
            // Execute a simple query
            try (Statement stmt = conn.createStatement();
                 ResultSet rs = stmt.executeQuery("SELECT 'Hello from Fabric!' as message")) {
                
                if (rs.next()) {
                    System.out.println(rs.getString("message"));
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
```

--------------------------------

### Complete rayfin.yml Example

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/apps/hosting.md

A comprehensive 'rayfin.yml' configuration demonstrating static hosting alongside authentication and data services.

```yaml
id: my-app
name: my-app
version: 1.0.0
services:
  auth:
    enabled: true
    allowedRedirectUris:
      - http://localhost:5173
      - http://localhost:5173/auth/callback
    fabric:
      enabled: true
  data:
    enabled: true
    dialect: mssql
  staticHosting:
    enabled: true
    folder: dist
    buildCommand: npm run build
    indexDocument: index.html
```

--------------------------------

### Get Groundedness Metric from LLM

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-science/tutorial-evaluate-rag-performance.md

This function calculates the groundedness score by prompting a large language model (LLM). It uses a detailed prompt template that includes examples to guide the LLM in determining if an answer is entailed by the provided context. The score ranges from 1 to 5, where higher is better.

```python
def get_groundedness_metric(context, answer):
    """Get the groundedness score from the LLM using the context and answer."""

    groundedness_prompt_template = """
    You are presented with a CONTEXT and an ANSWER about that CONTEXT. Decide whether the ANSWER is entailed by the CONTEXT by choosing one of the following ratings:
    1. 5: The ANSWER follows logically from the information contained in the CONTEXT.
    2. 1: The ANSWER is logically false from the information contained in the CONTEXT.
    3. an integer score between 1 and 5 and if such integer score does not exist, use 1: It is not possible to determine whether the ANSWER is true or false without further information. Read the passage of information thoroughly and select the correct answer from the three answer labels. Read the CONTEXT thoroughly to ensure you know what the CONTEXT entails. Note the ANSWER is generated by a computer system, it can contain certain symbols, which should not be a negative factor in the evaluation.
    Independent Examples:
    ## Example Task #1 Input:
    "CONTEXT": "Some are reported as not having been wanted at all.", "QUESTION": "", "ANSWER": "All are reported as being completely and fully wanted."
    ## Example Task #1 Output:
    1
    ## Example Task #2 Input:
    "CONTEXT": "Ten new television shows appeared during the month of September. Five of the shows were sitcoms, three were hourlong dramas, and two were news-magazine shows. By January, only seven of these new shows were still on the air. Five of the shows that remained were sitcoms.", "QUESTION": "", "ANSWER": "At least one of the shows that were cancelled was an hourlong drama."
    ## Example Task #2 Output:
    5
    ## Example Task #3 Input:
    "CONTEXT": "In Quebec, an allophone is a resident, usually an immigrant, whose mother tongue or home language is neither French nor English.", "QUESTION": "", "ANSWER": "In Quebec, an allophone is a resident, usually an immigrant, whose mother tongue or home language is not French."
    5
    ## Example Task #4 Input:
    "CONTEXT": "Some are reported as not having been wanted at all.", "QUESTION": "", "ANSWER": "All are reported as being completely and fully wanted."
    ## Example Task #4 Output:
    1
    ## Actual Task Input:
    "CONTEXT": {context}, "QUESTION": "", "ANSWER": {answer}
    Reminder: The return values for each task should be correctly formatted as an integer between 1 and 5. Do not repeat the context and question.  Don't explain the reasoning. The answer should include only a number: 1, 2, 3, 4, or 5.
    Actual Task Output:
    ""

    metric_client = openai.AzureOpenAI(
        api_version=aoai_api_version,
        azure_endpoint=aoai_endpoint,
        api_key=aoai_key,
    )

    messages = [
        {
            "role": "system",

```

--------------------------------

### Navigate to project directory

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/apps/create-app.md

Change into the newly created project directory to begin development.

```bash
cd <your project directory>
```

--------------------------------

### Get driver log metadata sample request

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/driver-log.md

Example GET request to retrieve metadata for the stderr log file.

```HTTP
GET https://api.fabric.microsoft.com/v1/workspaces/aaaabbbb-0000-cccc-1111-dddd2222eeee/notebooks/bbbbcccc-1111-dddd-2222-eeee3333ffff/livySessions/ccccdddd-2222-eeee-3333-ffff4444aaaa/applications/application_1741176604085_0001/logs?type=driver&meta=true&fileName=stderr
```

--------------------------------

### Clone the React starter application

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/api-graphql-develop-vs-code.md

Download the sample repository from GitHub and navigate to the specific project directory.

```bash
git clone https://github.com/microsoft/fabric-samples.git
cd fabric-samples/docs-samples/data-engineering/GraphQL/React-Apollo-TS
```

--------------------------------

### Start Development Server

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/api-graphql-develop-vs-code.md

Command to launch the local development server.

```bash
npm run dev
```

--------------------------------

### Clone Starter-Kit Repository Locally

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/extensibility-toolkit/get-started.md

Clone the Starter-Kit repository to your local machine and navigate into the project directory. Ensure you have Git installed.

```pwsh
git clone https://github.com/<your-account>/fabric-extensibility-toolkit.git
cd fabric-extensibility-toolkit
```

--------------------------------

### Initialize project with uv

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/database/sql/connect-python-bulk-copy.md

Initialize a new project named 'mssql-python-bcp-qs' using the 'uv' tool. This command sets up the project structure.

```bash
uv init mssql-python-bcp-qs
cd mssql-python-bcp-qs
```

--------------------------------

### Install Node.js dependencies for API call

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/api-graphql-service-principal.md

Install the necessary packages, @azure/identity for authentication and axios for making HTTP requests, to complete the Node.js example.

```bash
npm install @azure/identity axios
```

--------------------------------

### Get Start of Month for Timestamp

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-factory/expression-language.md

Use this function to get the first day of the month for a given timestamp. The default timestamp format is ISO 8601.

```fabric
startOfMonth('2018-03-15T13:30:30Z')
```

--------------------------------

### Full rayfin.yml Configuration Example

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/apps/project-structure.md

This is a comprehensive example of the `rayfin/rayfin.yml` file, illustrating various service configurations including authentication, data, and static hosting. It demonstrates environment variable interpolation.

```yaml
id: my-app
name: my-app
version: 1.0.0
services:
  auth:
    enabled: true
    expiryInMinutes: 60
    refreshToken:
      lifetimeInDays: 30
    customClaims:
      tenant: "default"
    scopes:
      - read:data
      - write:data
    allowedRedirectUris:
      - http://localhost:5173
      - http://localhost:5173/auth/callback
    password:
      enabled: true
    fabric:
      enabled: false
    passwordless:
      magicLink:
        enabled: false
        expiryMinutes: 15
      smsOtp:
        enabled: false
    email:
      enabled: false
      provider: smtp
      senderName: Rayfin Platform
      verificationTokenExpirationHours: 24
      passwordResetTokenExpirationMinutes: 30
      smtp:
        host: maildev
        port: 1025
        senderEmail: noreply@rayfin.local
        username: ""
        password: ""
        useSsl: false
        useStartTls: false
        webPort: 1080
  data:
    enabled: true
    dialect: mssql
  storage:
    enabled: false
  staticHosting:
    enabled: true
    root: .
    folder: dist
    buildCommand: npm run build
    indexDocument: index.html
```

--------------------------------

### Initialize a new Python project with uv

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/database/sql/connect-jupyter-notebook.md

Create a new project directory and initialize it using the uv tool. Navigate into the newly created project directory.

```bash
uv init jupyter-notebook-qs
cd jupyter-notebook-qs
```

--------------------------------

### Get start of hour

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-factory/expression-language.md

Returns the timestamp adjusted to the zero-minute mark of the hour.

```text
startOfHour('<timestamp>', '<format>'?)
```

```text
startOfHour('2018-03-15T13:30:30Z')
```

--------------------------------

### Install Frontend Project Dependencies

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/workload-development-kit/extensibility-front-end.md

Run this command in the \"Frontend\" folder of the cloned repository to install all necessary project files and dependencies.

```console
<repository folder>\Frontend> npm install
```

--------------------------------

### Get start of day

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-factory/expression-language.md

Returns the timestamp adjusted to the zero-hour mark of the day.

```text
startOfDay('<timestamp>', '<format>'?)
```

```text
startOfDay('2018-03-15T13:30:30Z')
```

--------------------------------

### List Available Rayfin Project Templates

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/apps/cli-reference.md

Before initializing a project, use this command to see all available templates that can be used for scaffolding.

```bash
npx rayfin init --list-templates
```

--------------------------------

### Start the Frontend

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/workload-development-kit/quickstart-sample.md

Execute this command to start the frontend application. A success message will appear in PowerShell, and your web browser will open to the specified URL.

```bash
npm start
```

--------------------------------

### OneLake SAS URI Example

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/onelake/how-to-create-a-onelake-shared-access-signature.md

This is a complete example of a OneLake SAS URI. It includes parameters for permissions, start and expiry times, object and tenant IDs, signature, and resource type.

```http
https://onelake.blob.fabric.microsoft.com/myWorkspace/myLakehouse.Lakehouse/Files/?sp=rw&st=2023-05-24T01:13:55Z&se=2023-05-24T09:13:55Z&skoid=<object-id>&sktid=<tenant-id>&skt=2023-05-24T01:13:55Z&ske=2023-05-24T09:13:55Z&sks=b&skv=2022-11-02&sv=2022-11-02&sr=d&sig=<signature>
```

--------------------------------

### Get Size of a Table with GUIDs in OneLake

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/onelake/how-to-get-item-size.md

Use this snippet to determine the size of a table within OneLake when the workspace and table paths are represented by GUIDs. This is useful for programmatic access to tables.

```powershell
$ctx = New-AzStorageContext -StorageAccountName 'onelake' -UseConnectedAccount -endpoint 'fabric.microsoft.com'
$workspaceName = 'aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb'
$itemPath = 'bbbbbbbb-1111-2222-3333-cccccccccccc/Tables/table1'
$colitems = Get-AzDataLakeGen2ChildItem -Context $ctx -FileSystem $workspaceName -Path $itemPath -Recurse -FetchProperty | Measure-Object -property Length -sum
"Total file size: " + ($colitems.sum / 1GB) + " GB"
```

--------------------------------

### Complete Example: Analyzing Shortcut Data

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/extensibility-toolkit/how-to-create-shortcut.md

A full example demonstrating how to find all shortcuts in a directory, iterate through them, and analyze their contents, including reading file previews.

```typescript
async function analyzeShortcutData(workspaceId: string, itemId: string) {
  const storageClient = new OneLakeStorageClient(workloadClient);
  
  try {
    const dirMetadata = storageClient.getPathMetadata(
      workspaceId,
      `${itemId}/Files`,
      false,
      true // Get shortcut info
    );

    const shortcuts = dirMetadata.paths.filter(path => path.isShortcut);
    console.log(`Found ${shortcuts.length} shortcuts`);

    for (const shortcut of shortcuts) {
      console.log(`
Analyzing shortcut: ${shortcut.name}`);
      
      const shortcutContent = storageClient.getPathMetadata(
        workspaceId,
        `${itemId}/Files/${shortcut.name}`,
        true,  // recursive to see all files
        false  // get actual content, not shortcut metadata
      );

      console.log(`  - Contains ${shortcutContent.paths.length} items`);
      
      const files = shortcutContent.paths.filter(p => !p.isDirectory);
      for (const file of files) {
        console.log(`  - File: ${file.name} (${file.contentLength} bytes)`);
        
        if (file.name.endsWith('.txt') || file.name.endsWith('.csv')) {
          try {
            const content = await storageClient.readFileAsText(
              OneLakeStorageClient.getPath(workspaceId, itemId, `Files/${shortcut.name}/${file.name}`)
            );
            console.log(`    Preview: ${content.substring(0, 100)}...`);
          } catch (error) {
            console.log(`    Could not read file: ${error.message}`);
          }
        }
      }
    }
  } catch (error) {
    console.error('Error analyzing shortcut data:', error);
  }
}
```

--------------------------------

### Initialize Project with uv

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/database/sql/connect-python.md

Initializes a new Python project using uv for dependency management and sets up the project directory.

```bash
uv init rapid-prototyping-qs
cd rapid-prototyping-qs
```

--------------------------------

### Get Tables Mirroring Status

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/mirroring/mirrored-database-rest-api.md

Retrieves the status and metrics of table replication for a mirrored database. This API is applicable when mirroring is started and the 'Get mirroring status' API returns a 'Running' status.

```APIDOC
## POST /v1/workspaces/{workspace ID}/mirroredDatabases/{mirrored database ID}/getTablesMirroringStatus

### Description
Retrieves the status and metrics of tables replication for a mirrored database when mirroring is running.

### Method
POST

### Endpoint
/v1/workspaces/{workspace ID}/mirroredDatabases/{mirrored database ID}/getTablesMirroringStatus

### Parameters
#### Path Parameters
- **workspace ID** (string) - Required - The ID of the workspace.
- **mirrored database ID** (string) - Required - The ID of the mirrored database.

### Request Example
```json
{
    "example": "POST https://api.fabric.microsoft.com/v1/workspaces/<your workspace ID>/mirroredDatabases/<mirrored database ID>/getTablesMirroringStatus"
}
```

### Response
#### Success Response (200)
- **continuationToken** (string) - Description: Token for pagination, if more results are available.
- **continuationUri** (string) - Description: URI for pagination, if more results are available.
- **data** (array) - Description: An array of table mirroring statuses.
  - **sourceSchemaName** (string) - Description: The name of the source schema.
  - **sourceTableName** (string) - Description: The name of the source table.
  - **status** (string) - Description: The current mirroring status of the table (e.g., 'Replicating').
  - **metrics** (object) - Description: Metrics related to the table replication.
    - **processedBytes** (integer) - Description: The total number of bytes processed.
    - **processedRows** (integer) - Description: The total number of rows processed.
    - **lastSyncDateTime** (string) - Description: The date and time of the last synchronization.

#### Response Example
```json
{
    "continuationToken": null,
    "continuationUri": null,
    "data": [
        {
            "sourceSchemaName": "dbo",
            "sourceTableName": "test",
            "status": "Replicating",
            "metrics": {
                "processedBytes": 1247,
                "processedRows": 6,
                "lastSyncDateTime": "2024-10-08T05:07:11.0663362Z"
            }
        }
    ]
}
```
```

--------------------------------

### Create and Initialize Project

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/apps/dev-prod-workflow.md

Scaffold a new Fabric app from a template or initialize Rayfin in an existing project. Navigate into the project directory after creation.

```bash
npm create @microsoft/rayfin@latest my-app --workspace my-app-dev
cd my-app
```

```bash
npx rayfin init
```

--------------------------------

### Example response for Get Item Job Instance

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/notebook-public-api.md

This JSON response shows the structure of the data returned by the Get Item Job Instance API, including the run status and exit value.

```json
{
  "id": "<jobInstanceId>",
  "itemId": "<notebookId>",
  "jobType": "RunNotebook",
  "invokeType": "OnDemand",
  "status": "Completed",
  "startTimeUtc": "2026-03-01T10:00:00Z",
  "endTimeUtc": "2026-03-01T10:05:00Z",
  "failureReason": null,
  "exitValue": "success"
}
```

--------------------------------

### Start Mirrored Database Mirroring

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/mirroring/mirrored-database-rest-api.md

Use this POST request to initiate the mirroring process for a specified mirrored database. Note that mirroring cannot be started if the current status is 'Initializing'.

```HTTP
POST https://api.fabric.microsoft.com/v1/workspaces/<your workspace ID>/mirroredDatabases/<mirrored database ID>/startMirroring
```

--------------------------------

### Get data artifact table details

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/admin/operation-list.md

Retrieves the details (for example, schema) for a data item table.

```APIDOC
## GetDataArtifactTableDetails

### Description
Retrieves the details (for example, schema) for a data item table.

### Method
GET

### Endpoint
/api/artifacts/tables/{tableId}/details
```

--------------------------------

### Create Directories with NotebookUtils

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/notebookutils/notebookutils-file-system.md

Examples of creating directories using different path formats for Lakehouse and local file systems.

```python
notebookutils.fs.mkdirs("abfss://<container_name>@<storage_account_name>.dfs.core.windows.net/<new_dir>")
```

```python
notebookutils.fs.mkdirs("file:/<new_dir>")
```

```python
notebookutils.fs.mkdirs("Files/<new_dir>")
```

--------------------------------

### Get Livy log content sample request

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/livy-log.md

Example request for retrieving the content of a Livy log.

```HTTP
GET https://api.fabric.microsoft.com/v1/workspaces/aaaabbbb-0000-cccc-1111-dddd2222eeee/notebooks/bbbbcccc-1111-dddd-2222-eeee3333ffff/livySessions/ccccdddd-2222-eeee-3333-ffff4444aaaa/application/none/logs?type=livy
```

--------------------------------

### Retrieve Spark Advice

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/spark-advisor-api.md

Example HTTP GET request to fetch advice for a specific Spark job group.

```HTTP
GET https://api.fabric.microsoft.com/v1/workspaces/aaaabbbb-0000-cccc-1111-dddd2222eeee/notebooks/11bb11bb-cc22-dd33-ee44-55ff55ff55ff/livySessions/0a0a0a0a-1111-bbbb-2222-3c3c3c3c3c3c/applications/application_11111111111110001/1/advice/jobGroups/6
```

--------------------------------

### Access Single Variable by Reference

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/notebookutils/notebookutils-variable-library.md

Examples of how to access a single variable value using its reference path with the `get()` method.

```APIDOC
## Access a Single Variable by Reference

### Description
Use the `get()` method with the reference pattern `$(/**/libraryName/variableName)` to retrieve a single variable value. The value is automatically typed based on the variable definition.

> [!IMPORTANT]
The `/**/` prefix is required in the reference pattern. The full pattern must be `$(/**/libraryName/variableName)`, where `libraryName` is the exact variable library item name and `variableName` is the defined variable in that library. Names are case-sensitive.

### Method
`get`

### Endpoint
Not applicable (in-notebook utility)

### Parameters
#### Path Parameters
None

#### Query Parameters
None

#### Request Body
None

### Request Example
```python
notebookutils.variableLibrary.get("$(/**/samplevl/test_int)")
notebookutils.variableLibrary.get("$(/**/samplevl/test_str)")
notebookutils.variableLibrary.get("$(/**/samplevl/test_bool)")
```

### Response
#### Success Response (200)
- **Any** (any) - The retrieved single variable value, automatically typed.

#### Response Example
```json
123
"hello"
true
```
```

--------------------------------

### Navigate to Script Directory

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/extensibility-toolkit/tutorial-create-entra-app.md

Change the current directory to the location of the setup scripts. Ensure you have PowerShell 7.x or later installed.

```powershell
cd scripts/Setup
```

--------------------------------

### Example Connection String: With Spark Resource Configuration

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/spark-jdbc-driver.md

Shows how to configure Spark resources like cores, memory, and number of executors within the connection string.

```plaintext
jdbc:fabricspark://api.fabric.microsoft.com;FabricWorkspaceID=<workspace-id>;FabricLakehouseID=<lakehouse-id>;DriverCores=4;DriverMemory=4g;ExecutorCores=4;ExecutorMemory=8g;NumExecutors=2;AuthFlow=2
```

--------------------------------

### Example Connection Strings

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/data-engineering/spark-adonet-driver.md

Illustrative examples of connection strings demonstrating various configurations.

```APIDOC
## Example Connection Strings

### Basic Connection (Azure CLI Authentication)

```
Server=https://api.fabric.microsoft.com/v1;SparkServerType=Fabric;FabricWorkspaceID=<workspace-id>;FabricLakehouseID=<lakehouse-id>;AuthFlow=AzureCli
```

### With Connection Pooling Options

```
Server=https://api.fabric.microsoft.com/v1;SparkServerType=Fabric;FabricWorkspaceID=<workspace-id>;FabricLakehouseID=<lakehouse-id>;AuthFlow=AzureCli;ConnectionPoolEnabled=true;MinPoolSize=2;MaxPoolSize=10
```

### With Auto-Reconnect and Logging

```
Server=https://api.fabric.microsoft.com/v1;SparkServerType=Fabric;FabricWorkspaceID=<workspace-id>;FabricLakehouseID=<lakehouse-id>;AuthFlow=AzureCli;AutoReconnect=true;LogLevel=Debug
```
```

--------------------------------

### Define Pipeline Deployment Steps

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/cicd/tutorial-fabric-cicd-azure-devops.md

Executes the checkout, Python environment setup, dependency installation, and the deployment script execution.

```yaml
    steps:
    # Step 1: Checkout the source code
    - checkout: self

    # Step 2: Set up Python 3.12
    - task: UsePythonVersion@0
     inputs:
     versionSpec: '3.12'
     addToPath: true
     displayName: "Set up Python Environment"

    # Step 3: Install dependencies
    - script: |
     python -m pip install --upgrade pip
     pip install fabric-cicd
     displayName: "Install Fabric CICD Library"

    # Step 4: Run the deployment script
    - task: PythonScript@0
     inputs:
     scriptSource: 'filePath'
     scriptPath: '.deploy/deploy-to-fabric.py'
     arguments: >-
      --aztenantid $(aztenantid)
      --azclientid $(azclientid)
      --azspsecret $(azspnsecret)
      --items_in_scope ${{ parameters.items_in_scope }}
      --target_env $(target_env)
     displayName: 'Run deployment using fabric-cicd'
```

--------------------------------

### Example Agent System Prompt

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/iq/ontology/how-to-create-agent-foundry-iq.md

Define the role and capabilities of your agent. This prompt guides the agent's behavior and response generation.

```text
You are a sales insights assistant. Answer questions about stores, products, sales and freezer telemetry events using the retail sales knowledge base. Always cite the entities you used.
```

--------------------------------

### Set Up Extract Checkpoints and Start Extract

Source: https://github.com/microsoftdocs/fabric-docs/blob/main/docs/real-time-intelligence/event-streams/stream-oracle-data-to-eventstream.md

Add the extract and remote trail, then start the EXT1 extract process. Verify its status.

```bash
GGSCI> ADD EXTRACT EXT1, INTEGRATED TRANLOG, BEGIN NOW
GGSCI> ADD RMTTRAIL ./dirdat/rt, EXTRACT EXT1, MEGABYTES 10

RMTTRAIL added.

GGSCI> START EXTRACT EXT1

Sending START request to MANAGER ...
EXTRACT EXT1 starting

GGSCI> INFO ALL

Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     EXTORA      00:00:11      00:00:04

GGSCI > EXIT
```