In this article
...
Field Name | Field Type | Description | ||
---|---|---|---|---|
Label*
Default Value: SQL Server - Table List | String | Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline. | ||
Schema Name
Default Value: N/A | String/Expression | Specify the database schema name. Selecting a schema filters the Table name list to show only those tables within the selected schema. The property is suggestible and will retrieve available database schemas during suggest values. | ||
Compute table graph Default Value: Deselected | Checkbox | Specify the dependents among tables and returns each table with a list of tables it has foreign key references to. The ordering of outputted tables is from least dependent to most-dependent. Note that as turning on this option will significantly slow down the Snap, it should be left as off unless you need it. | ||
Number of retries
Default Value: 0 | Integer/Expression | Specify the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response.
| ||
Retry interval (seconds)
Default Value: 1 | Integer/Expression | Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. | ||
Multiexcerpt include macro | ||||
Snap Execution | ||||
page | Anaplan Read | Dropdown list |
| |
name | Snap_Execution_Introduced | page | Anaplan ReadSelect one of the following three modes in which the Snap executes:
Examples
In the following example, the Table List Snap retrieves all the tables under schema 'dbo' and writes it to output view.
The sample output view data is shown below:
...
Snap Pack History
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...