4.1.3. Supported data sources

File systems

The technologies below are available for reading and, where applicable, writing. Once connected to the desired system, it is possible to read and write files in the formats listed in the following section (CSV, Parquet, Excel, JSON, XML, etc.).

  • Import from the user’s local drive

  • SFTP / plain FTP

  • HTTP / HTTPS (retrieval from a list of URLs)

  • Network drives (site deployments only)

  • Amazon S3

  • Azure Blob Storage

  • Azure Data Lake Gen2

  • Microsoft Sharepoint / OneDrive storage

  • Grist

  • Microsoft Lists

File storage

  • CSV, TSV

  • Log files

  • Microsoft Excel

  • Microsoft Access: ACCDB and MDB

  • XML

  • JSON and JSON line files

  • Parquet

  • LOG

  • PRN

  • TXT

Relational databases

  • MySQL

  • MariaDB

  • PostgreSQL

  • Microsoft SQL Server

  • Oracle

  • Databricks via JDBC

  • Db2 and Db2 iSeries AS/400

  • Denodo via JDBC versions 7 and 8

  • Snowflake

  • Google BigQuery

  • Amazon Redshift

REST APIs

  • OData v4

  • Salesforce

  • Hubspot

  • Google sheets

  • Zendesk

  • Jira