Keep your campaign analytics database structure visible
Get a periodic inventory of the database structure so analytics changes are easier to notice during routine reviews.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Get Database Schema
Retrieves an overview of a database's schema and tables.
Why this helps
Database structure changes can make familiar analysis harder when nobody has a current overview of the tables and columns.
- Review an overview of tables in a selected database.
- Include column definitions when available and requested.
- Keep a current reference for later analytics work.
Setup
Build it in a few focused steps.
- 1Connect ActiveTrail and ClickHouse once in the Notis portal.
- 2Create an automation from Automations, New Automation, or tell Notis from any channel.
- 3In one instruction, ask Notis to retrieve the schema overview for the specified ClickHouse database and summarize its tables and available column definitions.
- 4Choose a schedule trigger and the channel for run reports.
- 5Test with one real example naming an accessible database.
Questions about this workflow
Will this explain the meaning of every column?
The schema can provide column definitions and types where available. Business meaning may require context supplied by you.
Does a schema overview report data quality?
No. It describes database structure. Checking the records themselves requires querying the data.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ActiveTrail to ClickHouse. A trigger fires from one place; an action lands in another.
ActiveTrail triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Runs a database query and returns the results.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Retrieves an overview of a database's schema and tables.
Get Table Schema
Gets the schema and column details for a table.
Get ClickHouse Play Interface
Returns the ClickHouse Play interface for writing queries and viewing results.
List ClickHouse Databases
Lists the databases in an instance.
List ClickHouse Tables
Lists tables in databases with basic details.
Connect any two apps with Notis in the middle.
ActiveTrail and ClickHouse, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business ClickHouse.