Hey first of all, welcome the Looker community! I’m happy to talk a little bit about what would be required here.
Looker is really, really good at acting as a single source of truth for data consumers, but at the moment it doesn’t support any kind of feedback that would write back to your database. In fact, if Snowflake is set up using our recommended steps, it’s likely that Looker doesn’t even have permissions to write to Snowflake.
You’re probably using something like
RJDBC to access Snowflake, right? Writing back to the database using these tools is probably your best bet. I have seen some folks who use the Looker API to query data and then write back to their database using ODBC, for example to write back the results of their regression or their machine learning classification. This can be useful because querying becomes very easy and you benefit from all the data clean-up and transformation that happens in Looker’s modeling layer, but some people are more comfortable using ODBC for both reading and writing.
Let me know if you have any questions or if I got something wrong about your original post, and welcome again!