Hi! I'm trying a simple custom dbt transformation where I insert only one field instead of n in a table. In the log I found: "Could not find adapter type sqlserver!". I tried to run dbt alone and it works. Also, the basic normalization without any custom one, works. What it colud be? Thanks!

can you share a screenshot of your connection?

Sure! Here we go:

Hey If I understand it right both

Basic normalisation

and

No Normalisation

work without the custom normalisation ? If so do you mind running just the Custom DBT seperately and check if it doing good ? Is that something worth trying ?

@Fausto check the video

Thanks for your replies! Anyway, I was not able to sync it, so I'm trying to reproduce what you did in the video. I created both the pokeAPI source and a valid postgres destination. Both the raw and normalized ingestion works, but when I try to use my own it doesn't. I ran a basic normalization, after that i copied the configuration with this command: 

docker cp airbyte-server:/tmp/workspace/$NORMALIZE_WORKSPACE/normalize/ $TUTORIAL_DIR/normalization-files

 . Then, I removed the profiles.yml file, and changed the dbt_module path inside the dbt_project.yml to "../dbt_models" as you suggested. After this step, I modified the connection to "RAW DATA" and added both steps (deps and run command) linked to my private repository. i tried to run this command 

docker run --rm --init -i -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -w /data/16/0/transform --network host --log-driver none --entrypoint /bin/bash fishtownanalytics/dbt:0.19.1 entrypoint.sh deps

and I get this:

Running from /data/16/0/transform/git_repo
detected no config file for ssh, assuming ssh is off.
Running: dbt deps --profiles-dir=/data/16/0/transform --project-dir=/data/16/0/transform/git_repo
Running with dbt=0.19.1
Encountered an error while reading the project:
  ERROR: Runtime Error
  at path []: Additional properties are not allowed ('dispatch' was unexpected)

Error encountered in /data/16/0/transform/git_repo/dbt_project.yml
Encountered an error:
Runtime Error
  Could not run dbt

Do I have to change the dbt_project.yml in something different? I hope I explained myself clearly 🙂 Thank you so much!

Are you trying to copy a private repo from Github? Then I recommend to read this doc https://docs.airbyte.io/operator-guides/transformation-and-normalization/transformations-with-airbyte let me know if you'd already read then

Yes, the repo is on Gitlab. I read it but I think I'm missing something. Thanks!