DBHub

Shows one table's columns (type and business meaning), date range, last sync, and its semantics: summable metrics with their column, derived metric formulas (SQL), values that must not be summed, dimensions and aggregation rules such as grouping by currency. Ends with 3 sample rows.

describe_table

dbhub's business definitions: each metric concept (label, synonyms, unit, meaning), how derived metrics such as CTR, CPC, CPM or ROAS are computed (sum of numerator over sum of denominator), metrics that cannot be computed and why, and ambiguous terms. Without a module it returns a compact index of concepts and module codes; with a module code (FAD, GGA, TTA, GMV, TTS, MPI, GA4, GSC, YTC, POS, PAN, PAC, KVT, SHO, FBT) it returns full definitions.

get_business_glossary

Lists the tables in this dbhub DB Warehouse workspace, grouped by data source module (Facebook Ads, TikTok Shop, Google Ads, ...), with a business description, row grain and main date column when known.

list_tables

Runs one read-only PostgreSQL 16 query (SELECT or WITH ... SELECT) against this workspace's tables and returns at most 1000 rows. Queries time out after 30 seconds. SQL reference: https://www.postgresql.org/docs/16/sql-select.html

run_query