问快速雪片连接仅拉动1次记录

EN

from fastapi import FastAPI
import snowflake.connector as sf
import configparser


username='username_value'
password='password_value'
account= 'account_value'
warehouse= 'test_wh'
database= 'test_db'


ctx=sf.connect(user=username,password=password,account=account,warehouse=warehouse,database=database)

app = FastAPI()
@app.get('/test API')
async def fetchdata():
  cursor = ctx.cursor()
  cursor.execute("USE WAREHOUSE test_WH ")
  cursor.execute("USE DATABASE test_db") 
  cursor.execute("USE SCHEMA test_schema")
  sql = cursor.execute ("SELECT DISTINCT ID,NAME,AGE,CITY FROM TEST_TABLE WHERE AGE > 60")

for data in sql:
  return data