Overview
There are 2 ways to import data into Morph. Let’s go over each of them now.
Options for Creation
Creating an empty table
Instead of importing data from an external source, you can create an empty table to generate data in Morph by selecting ‘Source’ > ‘Create blank table’ from the ‘+’ button next to Team Space. New columns are created by pressing the ‘+’ button in the header — a popup will let you configure the details of that column, such as value type.
To add records (enter values), press the create records button in the lower right corner.
Importing from external systems (SaaS / DWH)
This is a method of importing data from external systems via API integration. There are two patterns: importing tables from external systems as they are, and importing data that has been processed using SQL before importing.
Import data without processing.
Select ‘Source’ > ‘Add integration’ from the ‘+’ button next to Team Space. Select the external system you want to import, enter the necessary information in the popup and import the data. Importing is done on a table-by-table basis.
Data processing before importing.
Go to Canvas, select the code icon from the bottom icons in Canvas, and place the SQL cell. Open the Editor screen of the SQL cell, and establish a connection by selecting "Create" from the Connection tab in the side menu. Then, while checking the schema of the connection destination, write SQL statements and press Run in the upper right corner to import data from an external source after processing it.
