Mapping Columns in Snowflake as a Source
  • 1 Minute to read
  • Dark
    Light
  • PDF

Mapping Columns in Snowflake as a Source

  • Dark
    Light
  • PDF

Article summary

Overview

This document outlines the mapping of Snowflake data types to Rivery data types. It also defines the behavior for handling unsupported data types in various scenarios.

Data Type Mapping

The following table describes the mapping of Snowflake data types to their corresponding Rivery data types:

# Data Types Mapping

Snowflake as a Source Data TypeRivery Data Type
NUMBERFLOAT
FLOATFLOAT
BOOLEANBOOLEAN
DATEDATE
TIMETIME
TIMESTAMPTIMESTAMP
VARCHARVARCHAR
BINARYVARCHAR
VARIANTVARCHAR
OBJECTVARCHAR
ARRAYVARCHAR

Expected Behavior for Unsupported Data Types

  1. Multi-table Metadata:

    • When returning metadata for tables in a multi-table query, map the data type to the closest available datatype in Rivery. If no close match is found, use "STRING".
  2. Custom Queries:

    • For unsupported data types encountered in custom queries, map them to the closest available datatype in Rivery. If no close match is available, use "STRING".
  3. Failure Handling:

    • Rivery should not fail due to unsupported data types. The system should handle these gracefully according to the mapping rules.
  4. Manual Mapping Changes:

    • If a user manually changes the mapping to an unsupported datatype in the target, Rivery should fail with a clear and appropriate error message.

Was this article helpful?

What's Next