Why Tablyne for Snowflake
A desktop Snowflake client that only reads, estimates the scan before a query runs and asks before waking a suspended warehouse.
Tablyne reads your Snowflake data from a desktop client and tells you what a query will scan before it runs. It refuses everything else.
A Snowflake connection in Tablyne is read-only, and that setting is fixed. The connection form shows “Read-only (fixed)” and you cannot switch it off. A statement that would write, such as INSERT, UPDATE, DELETE, CREATE, DROP or COPY, is rejected before it is sent. Only reads pass. Tablyne also tells you to use a read-only role in Snowflake, because the app’s guard is a safeguard and not a replacement for grants.
What you see before a query runs
For a SELECT, Tablyne asks Snowflake for an EXPLAIN USING JSON plan. That compiles the query and does not need a running warehouse. The console then shows how many bytes and partitions the query would scan, and how many credits per hour the warehouse size uses. The figure is an upper bound, and Tablyne says so. It never shows a dollar amount, because the price of a credit depends on your contract.
If the estimate is above the threshold set on the connection, the console asks you to confirm. The default threshold is 10 GiB. It is a warning, not a cap.
One window with the rest of your stack
The same app holds your other database connections. You can read a Snowflake result, then open another engine in the next tab, without switching tools.