Skip to main content

ClickHouse

Connect to ClickHouse databases for high-performance analytics queries in your automation workflows.

Overview​

The ClickHouse package enables integration with ClickHouse, the fastest open-source database for real-time analytics. Use it when you need to query large datasets, insert analytics data, or build reporting automations.

Key Features​

  • High-Performance Queries - Execute fast analytical queries
  • Batch Operations - Efficiently insert large amounts of data
  • Standard SQL - Use familiar SQL syntax
  • Connection Management - Persistent connections for multiple operations

Available Nodes​

  • Connect - Establish connection to ClickHouse server
  • Disconnect - Close the database connection
  • Execute Query - Run SELECT queries and retrieve results
  • Execute Non Query - Run INSERT, UPDATE, DELETE, DDL statements
  • Create Batch - Initialize batch insert operation
  • Send Batch - Execute batch insert with collected data

When to Use This Package​

  • Analytics Pipelines: Feed data into ClickHouse for analysis
  • Real-time Reporting: Query live analytics data
  • Log Processing: Store and analyze log data
  • Time-Series Data: Work with time-series metrics
  • Data Warehousing: ETL operations with ClickHouse

Typical Workflow​

  1. Connect to ClickHouse with credentials
  2. Execute Query to retrieve analytics data
  3. Process results in your workflow
  4. Optionally use Create Batch and Send Batch for bulk inserts
  5. Disconnect when finished

Authentication​

Requires ClickHouse server credentials (host, port, database, username, password). Store credentials securely in Vault.