Snowflake

Extract Data from text using LLM

source

get_connection

 get_connection (config:llm_data_extractor.models.DBConfig)

Establishes a connection to Snowflake.


source

fetch_data

 fetch_data (query:str,
             conn:snowflake.connector.connection.SnowflakeConnection)

Fetches data from Snowflake using a given query.


source

insert_results

 insert_results (results:List[Dict[str,Any]],
                 conn:snowflake.connector.connection.SnowflakeConnection,
                 table_name:str)

*Inserts or merges extraction results into a Snowflake table.

Args: results: List of dictionaries, where each dictionary represents a row to insert. conn: Snowflake connection object. table_name: The name of the table to insert results into.*