Configuration

This section explains each of the properties in the configuration blade.

General

PropertyDescription

Collection

This associates the Agent to a specific Collection and defaults to that of the current Data Stream.

Polling Interval (seconds)

A timespan to specify how often should the Agent check for new data/changes or update its cache.

Visit Collections and Stream Hosts to understand more about Collections.

Server

PropertyDescription

Use Connection Variables

Tick to select saved variables; or enter the text manually for the authentication properties.

Organization

The organization name of the Snowflake account to which you are connecting.

Account

The account name of the Snowflake account to which you are connecting.

User Name

The user name to use for authenticating the connection.

Password

The password to use for authenticating the connection.

Once all the Server properties are entered, the Agent will attempt to open a connection with the Snowflake account. If successful, the Database property is populated with a list of available databases.

Database

PropertyDescription

Database

The name of the database to connect to. Once selected, the Table and Schema properties are pre-populated accordingly.

Schema

The name of the schema used to filter the Table selection. If blank, the Table property is not filtered.

Table

The name of the table to connect to. Once selected, the Columns To Return property is populated with a list of the table's columns.

Columns To Return

The columns which the Agent should return. If blank, all columns are returned.

Timestamp

PropertyDescription

Column

The column to use when distinguishing new rows from older rows. Ideally, the selected column should have a unique, incrementing value for each new row.

Endpoints

NameDescription

Output

The read events will be made available on this endpoint with attributes as per Columns To Return.

Error

Errors encountered during the execution of this Agent will be published on this endpoint.

Last updated