Want to export data from Snowflake to G-Sheet ? There are some existing tools like Coefficient, but they are pricy and has some limitation when it comes to efficiency & fetching data from multiple tables. Hence, I developed SnowSheet. SnowSheet helps democratise data by making it available in G-Sheets.

With SnowSheet, you can write a SQL query as usual in the Snowflake UI, combining multiple tables, conditions, etc. All you need to do is add the link of the worksheet to SnowSheet, along with the target G-Sheet. Based on the frequency specified, SnowSheet excutes the query and writes the resultant data to the target G-Sheet.

Magicpot, as the name suggests, it's a collection of disconnected modules, that share the common objective of easing the life of data professionals.

Have you tried accessing G-Sheets with Python ? It requires tons of libraries to be imported everytime before we can access the G-Sheet. As a data professional, you might have to write the output data from a Jupyter Notebook to a G-Sheet often and you don't want to waste time importing the same libraries over and over again.

Instead you can use Magicpot, a python package that enables you to read and write data into G-Sheets with just 2 lines of code.

Another module inside Magicpot is xBridge, as way to share data between different notebooks in Deepnote project