Skip to content

Snowflake query engine

SnowflakeQueryEnginePack #

Bases: BaseLlamaPack

Snowflake查询引擎包。 它使用snowflake-sqlalchemy连接到Snowflake，然后调用 NLSQLTableQueryEngine来查询数据。

Source code in llama_index/packs/snowflake_query_engine/base.py 
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
class SnowflakeQueryEnginePack(BaseLlamaPack):
    """Snowflake查询引擎包。
    它使用snowflake-sqlalchemy连接到Snowflake，然后调用
    NLSQLTableQueryEngine来查询数据。"""

    def __init__(
        self,
        user: str,
        password: str,
        account: str,
        database: str,
        schema: str,
        warehouse: str,
        role: str,
        tables: List[str],
        **kwargs: Any,
    ) -> None:
        """初始化参数。"""
        # workaround for https://github.com/snowflakedb/snowflake-sqlalchemy/issues/380.
        try:
            snowflake_sqlalchemy_20_monkey_patches()
        except Exception:
            raise ImportError("Please run `pip install snowflake-sqlalchemy`")

        if not os.environ.get("OPENAI_API_KEY", None):
            raise ValueError("OpenAI API Token is missing or blank.")

        snowflake_uri = f"snowflake://{user}:{password}@{account}/{database}/{schema}?warehouse={warehouse}&role={role}"

        engine = create_engine(snowflake_uri)

        self._sql_database = SQLDatabase(engine)
        self.tables = tables

        self._service_context = ServiceContext.from_defaults()

        self.query_engine = NLSQLTableQueryEngine(
            sql_database=self._sql_database,
            tables=self.tables,
            service_context=self._service_context,
        )

    def get_modules(self) -> Dict[str, Any]:
        """获取模块。"""
        return {
            "service_context": self._service_context,
            "sql_database": self._sql_database,
            "query_engine": self.query_engine,
        }

    def run(self, *args: Any, **kwargs: Any) -> Any:
        """运行流水线。"""
        return self.query_engine.query(*args, **kwargs)

get_modules #

get_modules() -> Dict[str, Any]

获取模块。

Source code in llama_index/packs/snowflake_query_engine/base.py 
54
55
56
57
58
59
60
def get_modules(self) -> Dict[str, Any]:
    """获取模块。"""
    return {
        "service_context": self._service_context,
        "sql_database": self._sql_database,
        "query_engine": self.query_engine,
    }

run #

run(*args: Any, **kwargs: Any) -> Any

运行流水线。

Source code in llama_index/packs/snowflake_query_engine/base.py 
62
63
64
def run(self, *args: Any, **kwargs: Any) -> Any:
    """运行流水线。"""
    return self.query_engine.query(*args, **kwargs)