Update (write-back) data on Snowflake from Looks

  • 13 June 2019
  • 1 reply

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 “” 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.



1 reply

Userlevel 7
Badge +1

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.