dbt-sqlserver icon indicating copy to clipboard operation
dbt-sqlserver copied to clipboard

"No sample profile found for sqlserver" when running dbt init

Open jrschueller opened this issue 1 year ago • 3 comments

Describe the bug

I am attempting to initialize a dbt project and create a profiles.yml file. Doing so returns an error of No sample profile found for sqlserver.

Steps To Reproduce

After installing dbt-sqlserver and its dependencies, run dbt init and select the sqlserver option as the database to use for building the profile, e.g.

dbt init

19:54:03  Running with dbt=1.3.4
19:54:04  Setting up your profile.

Which database would you like to use?
[1] sqlserver

(Don't see the one you want? https://docs.getdbt.com/docs/available-adapters)

Enter a number: 1

Expected Behavior

Successfully generate profiles.yml

System Information

Which database are you using dbt with?

  • [ ] postgres
  • [ ] redshift
  • [ ] bigquery
  • [ ] snowflake
  • [x] other (specify: Azure SQL)

The output of dbt --version:

Core:
  - installed: 1.3.4
  - latest:    1.5.1 - Update available!

  Your version of dbt-core is out of date!
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:
  - sqlserver: 1.3.2 - Update available!

  At least one plugin is out of date or incompatible with dbt-core.
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:

  • sqlserver: 1.3.2

The operating system you're using: Windows 10 Enterprise version 22H2, OS build 19045.2965

The output of python --version:

Python 3.10.11

jrschueller avatar Jun 21 '23 20:06 jrschueller