The problem I’m having
After generate docs EXAMPLE CODE section doesn’t show table name.
What I’ve already tried
Many tries. Many YML configs. Many approaches.
- I’ve define alias: Kalendarz and there is not different.
- I’ve added database and schema and my schema was change to “dbo_dbo”
- When my csv header had a space DateSK,DateNK,Date and I defined colums section, my column list was double!
That’s why I remove all configuration. My dbt_project is “empty”.
name: ‘dbt_demo’
version: ‘1.0.0’
profile: ‘dbt_demo’
model-paths: [“models”]
analysis-paths: [“analyses”]
test-paths: [“tests”]
seed-paths: [“seeds”]
macro-paths: [“macros”]
snapshot-paths: [“snapshots”]
clean-targets: # directories to be removed bydbt clean
- “target”
- “dbt_packages”
# models:
# dbt_demo:
# # Config indicated by + and applies to all files under models/example/
# example:
# +materialized: view
seeds/Kalendarz.csv
DateSK,DateNK,Date
-2,NieZnam,
-1,NieWiem,
1,2025-01-01,2025-01-01
2,2025-01-31,2025-01-31
3,2025-02-01,2025-02-01
4,2025-02-28,2025-02-28
5,2025-03-01,2025-03-01
6,2025-03-31,2025-03-31
PS C:\Users\Dell\Documents\GitHub\DbtDemo> dbt debug
21:38:55 Running with dbt=1.9.6
21:38:55 dbt version: 1.9.6
21:38:55 python version: 3.12.8
21:38:55 python path: C:\Program Files\Python312\python.exe
21:38:55 os info: Windows-11-10.0.22631-SP0
21:38:56 Using profiles dir at C:\Users\Dell.dbt
21:38:56 Using profiles.yml file at C:\Users\Dell.dbt\profiles.yml
21:38:56 Using dbt_project.yml file at C:\Users\Dell\Documents\GitHub\DbtDemo\dbt_project.yml
21:38:56 adapter type: sqlserver
21:38:56 adapter version: 1.9.0
21:38:56 Configuration:
21:38:56 profiles.yml file [OK found and valid]
21:38:56 dbt_project.yml file [OK found and valid]
21:38:56 Required dependencies:
21:38:56 - git [OK found]21:38:56 Connection:
21:38:56 server: DESKTOP-H2AE9IH\SQL2022
21:38:56 database: dbt_DEMO
21:38:56 schema: dbo
21:38:56 UID: None
21:38:56 client_id: None
21:38:56 authentication: Windows Login
21:38:56 encrypt: True
21:38:56 trust_cert: True
21:38:56 retries: 3
21:38:56 login_timeout: 0
21:38:56 query_timeout: 0
21:38:56 trace_flag: False
21:38:56 port: 1433
21:38:56 Registered adapter: sqlserver=1.9.0
21:38:57 Connection test: [OK connection ok]
21:38:57 All checks passed!
PS C:\Users\Dell\Documents\GitHub\DbtDemo> dbt list
21:40:00 Running with dbt=1.9.6
21:40:01 Registered adapter: sqlserver=1.9.0
21:40:01 Unable to do partial parsing because saved manifest not found. Starting full parse.
dbt_demo.Kalendarz
I don’t have any spec YML configuration.
PS C:\Users\Dell> dbt -v
Core:
- installed: 1.9.6
- latest: 1.9.6 - Up to date!
Plugins:
- duckdb: 1.9.3 - Up to date!
- fabric: 1.9.3 - Update available!
- sqlserver: 1.9.0 - Up to date!
At least one plugin is out of date with dbt-core.
You can find instructions for upgrading here:
About dbt Core and installation | dbt Developer Hub
I’m using SQL Server as my project DB.
dbt seed create dbo.Kalendarz on DB (works!)
dbt list (works!) - show dbt_demo.Kalendarz
Everything works fine except docs.