airflow-etl-mssql-sample/docker-compose.yml at master · laudio/airflow-etl-mssql-sample · 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
version: '3'
services:
  postgres:
    image: postgres:10
    container_name: airflow-db
    environment:
      - POSTGRES_USER=${AIRFLOW_DB_USER:-airflow}
      - POSTGRES_PASSWORD=${AIRFLOW_DB_PASSWORD:-airflow}
      - POSTGRES_DB=${AIRFLOW_DB:-airflow}
    ports:
      - ${AIRFLOW_DB_EXT_PORT:-5444}:5432
    volumes:
      - '${AIRFLOW_DB_DATA_PATH:-./.pgdata}:/var/lib/postgresql/data'

  mssql:
    image: microsoft/mssql-server-linux:latest
    container_name: airflow-mssql
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=Th1sS3cret!
    ports:
      - 1444:1433

  airflow:
    image: laudio/airflow-mssql:1.0.5
    container_name: airflow
    restart: always
    depends_on:
      - postgres
      - mssql
    environment:
      - LOAD_EX=n
      - EXECUTOR=Local
      - FERNET_KEY=${FERNET_KEY}
      - AIRFLOW__CORE__FERNET_KEY=${AIRFLOW__CORE__FERNET_KEY}
      - PATH=/usr/local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/opt/mssql-tools/bin:/usr/local/airflow/.local/bin

    volumes:
      - ~/.ssh:/usr/local/airflow/.ssh
      - ./src/dags:/usr/local/airflow/dags
      - ./src/etl:/usr/local/airflow/etl
      - ./src/sql:/usr/local/airflow/sql
      - ./src/scripts:/usr/local/airflow/scripts
      - ./src/config/airflow.cfg:/usr/local/airflow/airflow.cfg
      - ./data:/usr/local/airflow/data
    ports:
      - ${AIRFLOW_WEB_EXT_PORT:-8081}:8080
    command: webserver