fenic.api.session
Session module for managing query execution context and state.
Classes:
-
AnthropicLanguageModel
–Configuration for Anthropic language models.
-
CloudConfig
–Configuration for cloud-based execution.
-
CloudExecutorSize
–Enum defining available cloud executor sizes.
-
CohereEmbeddingModel
–Configuration for Cohere embedding models.
-
GoogleDeveloperEmbeddingModel
–Configuration for Google Developer embedding models.
-
GoogleDeveloperLanguageModel
–Configuration for Gemini models accessible through Google Developer AI Studio.
-
GoogleVertexEmbeddingModel
–Configuration for Google Vertex AI embedding models.
-
GoogleVertexLanguageModel
–Configuration for Google Vertex AI models.
-
OpenAIEmbeddingModel
–Configuration for OpenAI embedding models.
-
OpenAILanguageModel
–Configuration for OpenAI language models.
-
SemanticConfig
–Configuration for semantic language and embedding models.
-
Session
–The entry point to programming with the DataFrame API. Similar to PySpark's SparkSession.
-
SessionConfig
–Configuration for a user session.
AnthropicLanguageModel
Bases: BaseModel
Configuration for Anthropic language models.
This class defines the configuration settings for Anthropic language models, including model selection and separate rate limiting parameters for input and output tokens.
Attributes:
-
model_name
(AnthropicLanguageModelName
) –The name of the Anthropic model to use.
-
rpm
(int
) –Requests per minute limit; must be greater than 0.
-
input_tpm
(int
) –Input tokens per minute limit; must be greater than 0.
-
output_tpm
(int
) –Output tokens per minute limit; must be greater than 0.
-
profiles
(Optional[dict[str, Profile]]
) –Optional mapping of profile names to profile configurations.
-
default_profile
(Optional[str]
) –The name of the default profile to use if profiles are configured.
Example
Configuring an Anthropic model with separate input/output rate limits:
config = AnthropicLanguageModel(
model_name="claude-3-5-haiku-latest",
rpm=100,
input_tpm=100,
output_tpm=100
)
Configuring an Anthropic model with profiles:
config = SessionConfig(
semantic=SemanticConfig(
language_models={
"claude": AnthropicLanguageModel(
model_name="claude-opus-4-0",
rpm=100,
input_tpm=100,
output_tpm=100,
profiles={
"thinking_disabled": AnthropicLanguageModel.Profile(),
"fast": AnthropicLanguageModel.Profile(thinking_token_budget=1024),
"thorough": AnthropicLanguageModel.Profile(thinking_token_budget=4096)
},
default_profile="fast"
)
},
default_language_model="claude"
)
# Using the default "fast" profile for the "claude" model
semantic.map(instruction="Construct a formal proof of the {hypothesis}.", model_alias="claude")
# Using the "thorough" profile for the "claude" model
semantic.map(instruction="Construct a formal proof of the {hypothesis}.", model_alias=ModelAlias(name="claude", profile="thorough"))
Classes:
-
Profile
–Anthropic-specific profile configurations.
Profile
Bases: BaseModel
Anthropic-specific profile configurations.
This class defines profile configurations for Anthropic models, allowing different thinking token budget settings to be applied to the same model.
Attributes:
-
thinking_token_budget
(Optional[int]
) –If configuring a model that supports reasoning, provide a default thinking budget in tokens. If not provided, thinking will be disabled for the profile. The minimum token budget supported by Anthropic is 1024 tokens.
Note
If thinking_token_budget
is set, temperature
cannot be customized -- any changes to temperature
will be ignored.
Example
Configuring a profile with a thinking budget:
profile = AnthropicLanguageModel.Profile(thinking_token_budget=2048)
Configuring a profile with a large thinking budget:
profile = AnthropicLanguageModel.Profile(thinking_token_budget=8192)
CloudConfig
Bases: BaseModel
Configuration for cloud-based execution.
This class defines settings for running operations in a cloud environment, allowing for scalable and distributed processing of language model operations.
Attributes:
-
size
(Optional[CloudExecutorSize]
) –Size of the cloud executor instance. If None, the default size will be used.
Example
Configuring cloud execution with a specific size:
config = CloudConfig(size=CloudExecutorSize.MEDIUM)
Using default cloud configuration:
config = CloudConfig()
CloudExecutorSize
Bases: str
, Enum
Enum defining available cloud executor sizes.
This enum represents the different size options available for cloud-based execution environments.
Attributes:
-
SMALL
–Small instance size.
-
MEDIUM
–Medium instance size.
-
LARGE
–Large instance size.
-
XLARGE
–Extra large instance size.
CohereEmbeddingModel
Bases: BaseModel
Configuration for Cohere embedding models.
This class defines the configuration settings for Cohere embedding models, including model selection and rate limiting parameters.
Attributes:
-
model_name
(CohereEmbeddingModelName
) –The name of the Cohere model to use.
-
rpm
(int
) –Requests per minute limit for the model.
-
tpm
(int
) –Tokens per minute limit for the model.
-
profiles
(Optional[dict[str, Profile]]
) –Optional dictionary of profile configurations.
-
default_profile
(Optional[str]
) –Default profile name to use if none specified.
Example
Configuring a Cohere embedding model with profiles:
cohere_config = CohereEmbeddingModel(
model_name="embed-v4.0",
rpm=100,
tpm=50_000,
profiles={
"high_dim": CohereEmbeddingModel.Profile(
embedding_dimensionality=1536,
embedding_task_type="search_document"
),
"classification": CohereEmbeddingModel.Profile(
embedding_dimensionality=1024,
embedding_task_type="classification"
)
},
default_profile="high_dim"
)
Classes:
-
Profile
–Profile configurations for Cohere embedding models.
Profile
Bases: BaseModel
Profile configurations for Cohere embedding models.
This class defines profile configurations for Cohere embedding models, allowing different output dimensionality and task type settings to be applied to the same model.
Attributes:
-
output_dimensionality
(Optional[int]
) –The dimensionality of the embedding created by this model. If not provided, the model will use its default dimensionality.
-
input_type
(CohereEmbeddingTaskType
) –The type of input text (search_query, search_document, classification, clustering)
Example
Configuring a profile with custom dimensionality:
profile = CohereEmbeddingModel.Profile(output_dimensionality=1536)
Configuring a profile with default settings:
profile = CohereEmbeddingModel.Profile()
GoogleDeveloperEmbeddingModel
Bases: BaseModel
Configuration for Google Developer embedding models.
This class defines the configuration settings for Google embedding models available in Google Developer AI Studio, including model selection and rate limiting parameters. These models are accessible using a GOOGLE_API_KEY environment variable.
Attributes:
-
model_name
(GoogleDeveloperEmbeddingModelName
) –The name of the Google Developer embedding model to use.
-
rpm
(int
) –Requests per minute limit; must be greater than 0.
-
tpm
(int
) –Tokens per minute limit; must be greater than 0.
-
profiles
(Optional[dict[str, Profile]]
) –Optional mapping of profile names to profile configurations.
-
default_profile
(Optional[str]
) –The name of the default profile to use if profiles are configured.
Example
Configuring a Google Developer embedding model with rate limits:
config = GoogleDeveloperEmbeddingModelConfig(
model_name="gemini-embedding-001",
rpm=100,
tpm=1000
)
Configuring a Google Developer embedding model with profiles:
config = GoogleDeveloperEmbeddingModelConfig(
model_name="gemini-embedding-001",
rpm=100,
tpm=1000,
profiles={
"default": GoogleDeveloperEmbeddingModelConfig.Profile(),
"high_dim": GoogleDeveloperEmbeddingModelConfig.Profile(output_dimensionality=3072)
},
default_profile="default"
)
Classes:
-
Profile
–Profile configurations for Google Developer embedding models.
Profile
Bases: BaseModel
Profile configurations for Google Developer embedding models.
This class defines profile configurations for Google embedding models, allowing different output dimensionality and task type settings to be applied to the same model.
Attributes:
-
output_dimensionality
(Optional[int]
) –The dimensionality of the embedding created by this model. If not provided, the model will use its default dimensionality.
-
task_type
(GoogleEmbeddingTaskType
) –The type of task for the embedding model.
Example
Configuring a profile with custom dimensionality:
profile = GoogleDeveloperEmbeddingModelConfig.Profile(output_dimensionality=3072)
Configuring a profile with default settings:
profile = GoogleDeveloperEmbeddingModelConfig.Profile()
GoogleDeveloperLanguageModel
Bases: BaseModel
Configuration for Gemini models accessible through Google Developer AI Studio.
This class defines the configuration settings for Google Gemini models available in Google Developer AI Studio, including model selection and rate limiting parameters. These models are accessible using a GOOGLE_API_KEY environment variable.
Attributes:
-
model_name
(GoogleDeveloperLanguageModelName
) –The name of the Google Developer model to use.
-
rpm
(int
) –Requests per minute limit; must be greater than 0.
-
tpm
(int
) –Tokens per minute limit; must be greater than 0.
-
profiles
(Optional[dict[str, Profile]]
) –Optional mapping of profile names to profile configurations.
-
default_profile
(Optional[str]
) –The name of the default profile to use if profiles are configured.
Example
Configuring a Google Developer model with rate limits:
config = GoogleDeveloperLanguageModel(
model_name="gemini-2.0-flash",
rpm=100,
tpm=1000
)
Configuring a reasoning Google Developer model with profiles:
config = GoogleDeveloperLanguageModel(
model_name="gemini-2.5-flash",
rpm=100,
tpm=1000,
profiles={
"thinking_disabled": GoogleDeveloperLanguageModel.Profile(),
"fast": GoogleDeveloperLanguageModel.Profile(thinking_token_budget=1024),
"thorough": GoogleDeveloperLanguageModel.Profile(thinking_token_budget=8192)
},
default_profile="fast"
)
Classes:
-
Profile
–Profile configurations for Google Developer models.
Profile
Bases: BaseModel
Profile configurations for Google Developer models.
This class defines profile configurations for Google Gemini models, allowing different thinking/reasoning settings to be applied to the same model.
Attributes:
-
thinking_token_budget
(Optional[int]
) –If configuring a reasoning model, provide a thinking budget in tokens. If not provided, or if set to 0, thinking will be disabled for the profile (not supported on gemini-2.5-pro). To have the model automatically determine a thinking budget based on the complexity of the prompt, set this to -1. Note that Gemini models take this as a suggestion -- and not a hard limit. It is very possible for the model to generate far more thinking tokens than the suggested budget, and for the model to generate reasoning tokens even if thinking is disabled.
Example
Configuring a profile with a fixed thinking budget:
profile = GoogleDeveloperLanguageModel.Profile(thinking_token_budget=4096)
Configuring a profile with automatic thinking budget:
profile = GoogleDeveloperLanguageModel.Profile(thinking_token_budget=-1)
Configuring a profile with thinking disabled:
profile = GoogleDeveloperLanguageModel.Profile(thinking_token_budget=0)
GoogleVertexEmbeddingModel
Bases: BaseModel
Configuration for Google Vertex AI embedding models.
This class defines the configuration settings for Google embedding models available in Google Vertex AI, including model selection and rate limiting parameters. These models are accessible using Google Cloud credentials.
Attributes:
-
model_name
(GoogleVertexEmbeddingModelName
) –The name of the Google Vertex embedding model to use.
-
rpm
(int
) –Requests per minute limit; must be greater than 0.
-
tpm
(int
) –Tokens per minute limit; must be greater than 0.
-
profiles
(Optional[dict[str, Profile]]
) –Optional mapping of profile names to profile configurations.
-
default_profile
(Optional[str]
) –The name of the default profile to use if profiles are configured.
Example
Configuring a Google Vertex embedding model with rate limits:
embedding_model = GoogleVertexEmbeddingModel(
model_name="gemini-embedding-001",
rpm=100,
tpm=1000
)
Configuring a Google Vertex embedding model with profiles:
embedding_model = GoogleVertexEmbeddingModel(
model_name="gemini-embedding-001",
rpm=100,
tpm=1000,
profiles={
"default": GoogleVertexEmbeddingModel.Profile(),
"high_dim": GoogleVertexEmbeddingModel.Profile(output_dimensionality=3072)
},
default_profile="default"
)
Classes:
-
Profile
–Profile configurations for Google Vertex embedding models.
Profile
Bases: BaseModel
Profile configurations for Google Vertex embedding models.
This class defines profile configurations for Google embedding models, allowing different output dimensionality and task type settings to be applied to the same model.
Attributes:
-
output_dimensionality
(Optional[int]
) –The dimensionality of the embedding created by this model. If not provided, the model will use its default dimensionality.
-
task_type
(GoogleEmbeddingTaskType
) –The type of task for the embedding model.
Example
Configuring a profile with custom dimensionality:
profile = GoogleVertexEmbeddingModelConfig.Profile(output_dimensionality=3072)
Configuring a profile with default settings:
profile = GoogleVertexEmbeddingModelConfig.Profile()
GoogleVertexLanguageModel
Bases: BaseModel
Configuration for Google Vertex AI models.
This class defines the configuration settings for Google Gemini models available in Google Vertex AI, including model selection and rate limiting parameters. These models are accessible using Google Cloud credentials.
Attributes:
-
model_name
(GoogleVertexLanguageModelName
) –The name of the Google Vertex model to use.
-
rpm
(int
) –Requests per minute limit; must be greater than 0.
-
tpm
(int
) –Tokens per minute limit; must be greater than 0.
-
profiles
(Optional[dict[str, Profile]]
) –Optional mapping of profile names to profile configurations.
-
default_profile
(Optional[str]
) –The name of the default profile to use if profiles are configured.
Example
Configuring a Google Vertex model with rate limits:
config = GoogleVertexLanguageModel(
model_name="gemini-2.0-flash",
rpm=100,
tpm=1000
)
Configuring a reasoning Google Vertex model with profiles:
config = GoogleVertexLanguageModel(
model_name="gemini-2.5-flash",
rpm=100,
tpm=1000,
profiles={
"thinking_disabled": GoogleVertexLanguageModel.Profile(),
"fast": GoogleVertexLanguageModel.Profile(thinking_token_budget=1024),
"thorough": GoogleVertexLanguageModel.Profile(thinking_token_budget=8192)
},
default_profile="fast"
)
Classes:
-
Profile
–Profile configurations for Google Vertex models.
Profile
Bases: BaseModel
Profile configurations for Google Vertex models.
This class defines profile configurations for Google Gemini models, allowing different thinking/reasoning settings to be applied to the same underlying model.
Attributes:
-
thinking_token_budget
(Optional[int]
) –If configuring a reasoning model, provide a thinking budget in tokens. If not provided, or if set to 0, thinking will be disabled for the profile (not supported on gemini-2.5-pro). To have the model automatically determine a thinking budget based on the complexity of the prompt, set this to -1. Note that Gemini models take this as a suggestion -- and not a hard limit. It is very possible for the model to generate far more thinking tokens than the suggested budget, and for the model to generate reasoning tokens even if thinking is disabled.
Example
Configuring a profile with a fixed thinking budget:
profile = GoogleVertexLanguageModel.Profile(thinking_token_budget=4096)
Configuring a profile with automatic thinking budget:
profile = GoogleVertexLanguageModel.Profile(thinking_token_budget=-1)
Configuring a profile with thinking disabled:
profile = GoogleVertexLanguageModel.Profile(thinking_token_budget=0)
OpenAIEmbeddingModel
Bases: BaseModel
Configuration for OpenAI embedding models.
This class defines the configuration settings for OpenAI embedding models, including model selection and rate limiting parameters.
Attributes:
-
model_name
(OpenAIEmbeddingModelName
) –The name of the OpenAI embedding model to use.
-
rpm
(int
) –Requests per minute limit; must be greater than 0.
-
tpm
(int
) –Tokens per minute limit; must be greater than 0.
Example
Configuring an OpenAI embedding model with rate limits:
config = OpenAIEmbeddingModel(
model_name="text-embedding-3-small",
rpm=100,
tpm=100
)
OpenAILanguageModel
Bases: BaseModel
Configuration for OpenAI language models.
This class defines the configuration settings for OpenAI language models, including model selection and rate limiting parameters.
Attributes:
-
model_name
(OpenAILanguageModelName
) –The name of the OpenAI model to use.
-
rpm
(int
) –Requests per minute limit; must be greater than 0.
-
tpm
(int
) –Tokens per minute limit; must be greater than 0.
-
profiles
(Optional[dict[str, Profile]]
) –Optional mapping of profile names to profile configurations.
-
default_profile
(Optional[str]
) –The name of the default profile to use if profiles are configured.
Example
Configuring an OpenAI language model with rate limits:
config = OpenAILanguageModel(
model_name="gpt-4.1-nano",
rpm=100,
tpm=100
)
Configuring an OpenAI model with profiles:
config = OpenAILanguageModel(
model_name="o4-mini",
rpm=100,
tpm=100,
profiles={
"fast": OpenAILanguageModel.Profile(reasoning_effort="low"),
"thorough": OpenAILanguageModel.Profile(reasoning_effort="high")
},
default_profile="fast"
)
Using a profile in a semantic operation:
config = SemanticConfig(
language_models={
"o4": OpenAILanguageModel(
model_name="o4-mini",
rpm=1_000,
tpm=1_000_000,
profiles={
"fast": OpenAILanguageModel.Profile(reasoning_effort="low"),
"thorough": OpenAILanguageModel.Profile(reasoning_effort="high")
},
default_profile="fast"
)
},
default_language_model="o4"
)
# Will use the default "fast" profile for the "o4" model
semantic.map(instruction="Construct a formal proof of the {hypothesis}.", model_alias="o4")
# Will use the "thorough" profile for the "o4" model
semantic.map(instruction="Construct a formal proof of the {hypothesis}.", model_alias=ModelAlias(name="o4", profile="thorough"))
Classes:
-
Profile
–OpenAI-specific profile configurations.
Profile
Bases: BaseModel
OpenAI-specific profile configurations.
This class defines profile configurations for OpenAI models, allowing a user to reference the same underlying model in semantic operations with different settings. For now, only the reasoning effort can be customized.
Attributes:
-
reasoning_effort
(Optional[ReasoningEffort]
) –If configuring a reasoning model, provide a reasoning effort. OpenAI has separate o-series reasoning models, for which thinking cannot be disabled. If an o-series model is specified, but no
reasoning_effort
is provided, thereasoning_effort
will be set tolow
.
Note
When using an o-series reasoning model, the temperature
cannot be customized -- any changes to temperature
will be ignored.
Example
Configuring a profile with medium reasoning effort:
profile = OpenAILanguageModel.Profile(reasoning_effort="medium")
SemanticConfig
Bases: BaseModel
Configuration for semantic language and embedding models.
This class defines the configuration for both language models and optional embedding models used in semantic operations. It ensures that all configured models are valid and supported by their respective providers.
Attributes:
-
language_models
(Optional[dict[str, LanguageModel]]
) –Mapping of model aliases to language model configurations.
-
default_language_model
(Optional[str]
) –The alias of the default language model to use for semantic operations. Not required if only one language model is configured.
-
embedding_models
(Optional[dict[str, EmbeddingModel]]
) –Optional mapping of model aliases to embedding model configurations.
-
default_embedding_model
(Optional[str]
) –The alias of the default embedding model to use for semantic operations.
Note
The embedding model is optional and only required for operations that need semantic search or embedding capabilities.
Example
Configuring semantic models with a single language model:
config = SemanticConfig(
language_models={
"gpt4": OpenAILanguageModel(
model_name="gpt-4.1-nano",
rpm=100,
tpm=100
)
}
)
Configuring semantic models with multiple language models and an embedding model:
config = SemanticConfig(
language_models={
"gpt4": OpenAILanguageModel(
model_name="gpt-4.1-nano",
rpm=100,
tpm=100
),
"claude": AnthropicLanguageModel(
model_name="claude-3-5-haiku-latest",
rpm=100,
input_tpm=100,
output_tpm=100
),
"gemini": GoogleDeveloperLanguageModel(
model_name="gemini-2.0-flash",
rpm=100,
tpm=1000
)
},
default_language_model="gpt4",
embedding_models={
"openai_embeddings": OpenAIEmbeddingModel(
model_name="text-embedding-3-small",
rpm=100,
tpm=100
)
},
default_embedding_model="openai_embeddings"
)
Configuring models with profiles:
config = SemanticConfig(
language_models={
"gpt4": OpenAILanguageModel(
model_name="gpt-4o-mini",
rpm=100,
tpm=100,
profiles={
"fast": OpenAILanguageModel.Profile(reasoning_effort="low"),
"thorough": OpenAILanguageModel.Profile(reasoning_effort="high")
},
default_profile="fast"
),
"claude": AnthropicLanguageModel(
model_name="claude-3-5-haiku-latest",
rpm=100,
input_tpm=100,
output_tpm=100,
profiles={
"fast": AnthropicLanguageModel.Profile(thinking_token_budget=1024),
"thorough": AnthropicLanguageModel.Profile(thinking_token_budget=4096)
},
default_profile="fast"
)
},
default_language_model="gpt4"
)
Methods:
-
model_post_init
–Post initialization hook to set defaults.
-
validate_models
–Validates that the selected models are supported by the system.
model_post_init
model_post_init(__context) -> None
Post initialization hook to set defaults.
This hook runs after the model is initialized and validated. It sets the default language and embedding models if they are not set and there is only one model available.
Source code in src/fenic/api/session/config.py
793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 |
|
validate_models
validate_models() -> SemanticConfig
Validates that the selected models are supported by the system.
This validator checks that both the language model and embedding model (if provided) are valid and supported by their respective providers.
Returns:
-
SemanticConfig
–The validated SemanticConfig instance.
Raises:
-
ConfigurationError
–If any of the models are not supported.
Source code in src/fenic/api/session/config.py
826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 |
|
Session
The entry point to programming with the DataFrame API. Similar to PySpark's SparkSession.
Create a session with default configuration
session = Session.get_or_create(SessionConfig(app_name="my_app"))
Create a session with cloud configuration
config = SessionConfig(
app_name="my_app",
cloud=True,
api_key="your_api_key"
)
session = Session.get_or_create(config)
Methods:
-
create_dataframe
–Create a DataFrame from a variety of Python-native data formats.
-
get_or_create
–Gets an existing Session or creates a new one with the configured settings.
-
sql
–Execute a read-only SQL query against one or more DataFrames using named placeholders.
-
stop
–Stops the session and closes all connections.
-
table
–Returns the specified table as a DataFrame.
-
view
–Returns the specified view as a DataFrame.
Attributes:
-
catalog
(Catalog
) –Interface for catalog operations on the Session.
-
read
(DataFrameReader
) –Returns a DataFrameReader that can be used to read data in as a DataFrame.
catalog
property
catalog: Catalog
Interface for catalog operations on the Session.
read
property
read: DataFrameReader
Returns a DataFrameReader that can be used to read data in as a DataFrame.
Returns:
-
DataFrameReader
(DataFrameReader
) –A reader interface to read data into DataFrame
Raises:
-
RuntimeError
–If the session has been stopped
create_dataframe
create_dataframe(data: DataLike) -> DataFrame
Create a DataFrame from a variety of Python-native data formats.
Parameters:
-
data
(DataLike
) –Input data. Must be one of: - Polars DataFrame - Pandas DataFrame - dict of column_name -> list of values - list of dicts (each dict representing a row) - pyarrow Table
Returns:
-
DataFrame
–A new DataFrame instance
Raises:
-
ValueError
–If the input format is unsupported or inconsistent with provided column names.
Create from Polars DataFrame
import polars as pl
df = pl.DataFrame({"col1": [1, 2], "col2": ["a", "b"]})
session.create_dataframe(df)
Create from Pandas DataFrame
import pandas as pd
df = pd.DataFrame({"col1": [1, 2], "col2": ["a", "b"]})
session.create_dataframe(df)
Create from dictionary
session.create_dataframe({"col1": [1, 2], "col2": ["a", "b"]})
Create from list of dictionaries
session.create_dataframe([
{"col1": 1, "col2": "a"},
{"col1": 2, "col2": "b"}
])
Create from pyarrow Table
import pyarrow as pa
table = pa.Table.from_pydict({"col1": [1, 2], "col2": ["a", "b"]})
session.create_dataframe(table)
Source code in src/fenic/api/session/session.py
132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 |
|
get_or_create
classmethod
get_or_create(config: SessionConfig) -> Session
Gets an existing Session or creates a new one with the configured settings.
Returns:
-
Session
–A Session instance configured with the provided settings
Source code in src/fenic/api/session/session.py
62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 |
|
sql
sql(query: str, /, **tables: DataFrame) -> DataFrame
Execute a read-only SQL query against one or more DataFrames using named placeholders.
This allows you to execute ad hoc SQL queries using familiar syntax when it's more convenient than the DataFrame API.
Placeholders in the SQL string (e.g. {df}
) should correspond to keyword arguments (e.g. df=my_dataframe
).
For supported SQL syntax and functions, refer to the DuckDB SQL documentation: https://duckdb.org/docs/sql/introduction.
Parameters:
-
query
(str
) –A SQL query string with placeholders like
{df}
-
**tables
(DataFrame
, default:{}
) –Keyword arguments mapping placeholder names to DataFrames
Returns:
-
DataFrame
–A lazy DataFrame representing the result of the SQL query
Raises:
-
ValidationError
–If a placeholder is used in the query but not passed as a keyword argument
Simple join between two DataFrames
df1 = session.create_dataframe({"id": [1, 2]})
df2 = session.create_dataframe({"id": [2, 3]})
result = session.sql(
"SELECT * FROM {df1} JOIN {df2} USING (id)",
df1=df1,
df2=df2
)
Complex query with multiple DataFrames
users = session.create_dataframe({"user_id": [1, 2], "name": ["Alice", "Bob"]})
orders = session.create_dataframe({"order_id": [1, 2], "user_id": [1, 2]})
products = session.create_dataframe({"product_id": [1, 2], "name": ["Widget", "Gadget"]})
result = session.sql("""
SELECT u.name, p.name as product
FROM {users} u
JOIN {orders} o ON u.user_id = o.user_id
JOIN {products} p ON o.product_id = p.product_id
""", users=users, orders=orders, products=products)
Source code in src/fenic/api/session/session.py
265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 |
|
stop
stop()
Stops the session and closes all connections.
Source code in src/fenic/api/session/session.py
337 338 339 |
|
table
table(table_name: str) -> DataFrame
Returns the specified table as a DataFrame.
Parameters:
-
table_name
(str
) –Name of the table
Returns:
-
DataFrame
–Table as a DataFrame
Raises:
-
ValueError
–If the table does not exist
Load an existing table
df = session.table("my_table")
Source code in src/fenic/api/session/session.py
222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 |
|
view
view(view_name: str) -> DataFrame
Returns the specified view as a DataFrame.
Parameters:
-
view_name
(str
) –Name of the view
Returns: DataFrame: Dataframe with the given view
Source code in src/fenic/api/session/session.py
246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 |
|
SessionConfig
Bases: BaseModel
Configuration for a user session.
This class defines the complete configuration for a user session, including application settings, model configurations, and optional cloud settings. It serves as the central configuration object for all language model operations.
Attributes:
-
app_name
(str
) –Name of the application using this session. Defaults to "default_app".
-
db_path
(Optional[Path]
) –Optional path to a local database file for persistent storage.
-
semantic
(Optional[SemanticConfig]
) –Configuration for semantic models (optional).
-
cloud
(Optional[CloudConfig]
) –Optional configuration for cloud execution.
Note
The semantic configuration is optional. When not provided, only non-semantic operations are available. The cloud configuration is optional and only needed for distributed processing.
Example
Configuring a basic session with a single language model:
config = SessionConfig(
app_name="my_app",
semantic=SemanticConfig(
language_models={
"gpt4": OpenAILanguageModel(
model_name="gpt-4.1-nano",
rpm=100,
tpm=100
)
}
)
)
Configuring a session with multiple models and cloud execution:
config = SessionConfig(
app_name="production_app",
db_path=Path("/path/to/database.db"),
semantic=SemanticConfig(
language_models={
"gpt4": OpenAILanguageModel(
model_name="gpt-4.1-nano",
rpm=100,
tpm=100
),
"claude": AnthropicLanguageModel(
model_name="claude-3-5-haiku-latest",
rpm=100,
input_tpm=100,
output_tpm=100
)
},
default_language_model="gpt4",
embedding_models={
"openai_embeddings": OpenAIEmbeddingModel(
model_name="text-embedding-3-small",
rpm=100,
tpm=100
)
},
default_embedding_model="openai_embeddings"
),
cloud=CloudConfig(size=CloudExecutorSize.MEDIUM)
)