Infoworks 5.4.0
Onboard Data

Configuring Table Groups

Creating Table Group

The following are the steps to create a table group:

  1. Click Create Table Group and provide the table group details.
FieldDescription
Job NameThe name of the ingestion job.
Max. Connections to SourceThe maximum number of source database connections allocated to this ingestion table group.
Max. Parallel TablesThe maximum number of tables that can be crawled at a given instance.
Compute TemplateThe template based on which the cluster will spin up for each table. The compute templates created by admin that can be accessed by the source are displayed in the drop-down list.
Overwrite Worker CountThe option to overwrite the minimum and maximum worker values configured in the compute template.
Min WorkersThe minimum number of nodes that will spin up in the cluster.
Max WorkersThe maximum number of nodes that can be spun up in the cluster.
Number of Worker NodesThe number of nodes that can be spun up in the cluster.
Snowflake WarehouseThis field appears only if the Data Environment selected in a CDW env. For e.g. Snowflake. Select from the list of associated warehouses.
Query Tags

A string that is added to the Snowflake query and can be accessed via Query history in Snowflake.

NOTE This field appears only if the source is using Snowflake CDW environment.

  1. Select the required tables and click Add Tables To Group.
  1. Click Save.

Editing Table Group Details

The following are the steps to configure a table group:

  1. Navigate to the Table Groups tab.
  2. Click Actions for the required table group and click Configure. The table group details with the list of tables will be displayed.
  1. Edit the required details.

4. Click All Tables to view all the tables in the source.

  1. Click Tables in the Group to view the tables in the table group.
  2. Click Auto Alloc. Connection Quota to autofill the Connection Quota for optimal use based on the maximum number of parallel tables. The value is calculated as 100/(Max parallel tables) or 100/(No. of tables in the group), whichever is greater.
  3. Select the table and click Remove From Group to remove the table from the table group.
  4. Click Save.
  Last updated