Binary Data for Snowflake

Limitation Binary Data is not supported for Snowflake Data Source. The following section describes this limitation.

If any Snowflake table has a binary column, Torch will not be able to execute any operations such as profiling or executing a data quality policy on that table. This is because the Snowflake Spark connector does not support binary data type.

The job execution fails with the following error:

2021-06-12 18:32:07 ERROR AnalysisAppApi:463 - Unsupported type -2

java.sql.SQLException: Unsupported type -2

Therefore, for a Snowflake data source, whenever you profile or take sample data for a particular table, with a column containing binary data type, the action fails.
Type to search, ESC to discard
Type to search, ESC to discard
Type to search, ESC to discard
Next to read:
Date and Timestamp Schema Inference

For additional help, contact our Support Team!

©2023, Acceldata Inc — All Rights Reserved.

On This Page
Binary Data for Snowflake