Nota
This article is relevant only to datasets created via Auto Insights Admin Portal.
For a streamlined data import experience, including support for 70+ database connections, we recommend Import Data from Analytics Cloud.
What sort of files does Auto Insights accept? This article discusses database compatibility.
The databases that we can connect to are listed in this section. If your database is not listed below, please contact us at https://community.alteryx.com/support.
MySQL 5.5 or later
MariaDB 5.5 or later
PostgreSQL server versions from 7.4 to 12 (e.g. Amazon Redshift)
Microsoft SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
Analytics Platform System
Azure SQL Database
Azure SQL Data Warehouse
Oracle Database 11.2 or later
Snowflake instance: <account_identifier>.snowflakecomputing.com
For secure database connections, it is necessary to comply with TLS v1.2 at least.