Question

Update (write-back) data on Snowflake from Looks

  • 13 June 2019
  • 1 reply
  • 391 views

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:




https://www.dataflix.com/write-back-in-looker/


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.


Thanks,

Joe


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:

https://docs.snowflake.net/manuals/user-guide/python-connector-example.html#creating-tables-and-inserting-data


That, combined with jesse’s walkthrough should let you build a Snowflake version.

Reply