dbt_duckdb_sqlserver/docker-compose.yml at main · oluies/dbt_duckdb_sqlserver · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
# docker-compose.yml

services:
  minio:
    image: minio/minio:RELEASE.2025-09-07T16-13-09Z
    container_name: minio-dbt-duckdb
    ports:
      - "9000:9000"
      - "9001:9001"
    environment:
      MINIO_ROOT_USER: minioadmin
      MINIO_ROOT_PASSWORD: minioadminpassword
    command: server /data --console-address ":9001"
    volumes:
      - minio_data:/data

  mssql:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: mssql-dbt-duckdb
    ports:
      - "1433:1433"
    environment:
      ACCEPT_EULA: "Y"
      MSSQL_SA_PASSWORD: "MySecretPassword123!"
    volumes:
      - mssql_data:/var/opt/mssql

  # Reusable dev environment for dbt + pipeline scripts.
  # Only runs when invoked under the `dev` profile, e.g.:
  #     docker compose --profile dev up -d dbt-runner
  #     docker compose --profile dev run --rm dbt-runner bash
  # Also used as the target for the VS Code devcontainer.
  dbt-runner:
    build:
      context: .
      dockerfile: Dockerfile
    image: dbt-fidemo:latest
    container_name: dbt-fidemo-runner
    profiles: ["dev"]
    depends_on:
      - minio
      - mssql
    volumes:
      - .:/workspace:cached
    working_dir: /workspace
    # Service-name networking: the env vars baked into the image already
    # point at `mssql-dbt-duckdb` and `minio-dbt-duckdb`, so no override
    # is needed when running inside the compose network. Exposed here
    # explicitly for visibility / easy override.
    environment:
      MSSQL_HOST: mssql-dbt-duckdb
      MSSQL_PORT: 1433
      MSSQL_DB: fidemo
      MSSQL_USER: fidemo_loader
      MSSQL_PWD: StrongPassword456!
      MINIO_ENDPOINT_HOSTPORT: minio-dbt-duckdb:9000
      MINIO_ACCESS_KEY: minioadmin
      MINIO_SECRET_KEY: minioadminpassword
      MSSQL_DUCKDB_CONN: "Server=mssql-dbt-duckdb,1433;Database=fidemo;User Id=fidemo_loader;Password=StrongPassword456!;TrustServerCertificate=true"
    # Keep alive for `docker exec` / devcontainer attach.
    command: sleep infinity

volumes:
  minio_data:
  mssql_data: