Does anyone know if there is a way to update data on the database from Looks? For example, I have a large dataset where I want to update a boolean field from a 0 to a 1. I found these two bits of information:
but these apply to BigQuery. I guess the point that I’m getting hung up on is creation of the cloud function titled “main.py” on these posts. I know that BigQuery has a library in python that makes it easy to call specific tables, but does Snowflake have something like this? I checked the documentation, but either I missed it or there’s a different syntax than expected.
This isn’t the most helpful reply, but snowflake definitely does have a python connector, with the ability to insert into tables:
That, combined with jesse’s walkthrough should let you build a Snowflake version.