Azure / Azure/data-api-builder

[Bug]: auto-config-simulate - fails to read config

Open
#3,791 1 comment 0 reactions 0 assignees View on GitHub
bug triage
Dominant language
C#
Stars
1.5k
Forks
370
Avg merge
3d 17h
Merged PRs (30d)
8

Description

### What happened?

Getting an error when trying to use `auto-config-simulate` against a local sql server container. But it works and exposes the entities successfully when I do `dab start`

1. create the config against local dbatools container (password is shared online so not a concern)
```powershell
dab init --database-type "mssql" --host-mode "Development" --connection-string "Server=localhost,2500;User Id=sqladmin;Database=pubs;Password=dbatools.IO;TrustServerCertificate=True;Encrypt=True;"
```

2. add the `dbo.%` pattern
```powershell
dab auto-config pubs-tables `
--patterns.include "dbo.%" `
--permissions "anonymous:read"
```

3. view the config it looks good

```powershell
cat .\dab-config.json
```

```text
{
"$schema": "https://github.com/Azure/data-api-builder/releases/download/v2.0.12/dab.draft.schema.json",
"data-source": {
"database-type": "mssql",
"connection-string": "Server=localhost,2500;User Id=sqladmin;Database=pubs;Password=dbatools.IO;TrustServerCertificate=True;Encrypt=True;",
"options": {
"set-session-context": false
}
},
"runtime": {
"rest": {
"enabled": true,
"path": "/api",
"request-body-strict": false
},
"graphql": {
"enabled": true,
"path": "/graphql",
"allow-introspection": true
},
"mcp": {
"enabled": true,
"path": "/mcp"
},
"host": {
"cors": {
"origins": [],
"allow-credentials": false
},
"authentication": {
"provider": "Unauthenticated"
},
"mode": "development"
},
"telemetry": {
"open-telemetry": {
"enabled": true,
"endpoint": "@env('OTEL_EXPORTER_OTLP_ENDPOINT')",
"headers": "@env('OTEL_EXPORTER_OTLP_HEADERS')",
"service-name": "@env('OTEL_SERVICE_NAME')"
}
}
},
"autoentities": {
"pubs-tables": {
"patterns": {
"include": [
"dbo.%"
]
},
"permissions": [
{
"role": "anonymous",
"actions": [
{
"action": "read"
}
]
}
]
}
},
"entities": {}
}
```

4. run the simulate
```powershell
❯ dab auto-config-simulate -c .\dab-config.json
```
get errors
```text
info: Microsoft.DataApiBuilder 2.0.12
info: User provided config file: .\dab-config.json
fail: Failed to read the config file: .\dab-config.json.
fail: Failed to simulate autoentities.
```

But if I do `dab start` the config is fine and all the dbo tables are exposed.

### Version

Microsoft.DataApiBuilder 2.0.12+0b38aa7cbf4118034ad8dee1f2712b1c4bac4c32

### What database are you using?

Azure SQL

### What hosting model are you using?

Local (including CLI)

### Which API approach are you accessing DAB through?

REST

### Relevant log output

```Text

```

### Code of Conduct

- [x] I agree to follow this project's Code of Conduct

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.