;}%20.st6{fill:url(%23SVGID_00000021089067129159788970000008246765442136188072_);}%20.st7{fill:url(%23SVGID_00000117639240116366130650000015074833605515028638_);}%20.st8{opacity:0.4;fill:url(%23SVGID_00000101781798616409025840000016567063639337360777_);}%20.st9{opacity:0.4;fill:url(%23SVGID_00000052086836598721292040000002033117744178971046_);}%20.st10{opacity:0.4;fill:url(%23SVGID_00000159460939004760751800000002448009281983951536_);}%20.st11{opacity:0.4;fill:url(%23SVGID_00000013177830667419993080000017721442101626521532_);}%20.st12{opacity:0.4;fill:url(%23SVGID_00000152235521444854938490000006526001119318383285_);}%20.st13{opacity:0.4;fill:url(%23SVGID_00000119823135212293698520000012774889010992664993_);}%20%3c/style%3e%3cg%3e%3cpolygon%20class='st2'%20points='134.78,14.22%20114.31,48.21%20101.33,69.75%20158.22,69.75%20177.97,36.95%20191.67,14.22%20'/%3e%3cpolygon%20class='st3'%20points='227.55,69.75%20186.61,69.75%20101.33,69.75%20129.78,119.02%20158.16,119.02%20228.61,119.02%20256,119.02%20'/%3e%3cpolygon%20class='st3'%20points='136.93,132.47%20116.46,167.93%2073.82,241.78%20130.71,241.78%20144.9,217.2%20180.13,156.18%20193.82,132.46%20'/%3e%3cpolygon%20class='st3'%20points='121.7,131.95%20101.23,96.49%2058.59,22.63%2030.15,71.91%2044.34,96.49%2079.57,157.5%2093.26,181.22%20'/%3e%3cpolygon%20class='st2'%20points='64.81,131.95%2025.15,131.21%200,130.74%2028.44,180.01%2066.73,180.72%2093.26,181.21%20'/%3e%3cpolygon%20class='st2'%20points='165.38,181.74%20184.58,216.46%20196.75,238.47%20225.19,189.2%20206.66,155.69%20193.83,132.46%20'/%3e%3c/g%3e%3c/svg%3e)
Windmill HubRun analytical queries against ClickHouse from any Windmill script, flow or app.
Set up in 3 steps
Collect the connection details
You need the hostname or IP of the server. Username and password are optional — a default install accepts the default user with no password, which you should not keep in production. Hosted providers show all three on the service page; self-hosted, they are in users.xml.
Add the resource in Windmill
Open Resources, add a resource of type clickhouse, and fill the fields.
Run your first script
Fork any script below and read a small table before running anything heavy.
Scripts
Building blocks, if none of the projects above fit. Fork one, run it, or call it as a step inside your own flow.
Run Query
Update service state
Update service password
Update service basic details
Update service backup configuration
Update service auto scaling settings
Update organization member.
Update organization details
Update key
Remove an organization member
Organization activity
List organization members
List of service backups
List of organization services
List of organization activities
List all invitations
Get service details
Get service backup configuration
Get prometheus metrics
Get private endpoint configuration
Get organization details
Get member details
Get list of available organizations
Get list of all keys
Get key details
Get invitation details
Get backup details
Delete service
Delete organization invitation
Delete key
Resource type
The shape of the credential every script on this page expects.
clickhouse
View raw schema →| Field | Type | Required | What it is |
|---|---|---|---|
| host | string | No | Database host |
| password | string | No | Database password or API key secret (Cloud API) |
| username | string | No | Database username or API key id (Cloud API) |
Questions
Why are username and password optional?
A default ClickHouse install accepts the default user with an empty password. Leave them blank only for a server that is not reachable from outside.
Are my credentials stored on the hub?
Never. They live only in your own Windmill workspace, encrypted at rest.