What is Import Model?
Import Models are created when you Import Data. Under the hood, an Import Model is a data model coupled with mechanisms to help you import data from other sources (API connection, refresh schedule, data persistence, type casting...).
Create Import Models
At Data Modeling page, simply click Create -> Add Data Model from Other Sources -> Select Import Source.
Edit Import Model
After creating the import model, you can still adjust its settings (destination and sync configuration).
You tend to edit the import model whenever:
- You have previously set the Data Type incorrectly (in Sync Configuration)
- Your Data Imports operate fail and you want to edit the Data Type
- You want to change your Destination Settings (Refresh Schedule, Import Mode)
- Other reasons
In those cases, just simply click on Edit in Storage Settings and the Import Model Editor view will be displayed.
Refresh Source Structure
When your sources' structure has some changes (add new columns, delete some columns, rename columns, etc.):
If you edit Google Spreadsheet Model, we don't automatically refresh the Source structure for you. You need to click on the Re-validate button to get the updated structure. But all of your current Data Type and Destination Column name will be reverted back to default.
If you edit Google Analytics Model, the current structure remains unchanged unless you adjust the Dimension, Measure and Re-validate.
If you edit any Database Table Model (source is either PostgreSQL, MySQL, SQL Server, BigQuery, MongoDB) or any Application Source Model (source is either Pipedrive, Zendesk, Facebook Ads), we will automatically update Source structure for you. If there are new columns in your Source, they will be added in Sync Configuration but left as soft-deleted. In order to update them in your current model, you need to manually restore them.