ice_pick.extension#

The extensions module monkey patches the Snowpark Session to add additional functionality. For now this is to give ice_pick a more native feel, where added ice_pick functions can be called from the Snowpark Session class.

Module Contents#

Functions#

create_schema_object(self, database, schema, ...)

create_schema_object_filter(self, databases, schemas, ...)

create_account_object(self, name, object_type)

create_warehouse(self, name)

create_role(self, name)

create_user(self, name)

create_database(self, name)

create_schema(self, name)

create_integration(self, name)

create_network_policy(self, name)

create_resource_monitor(self, name)

create_account_object_filter(self, object_names, ...)

create_privilege(object, privilege)

create_grant(self, session, privilege, role[, ...])

concat(self, union_dfs)

melt(self, df, id_vars, value_vars[, var_name, value_name])

extend_session(→ extend_session.Session)

Returns the extended Session class
ice_pick.extension.create_schema_object(self, database, schema, object_name, object_type)#
ice_pick.extension.create_schema_object_filter(self, databases, schemas, object_names, object_types, ignore_dbs=['SNOWFLAKE_SAMPLE_DATA', 'SNOWFLAKE'], ignore_schemas=['INFORMATION_SCHEMA'])#
ice_pick.extension.create_account_object(self, name, object_type)#
ice_pick.extension.create_warehouse(self, name)#
ice_pick.extension.create_role(self, name)#
ice_pick.extension.create_user(self, name)#
ice_pick.extension.create_database(self, name)#
ice_pick.extension.create_schema(self, name)#
ice_pick.extension.create_integration(self, name)#
ice_pick.extension.create_network_policy(self, name)#
ice_pick.extension.create_resource_monitor(self, name)#
ice_pick.extension.create_account_object_filter(self, object_names, object_types, ignore_names=None)#
ice_pick.extension.create_privilege(object: ice_pick.schema_object.SchemaObject | ice_pick.account_object.AccountObject | ice_pick.account_object.Account, privilege: str)#
ice_pick.extension.create_grant(self, session: snowflake.snowpark.Session, privilege: ice_pick.privileges.Privilege, role: ice_pick.account_object.Role, grant_option: str = None, future_str: str = None)#
ice_pick.extension.concat(self, union_dfs: list)#
ice_pick.extension.melt(self, df, id_vars: list, value_vars: list, var_name: str = 'variable', value_name: str = 'value')#
ice_pick.extension.extend_session(Session: extend_session.Session) → extend_session.Session#

Returns the extended Session class

Parameters:

session (Session) – Snowpark Session

Returns:

The exteneded Snowpark Session

Return type:

Session

Example

>> session = extend_session(Session).builder.configs(connection_parameters).create()