Dockerコマンド

docker compose up -d

docker compose logs -f

設定項目

https://qiita.com/kengo-sk8/items/7eb265513d9b0cf3e2df

データを挿入する

WITH dummy_data AS ( SELECT * FROM UNNEST([ STRUCT('値1' AS column1, '値2' AS column2), STRUCT('値3', '値4') ]) )

SELECT * FROM dummy_data;aaaaaaaaaaaaa

- ./sql:/var/lib/postgresql/sql 
- ./sql:/docker-entrypoint-initdb.d

docker exec -it metabase_db bash
psql -U metabase -d metabase_db < /var/lib/postgresql/sql/create_table_sale_data.sql

Metabaseをテストする

• 初期ユーザーアカウント

dev@example.com D)EN5x??ze9nw]z

Mail機能

MAIL_HOST=mailhog MAIL_PORT=1025 MAIL_FROM_ADDRESS=info@example.com

WITH dummy_data AS ( SELECT * FROM UNNEST([ STRUCT('値1' AS column1, '値2' AS column2), STRUCT('値3', '値4') ]) )

SELECT * FROM dummy_data;aaaaaaaaaaaaa

WITH date_range AS ( SELECT date FROM UNNEST(GENERATE_DATE_ARRAY('2023-01-01', '2023-01-10')) AS date )

SELECT date FROM date_range;aaaaaaaaa