Base
Hardened build
minimal ports, security patches applied at build time
OpenRefine 3.10 on Ubuntu 24.04 LTS
Azure
Analytics
OpenRefine, a browser based workbench for exploring, cleaning and transforming messy tabular data with no coding required.
Overview
OpenRefine is a free, open source power tool for working with messy data. Import tabular data from CSV, TSV, Excel, JSON or XML into a project workbench, then explore it with facets and filters, clean and normalise values with GREL, Jython or Clojure expressions, cluster and merge near duplicate entries, and reconcile your data against external sources such as Wikidata. Every change is recorded as a reproducible operation history you can undo, redo and export, so a whole cleanup can be replayed on a fresh dataset.
It suits data teams, journalists, librarians, researchers and analysts who need to turn inconsistent spreadsheets and exports into clean, structured data, all in a self hosted workbench where the data never leaves their own instance.
Why the cloudimg image
cloudimg delivers OpenRefine fully installed and running behind an nginx reverse proxy, so the workbench answers the moment the instance boots with no Java, service or web server setup. Because OpenRefine has no built in login, the image is secure by default and carries no usable credential at all: OpenRefine binds only to loopback so the reverse proxy is the sole way in, and on the first boot of every instance a one shot service generates a fresh administrator password unique to that instance, writing it to a file only the root user can read. The base OS is fully patched with unattended security upgrades enabled, and every deployment is paired with a step by step deploy guide and backed by 24/7 cloudimg support.
Common uses
- Cleaning and normalising messy CSV, Excel and JSON exports into consistent, structured data
- Clustering and reconciling near duplicate values against external sources such as Wikidata
- A self hosted, reproducible data cleanup workbench where your data never leaves your own instance
See it running
Real screenshots taken while testing this image against its deployment guide.
More in Analytics
Apache Airflow - Workflow Orchestration
Analytics
This image runs Apache Airflow as a single node deployment. Airflow is installed into a dedicated Python virtual environ...
Apache Flink Stream Processing
Analytics
Apache Flink is the open source framework and distributed processing engine for stateful computations over unbounded and...
Apache NiFi Dataflow Automation
Analytics
This image runs Apache NiFi, the open source dataflow automation platform, as a single node deployment.
Apache Spark Single-Node Cluster
Analytics
This image runs Apache Spark 4.1.2 (built for Hadoop 3) as a single node standalone cluster.
Apache Superset BI Platform
Analytics
This image runs Apache Superset, the open source data exploration and business intelligence platform, as a complete sing...
Az
Apache Zeppelin
Analytics
This image runs Apache Zeppelin, the open source web based notebook that brings data ingestion, exploration, visualisati...