Profile .yml details executing from local windows,
link reffer to build profile.yml is
and profile.yml is as below
Day0_DataLoad:
target: dev
outputs:
dev:
type: sqlserver
driver: ODBC Driver 17 for SQL Server
server: LIVEDB
port: 10501
database: database
schema: LIVEDB_STAGE
windows_login: True
The problem I’m having
Getting error for sqlserver profile.yml
“mapping values are not allowed in this context
in “”, line 3, column 10”
C:\Users\dbt_POC\Day0_DataLoad>dbt debug
06:40:02 Running with dbt=1.7.11
06:40:02 dbt version: 1.7.11
06:40:02 python version: 3.11.5
06:40:02 python path: C:\Users.conda\envs\dev\python.exe
06:40:02 os info: Windows-10-10.0.19045-SP0
06:40:02 Encountered an error:
Runtime Error
Syntax error near line 3
1 | Day0_DataLoad:
2 | target: dev
3 | outputs:
4 | dev:
5 | type: sqlserver
6 | driver: ODBC Driver 17 for SQL Server
Raw Error:
mapping values are not allowed in this context
in “”, line 3, column 10
The context of why I’m trying to do this
I am new to dbt and trying to setup a dbt connectivity and project for transformation use cases
What I’ve already tried
Some example code or error messages
Put code inside backticks
to preserve indentation
which is especially important
for Python and YAML!