Retrieve Information from Snowflake

To retrieve information from Snowflake, set up a fetch task using the following procedure. The connector runs fetch tasks automatically, based on the schedule that is configured in the configuration file.

To create a new Fetch Task

  1. Stop the connector.
  2. Open the configuration file in a text editor.

  3. In the [FetchTasks] section of the configuration file, specify the number of fetch tasks using the Number parameter. If you are configuring the first fetch task, type Number=1. If one or more fetch tasks have already been configured, increase the value of the Number parameter by one (1). Below the Number parameter, specify the names of the fetch tasks, starting from zero (0). For example:

    [FetchTasks]
Number=1
0=MyTask

  4. Below the [FetchTasks] section, create a new TaskName section. The name of the section must match the name of the new fetch task. For example:

    [FetchTasks]
Number=1
0=MyTask

[MyTask]

  1. Set the following configuration parameters:

    AccountUrl The Snowflake account endpoint.
    AccountLocator The Snowflake account locator.
    Warehouse The virtual warehouse to use for executing queries.
    Database The database to connect to.
    Schema The schema containing the objects to crawl.
    User The Snowflake user to authenticate as.
    AuthType The authentication method to use.

  2. Set the configuration parameters necessary to authenticate with Snowflake. For more information about authentication, see Authenticate with Snowflake.

  3. Configure where to start crawling the database:

    TargetType The type of object specified by Target.
    Target Specifies what to retrieve data from.
    PrimaryKeyColumns The column(s) to use to uniquely identify a row. The primary key for a row is used in the document identifier.
  4. Save and close the configuration file. You can now start the connector.