Use cases

Query Snowflake without writing SQL

Same principle as PostgreSQL and SQL Server, built for data warehouses in Snowflake.

Data

«What's the sales trend over the last six months?»

Gescon builds the query against the authorised warehouse and shows the exact SQL.

Management

«Which product has grown the most this quarter?»

Returns the ranking with the calculation and the query used.

Data

«Where does this figure in the report come from?»

Every answer comes with the query, the tables touched, and the execution time.

Finance

«How much does this process cost per customer?»

Builds the calculation over the authorised tables and shows the breakdown.

What it brings

Read-only, and in plain sight

The connector can't modify data even by mistake: the user it runs as has no permission to.

Dedicated database user

Created by your data team, with SELECT permission and nothing else.

Schemas you authorise

The rest of the warehouse is invisible to Gescon.

The query, always visible

Every answer shows the SQL that produced it, so it can be audited.

Compute limit

Queries are cut off before they can affect the warehouse's performance.

Dedicated or shared warehouse

With whatever compute limit you set for Gescon.

Setup

Create the read-only userYour data team creates it with SELECT permission on the warehouse.

Authorise the connectionAccount, warehouse, and authorised schemas.

Validate with three questionsCheck the SQL it generates before opening it to the team.

Requirements

Estimated connection time: 45 min

Same family