Concepts

DoordaHost

DoordaHost is built on Presto DB and is designed to query large datasets between our products. It can be used for:

1. Bulk data extracts into your own data warehouse/database/data lake or a simple file download.
   We support Python and R for script-based extraction and other languages with JDBC libraries/packages
2. Online Analytical Processing DoordaHost works with various BI tools including Tableau and Qlik. DoordaHost also includes various Functions and Operators which enable online analysis and reduces the need to store large tables in memory when processing.

Catalogs

Catalogs contain the schemas. In DoordaHost, there is a schema for each catalog, each product has its own schema.

Example:
Catalog = doordastats_snapshot
Schema = doordastats_snapshot
Query Format: SELECT {col} FROM doordastats_snapshot.doordastats_snapshot.{table_name}

  Schemas

Each schema contains a set of queryable tables. In DoordaHost, each Schema identifies with a Product. Our list of products can be found here.

  Tables

A table is a set of unordered rows which are organized into named columns with types. This is the same as in any relational database. The mapping from source data to tables is defined by the connector.

Each table has a urn as the primary key column which can be used to identify unique rows.

  Metadata

The metadata for the tables can be viewed using SHOW COLUMNS FROM table when connected to DoordaHost using a tool that supports SQL Queries.