Data warehouses
Overview
AP supports the following data warehouses.
- ClickHouse
- PostgreSQL
- Amazon Redshift
- Azure SQL Database
- Azure Synapse
- Microsoft SQL Server
Notes:
- ClickHouse is the default data warehouse for AP.
- Azure SQL Database is a managed database service in the Azure cloud based on Microsoft SQL Server.
- Azure Synapse is a cloud data warehouse which largely adheres to Microsoft SQL Server data types and SQL syntax.
ClickHouse
ClickHouse is an open-source columnar database management system optimized for online analytical processing. It enables fast data insertion and real-time query performance, making it well-suited for handling large volumes of data.
| Topic |
Value |
| Default port |
8123 |
| Default schema |
default |
Data type mapping
| AP |
ClickHouse |
| Small int |
Int16 |
| Integer |
Int32 |
| Big int |
Int64 |
| Numeric |
Decimal |
| Real |
Float32 |
| Double |
Float64 |
| Boolean |
Bool |
| Char |
String |
| NChar |
String |
| Varchar |
String |
| NVarchar |
String |
| Text |
String |
| NText |
String |
| Date |
String |
| Timestamp |
DateTime64 |
| Timestamp with timezone |
DateTime64 |
| Time |
DateTime64 |
| Time with timezone |
DateTime64 |
| Geometry |
String |
| JSON |
String |
| Binary |
FixedString |
PostgreSQL
PostgreSQL is a powerful, open-source object-relational database system known for its robustness, scalability, and support for advanced SQL compliance. It offers a wide range of features, including complex queries, foreign keys, triggers, views, transactional integrity.
| Topic |
Value |
| Default port |
5432 |
| Default schema |
public |
Data type mapping
| AP |
PostgreSQL |
| Small int |
smallint |
| Integer |
integer |
| Big int |
bigint |
| Numeric |
numeric |
| Real |
real |
| Double |
double precision |
| Boolean |
boolean |
| Char |
char |
| NChar |
char |
| Varchar |
varchar |
| NVarchar |
varchar |
| Text |
varchar |
| NText |
varchar |
| Date |
date |
| Timestamp |
timestamp |
| Timestamp with timezone |
timestamptz |
| Time |
time |
| Time with timezone |
timetz |
| Geometry |
geometry |
| JSON |
json |
| Binary |
bytea |
Microsoft SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft, designed to support a wide range of data applications, including transaction processing, business intelligence, and analytics.
| Topic |
Value |
| Default port |
1433 |
| Default schema |
dbo |
Data type mapping
| AP |
SQL Server |
| Small int |
smallint |
| Integer |
int |
| Big int |
bigint |
| Numeric |
numeric |
| Real |
real |
| Double |
float |
| Boolean |
varchar |
| Char |
char |
| NChar |
nchar |
| Varchar |
varchar |
| NVarchar |
nvarchar |
| Text |
varchar |
| NText |
nvarchar |
| Date |
date |
| Timestamp |
datetime2 |
| Timestamp with timezone |
datetimeoffset |
| Time |
time |
| Time with timezone |
time |
| Geometry |
varbinary |
| JSON |
nvarchar |
| Binary |
varbinary |