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

Info
titleSQL Functions and Expressions for ELT

You can use the SQL Expressions and Functions supported for ELT to define your Snap or Account settings with the Expression symbol = enabled, where available. This list is common to all target CDWs supported. You can also use other expressions/functions that your target CDW supports.


Field NameTypeField DependencyDescription
LabelStringNone

Excerpt Include
File Writer
File Writer
nopaneltrue

Default ValueELT Sample

ExampleSample Order Data

Get preview dataCheckboxNone

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/ExpressionSampling Type is Number of Records

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.

Default Value: NA

Example10
Percentage of RecordsString/ExpressionSampling Type is Percentage of Records

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.

Default Value: NA

Example25

...