The problem I’m having
The tutorial model does not run against PostgresQL 15
Pertinent libraries:
dbt-common-1.37.2
dbt-core-1.11.4
dbt-extractor-0.6.0
dbt-postgres-1.10.0
dbt-protos-1.0.431
dbt-semantic-interfaces-0.9.0
The context of why I’m trying to do this
What I’ve already tried
Some example code or error messages
bash-5.3$ dbt init
Installing dbt project and profile setup
Warning A dbt_project.yml already exists in this directory; skipping sample project creation.
Info dbt extension already recommended in .vscode/extensions.json, skipping
Info Setting up your profile...
Info Creating new profile...
Which adapter would you like to use?: postgres
No dbt_cloud.yml found - proceeding without cloud pre-population
Host (hostname): alembic.local
Username: postgres
Password: [hidden]
Port: 5432
Database name: warehouse
Schema (dbt schema): public
Success Profile written to /Users/jo/.dbt/profiles.yml
Validating profile inputs, adapters, and connection
dbt-fusion 2.0.0-preview.110
Loading ~/.dbt/profiles.yml
Debugging profile: dev
Debugging dbt version: 2.0.0-preview.110
Debugging platform: macos aarch64 (unix)
Debugging adapter type: postgres (remote)
Debugging dependencies:
git: OK
Debugging connection:
"port": 5432,
"database": "warehouse",
"schema": "public",
"host": "alembic.local",
"user": "postgres"
Debugging ⠒ [1s] Segmentation fault: 11 dbt init
bash-5.3$ dbtf compile
dbt-fusion 2.0.0-preview.110
Loading ~/.dbt/profiles.yml
=================================================================================================================== Execution Summary ====================================================================================================================
Finished 'compile' successfully for target 'dev' [860ms]
Processed: 1 model
Summary: 1 total | 1 success
bash-5.3$ dbtf run
dbt-fusion 2.0.0-preview.110
Loading ~/.dbt/profiles.yml
panic: panicked at fs/sa/crates/dbt-adapter/src/metadata/postgres.rs:181:9:
not yet implemented: PostgresAdapter::create_schemas_if_not_exists
bash-5.3$ dbtf run
dbt-fusion 2.0.0-preview.110
Loading ~/.dbt/profiles.yml
panic: panicked at fs/sa/crates/dbt-adapter/src/metadata/postgres.rs:181:9:
not yet implemented: PostgresAdapter::create_schemas_if_not_exists