Skip to main content
Version: v4

Supported Data Sources and Versions

info

Each table in a data source can have at most 1000 columns

Supported SQL databases / data warehouses​

1. MySQL​

Because differences between minor versions are small, testing uses the latest release of each major version; for example, 5.5 is tested with 5.5.61.

  • MySQL 5.5.46 - 5.5.61
  • MYSQL 5.6.34 - 5.6.46
  • MySQL 5.7.16 - 5.7.28
  • MySQL 8.0.11 - 8.0.17

Unsupported types:

  1. zerofill and unsigned int are not supported
  2. time is not supported
  3. Spatial Data Types are not supported
  4. bit type only supports range = 1 (e.g. bit(1))

2. Oracle​

  • Oracle 10g (tested mainly with 10.2.0.1.0; partially supported)
  • Oracle 11g (tested mainly with 11.2.0.4)
  • Oracle 12c (tested mainly with 12.1.0.2)
  • Oracle 18c (tested mainly with 18.0.0.0)
  • Oracle 19c (tested mainly with 19.0.0.0)

Unsupported types:

  1. XML is not supported
  2. Timestamp with local zone is not supported
  3. URITYPE is not supported
  4. BFILE is not supported
  5. time is not supported

3. PostgreSQL​

Because differences between minor versions are small, testing uses the latest release of each major version; for example, 9.3 is tested with 9.3.25.

  • PostgreSQL 9.3.12 - 9.3.25
  • PostgreSQL 9.4.7 - 9.4.25
  • PostgreSQL 9.5.2 - 9.5.20
  • PostgreSQL 9.6.1 - 9.6.16
  • PostgreSQL 10.1 - 10.11
  • PostgreSQL 11.1 - 11.6
  • PostgreSQL 12
  • PostgreSQL 13

Unsupported types:

  1. time, timetz, interval are not supported
  2. Text Search Types are not supported
  3. txid_snapshot is not supported
  4. xml is not supported
  5. Network address types (macaddr, inet, cidr) are not supported
  6. bit, varbit are not supported
  7. Spatial Data Types are not supported
  8. Arrays of timestamptz, time, json, money are not supported

4. Microsoft SQL Server​

Each version has its own service packs, and the differences between them are small.

  • SQL Server 2008 (10)
  • SQL Server 2012 (11)
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017
  • SQL Server 2019
  • Azure SQL Database

Unsupported types:

  1. tinyint is not supported
  2. DatetimeOffset is not supported
  3. SqlVariant is not supported
  4. time is not supported
  5. Spatial Data Types are not supported

5. Google BigQuery​

  1. BIGNUMERIC and BIGDECIMAL are not supported
  2. GEOGRAPHY is not supported
  3. Querying from Views is not supported

Supported data lake sources​

1. AWS S3​

2. Azure Blob Storage​

3. Hive​

Supported NoSQL databases​

1. MongoDB​

Supported versions:

  • MongoDB 3.2
  • MongoDB 3.4
  • MongoDB 3.6
  • MongoDB 4.0
  • MongoDB 4.2
  • MongoDB 4.4

Unsupported types:

  1. BSON Bindata Type is not supported
  2. BSON Null Type is not supported
  3. BSON Timestamp Type is not supported. BSON has a special timestamp type for internal MongoDB use and is not associated with the regular Date type. Reference
  4. BSON Decimal Type is not supported. The decimal BSON type uses the IEEE 754 decimal128 decimal-based floating-point numbering format. Reference

2. ElasticSearch​

  1. SCALED_FLOAT is not supported
  2. UNSIGNED_LONG is not supported
  3. CONSTANT_KEYWORD is not supported
  4. Date types with a custom format are not supported

Supported file sources​

1. FTP/SFTP​

2. Google Sheet​

Appendix - Supported file types​

1. JSON file​

2. Parquet file​

  1. Parquet files not produced by hive (parquet-mr) may not be supported

3. CSV file​

  1. Supported delimiters: comma (,), pipe (|), tab (\t), and colon (:)
  2. Only UTF8 encoding is supported
  3. Fields with embedded SEPARATOR MUST be delimited with double-quote characters.

4. Apache ORC file​

The supported version is ORC v1

5. Excel​

  • xls and xlsx are supported
  • Password-protected Excel files are supported
  • Most Excel formulas are supported
  • Excel types are automatically converted in Canner (date and number types are supported)

Supported API connectors​

  • RESTful APIs are supported; the API response must be in JSON format