snowflake-sqlalchemy

snowflake-sqlalchemy copied to clipboard

SNOW-606810: Insert List into ARRAY column

4

## What is the current behavior? Currently it doesn't seem possible (as far as I'm able to tell) to insert a List into an ARRAY typed column. ## What is...

ThomasJRyan

SNOW-372459: Missing the way to to do `array_contains`?

2

How do I write a SQLAlchemy ORM that will do `ARRAY_CONTAINS` for an array field in Snowflake? I googled and searched in this repo but couldn't find anything. - Example:...

petercho42

SNOW-638845: ValueError: unsupported format character with version 1.4.0

8

Environment: ``` arrow-cpp 7.0.0 py310hc7d0c5d_8_cpu ... Cached ... python 3.10.5 h582c2e5_0_cpython ... Cached ... snowflake-connector-python 2.7.9 py310hbc1ed79_0 ... Cached snowflake-sqlalchemy 1.4.0 pyhd8ed1ab_0 ... Cached ... sqlalchemy 1.4.39 py310h5764c6d_0 ... Cached...

jonashaag

Please answer these questions before submitting your issue. Thanks! 1. What version of Python are you using? ``` Python 3.8.13 (default, Jul 11 2022, 12:06:54) [Clang 13.0.0 (clang-1300.0.27.3)] ``` 2....

greg-finley

Semistructured Data support for UPDATE and INSERT

4

Hello I have declared class using `declarative_base` ``` from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, VARCHAR, ARRAY Base = declarative_base() class...

olysyuk

SNOW-645168: Binding data in type (bytesio) is not supported.

2

Please answer these questions before submitting your issue. Thanks! 1. What version of Python are you using? Python 3.9.12 2. What operating system and processor architecture are you using? macOS-12.5-arm64-arm-64bit...

janb-frontify

Querying Semistructured Data with Column Elements

5

Please answer these questions before submitting your issue. Thanks! 1. What version of Python are you using (`python --version`)? 3.6.5 2. What operating system and processor architecture are you using...

alanapradhan

SNOW-638842: "WHERE xxx IN :param" does not work as expected

11

1. What version of Python are you using? 3.8.13 2. What operating system and processor architecture are you using? macOS-12.4-x86_64-i386-64bit 3. What are the component versions in the environment (`pip...

shusson

SNOW-638839: MERGE INTO does not render argument correctly

1

Please answer these questions before submitting your issue. Thanks! 1. What version of Python are you using? `3.9.10` 2. What operating system and processor architecture are you using? `Linux-5.10.0-16-cloud-amd64-x86_64-with-glibc2.31` 3....

luciengaitskell

SNOW-638838: Cluster by in ORM classes and queries

1

This is neither a bug nor a feature request - I would have started a "discussion" but it's not enabled on this repo. > 1. What version of Python are...

nareto