Versions Compared

Key

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

...

  • Valid accounts and access permissions to connect to the following:

    • Source: AWS S3, Redshift, Azure Cloud Storage, or Google Cloud Storage

    • Target: Snowflake, Redshift, Azure Synapse, Databricks Lakehouse Platform, or BigQuery

Limitations

...

None.

Known Issue

The ELT Math Function Snap fails during Pipeline execution even after successful validation against the Redshift CDW due to the incompatible or incorrect data types associated with the target table columns created during the Pipeline validation. To prevent this failure, we recommend that you manually delete the table created during validation before running the Pipeline.

Snap Input and Output

Input/Output

Type of View

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 1

  • Max: 1

  • ELT Select

  • ELT Filter

  • ELT Join

  • ELT Transform

A document containing the SQL query that yields the data required to perform the mathematical (unary or binary) operations.

Output

Document

  • Min: 1

  • Max: 1

  • ELT Insert Select

  • ELT Join

  • ELT Transform

A document containing the incremental SQL query that includes the mathematical functions defined in the Snap.

...