Getting started
First steps
Before you can utilize data for comprehensive analytics and integration, you must first enable DataHub. If you don't have it yet, contact us for enablement details - [email protected]
Once it's set up, you'll receive a welcome email containing detailed information. To begin your data journey, you will need:
Database host and port
Database name
Username and password
SSL mode settings
From there, your path forward is straight:
Set up your connection Configure your SQL client or analytics tool
Explore data schemas Discover the tables and relationships in your data
Check SQL example queries Use ready-made queries from our comprehensive recipe collection
We also recommend familiarizing yourself with Data types and field standards and Important considerations before proceeding.
Data types and field standards
DataHub uses consistent data type conventions that may differ from the source systems:
Date and time fields use the
TIMESTAMPformatText fields use
CHARACTER VARYINGorTEXTtypesID fields follow a consistent naming pattern with their table prefix (e.g., `user_id`, `device_id`)
Boolean fields use prefixes like
is_,has_, orcan_(e.g.,is_active,has_passport)
Important considerations
While working with the DataHub, be aware of these current limitations:
Error messaging is minimal for SQL query issues
Silver and Gold layers are still in development and not available yet
Historical data availability depends on your Platform subscription plan
For detailed information on structure and capability, see Schema overview.
Last updated
Was this helpful?