Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support VARIANT columns in SnowflakeReader #265

Open
criccomini opened this issue Jun 15, 2023 · 0 comments
Open

Support VARIANT columns in SnowflakeReader #265

criccomini opened this issue Jun 15, 2023 · 0 comments

Comments

@criccomini
Copy link
Contributor

Snowflake has a VARIANT type that can be any of Snowflake's types. Recap doesn't support this right now.

Several ideas come to mind for this:

  1. Add an any type to Recap's type system.
  2. Change list's (and map's) values attribute from required to optional. An unset values would be treated as a a variant type.
  3. Do nothing. This would prevent OBJECT and ARRAY support in SnowflakeReader.
  4. Treat all VARIANTs as strings.

There is some discussion on #259 on this issue and some of the tradeoffs.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@criccomini