import Header from '../_source-info-header.md';
30+ SQL databases#
SQL databases are management systems (DBMS) that store data in a structured format, commonly used for efficient and reliable data retrieval.
The SQL Database verified source loads data to your specified destination using one of the following backends: SQLAlchemy, PyArrow, pandas, or ConnectorX.
Sources and resources that can be loaded using this verified source are:
| Name | Description |
|---|---|
| sql_database | Reflects the tables and views in an SQL database and retrieves the data |
| sql_table | Retrieves data from a particular SQL database table |
Supported databases#
:::tip dltHub Features
For Microsoft SQL Server change tracking support, see the MS SQL replication docs.
:::
We support all SQLAlchemy dialects, which include, but are not limited to, the following database engines:
- PostgreSQL
- MySQL
- SQLite
- Oracle
- Microsoft SQL Server
- MariaDB
- IBM DB2 and Informix
- Google BigQuery
- Snowflake
- Redshift
- Apache Hive and Presto
- SAP Hana
- CockroachDB
- Firebird
- Teradata Vantage