Comments (9)
@timgraham we need support added for variant, array list and last insert object for Snowflake in the django project. Our deployment is at standstill without these changes. Could you take this on priority?
from django-snowflake.
@timgraham we need this support added to build our connectors for Snowpark and to help our customers moved to Snowflake who are using Django. We can't move forward until this ticket is resolved and django community is a wide community that Snowflake can't afford to loose.
from django-snowflake.
@timgraham do you have any update on this request? We and our customers can't move forward with Snowflake onboarding as this is the blocker. We need this issue fix ASAP for us to keep moving for building our app on the Snowflake platform. We are building our connectors on Snowpark and need to host our app through django with Snowflake as a database and this will help our customers have Snowflake as the underline database for all of our subscription. We really need to get this done sooner than later. Would you able to provide an ETA on this? We need this by next week otherwise unfortunately we need to switch our tech stack from Snowflake as it seems we are not getting the support that we should have.
from django-snowflake.
I'm not sure it's possible to implement without snowflakedb/snowflake-connector-python#244 which requires non-trivial server-side changes according to @sfc-gh-mkeller. I'll post an update if I find a workaround for this project or hear an ETA on snowflakedb/snowflake-connector-python#244.
from django-snowflake.
There appears to be hope to implement this without changes in Snowflake and Snowflake Connector Python.
As suggested in snowflakedb/snowflake-connector-python#244 (comment), I'm overriding Django's SQLInsertCompiler
to generate queries of the form
insert into t(c1,c2,c3) select column1, column2, parse_json(column3) from values(%s, %s, %s)
when JSONField
is involved.
Now I'm working through Django's model_fields.test_jsonfield
, implementing the various query lookups. I'll update on the progress sometime next week.
from django-snowflake.
@timgraham thanks for the information, I am looking forward for a fix on this
from django-snowflake.
@timgraham do you have any update on this?
from django-snowflake.
The pull request linked above your comment is mostly completed. I've been waiting for some feedback from Snowflake engineering on a few remaining questions.
from django-snowflake.
from django-snowflake.
Related Issues (20)
- Add support for resetting autoincrement sequences
- UUIDs being stripped of hyphens HOT 1
- Add support for introspecting lower case identifiers
- ERROR in RawQueryset [Raw SQL ]
- Error: The session does not have a current database HOT 7
- Unable to use the connector with external browser authentication HOT 1
- Switch to REGEXP_INSTR to avoid implicit anchoring
- Use last_query_id when retrieving last_insert_id HOT 2
- JSONField queries with complex JSON parameters don't work
- Consider changing NAME to DB_NAME HOT 2
- Option private_key does not work when launching SnowSQL HOT 3
- ROLE should be a top level config HOT 3
- instead of last_insert_id, can we set "can_return_columns_from_insert" as False? HOT 2
- Document how to authenticate with a private key HOT 1
- Datetime should be Timestamp_ntz HOT 6
- Persistent DB connection (a la `CONN_MAX_AGE`) HOT 5
- Receiving 'Error detecting the version of libcrypto' when connecting to Django HOT 1
- Slow performance HOT 3
- authenticator:externalbrowser issue HOT 3
- "The error was: too many values to unpack (expected 11)" while running inspectdb HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from django-snowflake.