Hi everyone, I am creating a POC. My source is openweather and the destination is MSSQL. I’ve created a dbt project with custom normalization based on the normalization that airbyte did in default sync. The normalization scripts sit on the synced data in mssql and it works perfectly when I run it locally. My problem is that I’d like to use it from airbyte, but it says that “No module named ‘dbt.adapters.sqlserver’. I assume that the dbt image should contain the required packages for sql server because that was needed for dbt to run locally too.
1. pic error
2. pic setup of the transformation
3. pic transformation steps
Could you please give me some advice on that? Should I add the necessary packages to the dbt image dockerfile or what I’m missing?
a
Abhay
01/19/2023, 8:11 PM
@Balazs Aszodi Hey Balazs,
Did you find any solution related to this problem??
b
Balazs Aszodi
01/20/2023, 8:28 AM
Hi @Abhay, Unfortunately, It was long time ago 😄 Since then, I’ve not worked with it. Once I have the time, I’ll check it out 🙂