stuck trying to get started with dbt

[jonjoseph]

I tried following the dbt-fabric tutorial in MS learning but am stuck.

It appears CLI logon doesnt work so I set up a service principal, unfortunately the instructions on how to configure the profile for this are vague and I'm getting nowhere.

Has anybody managed to set this up or know of any good tutorials that are geared to newbies to python/ dbt/ cloud.

My profile.yml is currently:   

jaffle_shop:
target: fabric-dev
outputs:
fabric-dev:
type: fabric
driver: ODBC Driver 18 for SQL Server
server: localhost -- ? what should this be
port: 1433 ??
authentication: ServicePrincipal
host: ??
schema: dbo
tenant_id: 
client_id: 
client_secret: 

, left out the service principal details. This is returns an ERROR invalid

Runtime Error
Credentials in profile "jaffle_shop", target "fabric-dev" invalid: Runtime Error
Got duplicate keys: (server) all map to "host"

No idea what to do next.

[v-cboorla-msft]

Hi @jonjoseph 

Thanks for using Microsoft Fabric Community.

Could you please confrim which document are you following? As I see that the profiles.yml configuration is bit different from the documentation.

Just wanted to know how you got landed up here with above profile.yml configuration.

Thanks

[jonjoseph]

I got it from Microsoft Fabric Synapse Data Warehouse setup | dbt Developer Hub (getdbt.com)

As the only option in Set up dbt for Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn uses CLI which doesnt seem to work. The links for service principal are not helpful.

[v-cboorla-msft]

Hi @jonjoseph 

Apologies for the delay in the response.

Following up to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks

[v-cboorla-msft]

Hi @jonjoseph 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks