Apache Superset + Clickhouse + Import from Postgres (GreenPlum?) in Docker
Clone the repo
git clone https://github.com/emanaev/superset-demo.git
cd superset-demo
Edit local file odbc.ini for your Postgres (GreenPlum) datasource. Use the template replacing with your custom settings:
[<DSN_NAME>]
DRIVER = PostgreSQL ANSI
SERVERNAME = <POSTGRES_SERVER_DNS_OR_IP>
PORT = 5432
DATABASE = <POSTGRES_DATABASE_NAME>
USERNAME = <POSTGRES_LOGIN>
PASSWORD = <POSTGRES_PASSWORD>
Use DRIVER = Postgres ANSI for ANSI-encoded connections or DRIVER = Postgres Unicode for Unicode connections, see odbcinst.ini for details
Edit local file dsn.env. Replace <DSN_NAME> with approppriate name, setted in odbc.ini earlier, set list of tables to import:
DSN=<DSN_NAME>
TABLES=<TABLE_NAME_1>,<TABLE_NAME_2>,<TABLE_NAME_3,...
Start the core:
docker-compose build
docker-compose up -d postgres redis clickhouse
Start and init Superset. You will be prompted to create admin account. Remember the password:
docker-compose up -d superset
docker-compose exec superset superset-init
Run importer. It will copy table structure from Postgres (GreenPlum) to Clickhouse default database and fill it with data
docker-compose run script
Go to http://<LOCAL_IP>:8088, login with login/password settled earlier and create a database with type Clickhouse and server address clickhouse
Now you'll be able to see imported tables in default database. Use SQL Editor to surf them, or created your dashboards