Supported Data Sources

Morph provides an environment where users can manage and analyze data centrally by integrating with various data sources. This section introduces the major data sources supported by Morph.

SQL Databases

Morph allows integration with various external data sources, enabling users to execute queries directly using SQL from the following databases and data warehouses:

  1. MySQL: An open-source relational database management system used in many applications worldwide.
  2. PostgreSQL: A powerful open-source object-relational database system known for its reliability, feature richness, and performance.
  3. BigQuery: A serverless, highly scalable data warehouse from Google Cloud that supports rapid SQL queries on large datasets.
  4. Snowflake: A cloud-based data warehouse service that excels in data sharing and scalability, supporting various data workloads.
  5. Redshift: Amazon Web Services' cloud data warehouse that enables fast analysis of large datasets.

By connecting these data sources to Morph, users can integrate data across different platforms and tools, efficiently performing data analysis and business intelligence tasks. The connection setup is simple through Morph's interface, allowing direct data queries.

Non-SQL Databases

Morph can also integrate with NoSQL databases and other non-SQL databases, including MongoDB and Cassandra. Users can retrieve and analyze data from these databases using Python. Leveraging Python’s powerful libraries makes data manipulation and transformation easy, allowing effective insights from non-SQL databases.

API Integration

Morph can connect with various external services and applications through APIs. This capability allows real-time data retrieval from web services or integration with other cloud services. Users can use Python scripts to fetch data from APIs and process and analyze it directly within Morph, enabling flexible and customizable data integration.

File Upload

Morph supports data upload from local files as well. Users can easily upload CSV, JSON, and Excel files and import them into the workspace. The uploaded data is automatically given the correct titles and datatypes, making it immediately available for analysis and visualization using Morph.