What's an Activity

An activity within Insight Factory describes an action to be taken by a task. For instance, one of our frequently used activities is 'Ingest SQL Server Database as Parquet'. As the name implies, this activity copies data out of a SQL Server database and lands it within an Azure Data Lake storage account in parquet format.

The list of all avaliable activities can be found on the Activities page.

Activity Config

All activities have a set of mandatory and optional properties that must be set when using the activity. These can either be set at the task level or the task group level. To use the 'Ingest SQL Server Database as Parquet' example above, a group of tables being extracted from a single database would have a DatabaseConnectionStringSecretName property set at the task group level and details about each individual table, such as the ExtractQuery and DataLakeDatasetFolder, set at the task level.