def METHOD_NAME(
    self, obj: PandasDataFrame, schema: str, table: str
) -> Mapping[str, Any]:
    from snowflake import connector
    connector.paramstyle = "pyformat"
    with connect_snowflake(config=self._config, schema=schema) as con:
        with_uppercase_cols = obj.rename(str.upper, copy=False, axis="columns")
        with_uppercase_cols.to_sql(
            table,
            con=con,
            if_exists="append",
            index=False,
            method=pd_writer,
        )
    return {
        "rows": obj.shape[0],
        "dataframe_columns": MetadataValue.table_schema(
            TableSchema(
                columns=[
                    TableColumn(name=name, type=str(dtype))  # type: ignore  # (bad stubs)
                    for name, dtype in obj.dtypes.items()
                ]
            )
        ),
    }