Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.clarityq.ai/llms.txt

Use this file to discover all available pages before exploring further.

After you connect your data warehouse, the next step is selecting which tables ClarityQ should catalog. This is done as part of the Data Warehouse Setup Wizard — not from the Table Catalog page itself.

​
Selecting Tables

Table selection happens in the setup wizard, where you browse your warehouse’s schemas and choose the tables you want ClarityQ to catalog. You don’t need to add all tables — focus on the ones relevant to your analytics. The Table Catalog page then displays the tables you selected in the wizard, along with their discovered schemas, columns, and metadata.
Start with your most important tables — the ones your team queries most often. Admins can always go back to the setup wizard to add more tables later.

​
What Happens During Discovery

When you add tables, ClarityQ runs a discovery workflow for each one:
  1. Schema extraction — Queries your warehouse for the table’s structure, columns, data types, and constraints
  2. Column value sampling — Fetches up to 50 distinct values for categorical columns
  3. Metadata collection — Captures row counts, table size, partitioning, clustering, and timestamps
  4. AI description generation — Automatically suggests descriptions for tables and columns that don’t have one
Discovery runs in parallel across multiple tables. Each table’s state is tracked independently — you’ll see an In Progress spinner while it’s running, a Completed checkmark when done, or an Error indicator if something went wrong.

​
Table Settings

After a table is cataloged, you can configure it from the table settings:
  • Table type — Classify the table (Events, Fact, Dimension, Lookup, Aggregate, Raw Data). This affects how ClarityQ uses the table.
  • Mandatory filters — Define SQL WHERE conditions that are automatically applied to every query against this table. See Mandatory Filters.
  • Analytics engine — For Events tables, specify the analytics platform (e.g., GA4) to enable platform-specific enrichment.
  • Descriptions — Edit table and column descriptions, or accept AI-generated suggestions.

​
Reviewing Tables and Columns

After discovery, tables and columns start in Pending status. Review them to confirm they’re accurate:
  • Approve tables and columns you’ve reviewed
  • Hide columns that are irrelevant or sensitive — they won’t appear in the catalog or be used by the agent
  • Edit descriptions to add business context that helps ClarityQ understand what the data means