Data Sources

A source refers to the data warehouse where all the data you want to get value from is stored. Snowflake, or Google BigQuery are among the most common DataWarehouses.

To add a source into your DinMo workspace, you simply need to connect your data warehouse to the platform, ensuring that DinMo has the necessary permissions to read the data and execute jobs.

DinMo uses the source to store some info into specific schemas/datasets:

• dinmo_segments: views of the query of the segments and models created within DinMo

• dinmo_stats: tables that contain statistics about your segments

• dinmo_delta_storage: snapshots of a historical run of segments queries that enable DinMo to calculate the changes that occur on a segment and update, therefore, the activation target.

• dinmo_predictions: : For workspaces with the predictions module enabled, this table stores the output generated by the predictions models.

You can add as many sources as you want on your workspace.

DinMo will never store data located on your source. Furthermore, every computation will be processed on your DataWarehouse only.

Source configuration

Step-by-step guides

You will find below the step-by-step instructions to connect a source to DinMo, specific to each DataWarehouse provider:

• Google BigQuery

• Snowflake

• Amazon Redshift

• PostgreSQL

• Databricks

Note that only Admin users can create and manage sources.

Advanced settings

For all the sources listed above, it is possible to set an advanced setting, in particular to choose the time of day when DinMo performs analytical tasks.

All you have to do is click on your source (available in your workspace settings) and go to advanced settings. The schedule can be modified to suit your needs.

Only workspace admins can do this operation.