Import Model

Definition

In Holistics, Import Model is a data model created when you want to import data from other data source into SQL database (EL in ELT).

Under the hood, an Import Model is a data model coupled with an Extract-Load mechanism to help you load data from other data sources (CSV, Google Sheets, etc). Refer to this Import Data page for a detailed tutorial on importing data.

Note: Holistics's Import Model is designed for you to quickly get started with your reporting needs, and do not intend to replace full-fledged data integration solutions.

Creating Import Model

At Data Modeling page, simply click Create -> Add Data Model from Other Sources -> Select Import Source.

Editing 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 set a field's Data Type incorrectly and the import job fails
  • You want to change your Destination Settings (Refresh Schedule, Import Mode...)
  • ...

In those cases, click on Edit in Storage Settings and the Import Model Editor view will appear.

Import Modes

Currently Holistics support Full, Append and Incremental/Upsert modes. For more details on how these modes work, please refer to our docs on Storage Settings.

Refresh Source Structure of Import Model

When your sources' structure has some changes (columns are added, deleted or renamed...):

  • In the case of Google Spreadsheet imports, we do not automatically update the Source structure for you - you will need to click on the Re-validate button to get the updated structure. Note that this will also revert all of the column names and data types to default.

  • In the case of Google Analytics imports, the current structure remains unchanged unless you adjust the Dimension, Measure and Re-validate.

  • In the cases of Database Table imports (from PostgreSQL, MySQL, SQL Server, BigQuery, MongoDB) or Application Source imports (source is either Pipedrive, Zendesk, Facebook Ads), we will automatically update the Source structure for you. If there are new columns in your Source, they will appear in the Sync Configuration's field list but are not enabled. To include them in the sync, you will need to toggle them on.