Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 1
  • Max: 1
  • ELT Select
  • ELT Transform
  • ELT Filter
The SQL query in which you want to add the SAMPLE clause. Typically, it would be a SELECT query reading the source table. 
Output

Document

  • Min: 1
  • Max: 1
  • ELT Insert-Select
  • ELT Transform

The incoming SQL query with the SAMPLE clause and a preview of the query's result if the Get preview data check box is selected.

Snap Settings

Not Selected
Parameter Field NameData TypeField DependencyDescriptionDefault ValueExample 
LabelStringNone

Excerpt Include
File Writer
File Writer
nopaneltrue

Default ValueELT Sample

ExampleSample Order Data

Get preview dataCheck boxCheckboxNone

Multiexcerpt include macro
namegetpreviewdata
pageELT Intersect

Default Value: Not selected
Example: Selected
Sampling TypeDrop-down list

None

Choose the sampling type to query your data.

Available options are:

  • Number of Records
  • Percentage of Records

Default ValueNumber of Records

ExamplePercentage of Records
Number of RecordsString/ExpressionActivates when you select Sampling Type is Number of Records for Sampling Type.

Enter the number of records to output.

Info

The ELT Sample Snap outputs the entire table if the total number of records in the table is less than the value specified here.

NA

Default Value: NA

Example10
Percentage of RecordsString/ExpressionActivates when you select Sampling Type is Percentage of Records for Sampling Type.

Enter the percentage number of records to sample your data based on a percentage value of the total records in the table.

Info
  • The number of records in the output is rounded off to the lower value if the percentage leads to a decimal. For example, if you enter 75 and if the table has 10 records, the output yields 7 records since 75% of 10 is 7.5.
  • The number of records in the output is randomized and is up to a maximum of the percentage calculation specified above. Therefore, in the above instance, the output may contain 5, 6, or 7 records.
NA

Default Value: NA

Example25

Troubleshooting

None.

Examples

Creating a Subset Table

...