Skip to main content

snowflake

class atscale.db.connections.snowflake.Snowflake

The child class of SQLConnection whose implementation is meant to handle interactions with a Snowflake DB.

clear_auth

Clears any authentication information, like password or token from the connection.

platform_type_str : str = 'snowflake'

The string representation of the platform type, matches with atscale

write_df_to_db

Writes the provided pandas DataFrame into the provided table name. Can pass in if_exists to indicate the intended behavior if : the provided table name is already taken.

  • Parameters:
    • table_name (str) – What table to write the dataframe into
    • dataframe (DataFrame) – The pandas DataFrame to write into the table
    • dtypes (Dict , optional) – the datatypes of the passed dataframe. Keys should match the column names. Defaults to None and type will be text.
    • if_exists (enums.TableExistsAction , optional) – The intended behavior in case of table name collisions. Defaults to enums.TableExistsAction.ERROR.
    • chunksize (int , optional) – the chunksize for the write operation.