Snowflake Demonstration

In this example we demonstrate using VerbaGPT together with Snowflake. We use the Snowflake sample database in this example.

Video:

User question: give me the total account balance for customers by nationkey. Grab name of nation as well.

VerbaGPT response:

Cost of query: $0.00

VerbaGPT gives us exactly what we asked for. VerbaGPT is a simple yet powerful way to analyze your data. A user can ask any kind of similar question in natural language, and the app does the work to add context, and normalize inputs and outputs so they have a better chance of producing a useful outcome. Check out the full VerbaGPT read-out by click on below.

import pandas as pd

query = """
SELECT NATION.N_NATIONKEY, NATION.N_NAME, SUM(CUSTOMER.C_ACCTBAL) AS TOTAL_BALANCE
FROM NATION
JOIN CUSTOMER ON NATION.N_NATIONKEY = CUSTOMER.C_NATIONKEY
GROUP BY NATION.N_NATIONKEY, NATION.N_NAME
ORDER BY NATION.N_NATIONKEY
"""

df = pd.read_sql(query, conn)
df

For more examples, see the [Examples] menu at the top right.