SQL for External Databases
The Morph platform can connect to multiple external database systems, enabling the integration, manipulation, pipeline construction, and visualization of data from various sources. Morph supports the execution of SQL queries tailored to each database.
This section explains the types of SQL supported by Morph for each database.
PostgreSQL
- Syntax: Please refer to the official documentation of the version of PostgreSQL you are using.
| Version Restrictions | Connection Method |
|---|---|
| PostgreSQL 9.6 and above | Connection String |
MySQL
- Syntax: Please refer to the official documentation of the version of MySQL you are using.
| Version Restrictions | Connection Method |
|---|---|
| MySQL 5.7 and above MariaDB 10.2 and above | Connection String |
Amazon Redshift
- Syntax: Please refer to the official documentation.
| Version Restrictions | Connection Method |
|---|---|
| None | Connection String |
BigQuery
- Syntax: Please refer to the BigQuery SQL Reference.
| Version Restrictions | Connection Method |
|---|---|
| None | Service Account OAuth |
Snowflake
- Syntax: Please refer to the Snowflake SQL Command Reference.
| Version Restrictions | Connection Method |
|---|---|
| None | Key Pair OAuth |
Connection Method
You can connect to each external database from the Connections settings screen in Morph.