# Supported Data Fields

In this page, you will find the **complete list of Data Fields** supported for each [Data Source](#supported-data-sources).

## crystal Attribute Type List <a href="#h_867f020de2" id="h_867f020de2"></a>

First of all, let's recap the Data Field supported by Crystal.

| Type        | Notes                                                                                                                                 |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------- |
| Categorical | Used mainly for filter dimensions. crystal will not perform calculation (e.g. Sum or average) on these formats.                       |
| Numeric     | Used mainly for main entities that need aggregations and numerical filters.                                                           |
| Date & Time | Used for time dimension (filter entity). If not formatted accordingly, crystal will not be able to show data with a time perspective. |
| Boolean     | Used for entities that can assume binary values                                                                                       |

Now, let's deep dive into each Data Source!

## **PostgreSQL** <a href="#h_6140949bb9" id="h_6140949bb9"></a>

| Type        | Format                                                                                                                                               |
| ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>char </li><li>character varying </li><li>character </li><li>text </li><li>varchar</li></ul>                                                  |
| Numeric     | <ul><li>bigint </li><li>decimal </li><li>double precision </li><li>integer </li><li>money </li><li>numeric </li><li>real </li><li>smallint</li></ul> |
| Date & Time | <ul><li>date </li><li>timestamp</li></ul>                                                                                                            |
| Boolean     | <ul><li>boolean</li></ul>                                                                                                                            |

## **MySQL** <a href="#h_2eb01f139b" id="h_2eb01f139b"></a>

| Type        | Format                                                                                                                                                                                             |
| ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>char </li><li>character </li><li>varchar </li><li>tinytext </li><li>text </li><li>mediumtext </li><li>longtext </li><li>blob </li><li>enum </li><li>set</li></ul>                          |
| Numeric     | <ul><li>tinyint </li><li>smallint </li><li>integer </li><li>int </li><li>bigint </li><li>decimal </li><li>numeric </li><li>float </li><li>real </li><li>double precision </li><li>double</li></ul> |
| Date & Time | <ul><li>date </li><li>time </li><li>datetime </li><li>timestamp </li><li>year</li></ul>                                                                                                            |
| Boolean     | <ul><li>boolean</li></ul>                                                                                                                                                                          |

## **Microsoft SQL Server** <a href="#h_e5288f94c9" id="h_e5288f94c9"></a>

| Type        | Format                                                                                                                                                                     |
| ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>char </li><li>varchar </li><li>text </li><li>nchar </li><li>nvarchar </li><li>ntext </li><li>uniqueidentifier</li></ul>                                            |
| Numeric     | <ul><li>bigint </li><li>decimal </li><li>int </li><li>money </li><li>numeric </li><li>smallint </li><li>smallmoney </li><li>tinyint </li><li>float </li><li>real</li></ul> |
| Date & Time | <ul><li>date</li><li>datetime </li><li>datetime2 </li><li>datetimeoffset </li><li>smalldatetime </li><li>time</li></ul>                                                    |
| Boolean     | <ul><li>bit</li></ul>                                                                                                                                                      |

## **Oracle** <a href="#h_eed7da9c66" id="h_eed7da9c66"></a>

| Type        | Format                                                                                       |
| ----------- | -------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>varchar2</li><li>nvarchar2</li><li>char</li><li>nchar</li><li>varchar</li></ul>      |
| Numeric     | <ul><li>number</li><li>float</li><li>long</li><li>int</li><li>decimal</li><li>real</li></ul> |
| Date & Time | <ul><li>date</li><li>timestamp</li></ul>                                                     |
| Boolean     | <ul><li>raw</li></ul>                                                                        |

## **IBM DB2** <a href="#h_a247760f2c" id="h_a247760f2c"></a>

| Type        | Format                                                                                                                 |
| ----------- | ---------------------------------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>CHAR</li><li>VARCHAR</li><li>CLOB</li><li>BINARY</li><li>VARBINARY</li><li>BLOB</li></ul>                      |
| Numeric     | <ul><li>SMALLINT</li><li>INTEGER</li><li>BIGINT</li><li>DECIMAL</li><li>REAL</li><li>DOUBLE</li><li>DECFLOAT</li></ul> |
| Date & Time | <ul><li>DATE</li><li>TIME</li><li>TIMESTAMP</li></ul>                                                                  |
| Boolean     | <ul><li>BOOLEAN</li></ul>                                                                                              |

## **Amazon Redshift** <a href="#h_97ea0c7713" id="h_97ea0c7713"></a>

| Type        | Format                                                                                                                                                                                                                                         |
| ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>char</li><li>nchar</li><li>bpchar</li><li>character</li><li>varchar</li><li>nvarchar</li><li>character varying</li><li>text</li></ul>                                                                                                  |
| Numeric     | <ul><li>int2</li><li>int</li><li>int4</li><li>int8</li><li>numeric</li><li>float4</li><li>float8</li><li>float</li><li>bigint</li><li>decimal</li><li>double precision</li><li>integer</li><li>numeric</li><li>real</li><li>smallint</li></ul> |
| Date & Time | <ul><li>date</li><li>timestamp</li></ul>                                                                                                                                                                                                       |
| Boolean     | <ul><li>boolean</li><li>bool</li></ul>                                                                                                                                                                                                         |

## **SAP Hana** <a href="#h_8b3713e233" id="h_8b3713e233"></a>

| Type        | Format                                                                                                                                                   |
| ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>nvarchar</li><li>varchar</li><li>shorttext</li><li>alphanum</li></ul>                                                                            |
| Numeric     | <ul><li>bigint</li><li>integer</li><li>smallint</li><li>tinyint</li><li>decimal</li><li>smalldecimal</li><li>double</li><li>real</li><li>float</li></ul> |
| Date & Time | <ul><li>date</li><li>time</li><li>timestamp</li><li>seconddate</li></ul>                                                                                 |
| Boolean     | <ul><li>boolean</li></ul>                                                                                                                                |

## Azure Synapse  <a href="#h_8b3713e233" id="h_8b3713e233"></a>

| Type        | Format                                                                                                                                                            |
| ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Categorical | <ul><li>char</li><li>varchar</li><li>nchar</li><li>nvarchar</li></ul>                                                                                             |
| Numeric     | <ul><li>bigint</li><li>decimal</li><li>int</li><li>money</li><li>numeric</li><li>smallint</li><li>smallmoney</li><li>tinyint</li><li>float</li><li>real</li></ul> |
| Date & Time | <ul><li>date</li><li>datetime</li><li>datetime2</li><li>datetimeoffset</li><li>smalldatetime</li><li>time</li></ul>                                               |
| Boolean     | <ul><li>bit</li></ul>                                                                                                                                             |

## MongoDB  <a href="#h_8b3713e233" id="h_8b3713e233"></a>

| Type        | Format                                                            |
| ----------- | ----------------------------------------------------------------- |
| Categorical | <ul><li>string</li></ul>                                          |
| Numeric     | <ul><li>double</li><li>decimal</li><li>int</li><li>long</li></ul> |
| Date & Time | <ul><li>date</li><li>timestamp</li></ul>                          |
| Boolean     | <ul><li>boolean</li></ul>                                         |

## Google BigQuery  <a href="#h_8b3713e233" id="h_8b3713e233"></a>

| Type        | Format                                                                      |
| ----------- | --------------------------------------------------------------------------- |
| Categorical | <ul><li>string</li></ul>                                                    |
| Numeric     | <ul><li>integer </li><li>float</li><li>numeric</li><li>bignumeric</li></ul> |
| Date & Time | <ul><li>date</li><li>datetime</li></ul>                                     |
| Boolean     | <ul><li>boolean</li></ul>                                                   |

***


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.igenius.ai/crystal-console/topics-configuration/connect/supported-data-sources-1.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.