Skip to content

Regression on write_database() to Snowflake with adbc engine since 1.33+ #24433

@Niivii

Description

@Niivii

Checks

  • I have checked that this issue has not already been reported.
  • I have confirmed this bug exists on the latest version of Polars.

Reproducible example

def push_to_snowflake(
        self: pl.DataFrame, connection: adbc_driver_snowflake.dbapi.Connection,
        table: str,
) -> None:
    if not self.is_empty():
        self.write_database(
            table_name=table,
            connection=connection,
            if_table_exists="append",
            engine="adbc",
        )

Log output

File "...\.venv\Lib\site-packages\polars\dataframe\frame.py", line 4377, in write_database
    n_rows = cursor.adbc_ingest(
        unpacked_table_name,
    ...<4 lines>...
        **(engine_options or {}),
    )
  File "...\.venv\Lib\site-packages\adbc_driver_manager\dbapi.py", line 974, in adbc_ingest
    return _blocking_call(self._stmt.execute_update, (), {}, self._stmt.cancel)
  File "adbc_driver_manager/_lib.pyx", line 1695, in adbc_driver_manager._lib._blocking_call
  File "adbc_driver_manager/_lib.pyx", line 1391, in adbc_driver_manager._lib.AdbcStatement.execute_update
  File "adbc_driver_manager/_lib.pyx", line 261, in adbc_driver_manager._lib.check_error
adbc_driver_manager.InternalError: INTERNAL: not implemented: support for STRING_VIEW

Issue description

Issue happens in polars 1.33+ ; fine with <=1.32.3

Expected behavior

dataframe is pushed to Snowflake

Installed versions

--------Version info---------
Polars:              1.33.1
Index type:          UInt32
Platform:            Windows-11-10.0.26100-SP0
Python:              3.13.7 (tags/v3.13.7:bcee1c3, Aug 14 2025, 14:15:11) [MSC v.1944 64 bit (AMD64)]
LTS CPU:             False
----Optional dependencies----
Azure CLI            <not installed>
'az' is not recognized as an internal or external command,
operable program or batch file.
adbc_driver_manager  1.7.0
altair               <not installed>
azure.identity       <not installed>
boto3                <not installed>
cloudpickle          <not installed>
connectorx           <not installed>
deltalake            <not installed>
fastexcel            <not installed>
fsspec               <not installed>
gevent               <not installed>
google.auth          <not installed>
great_tables         <not installed>
matplotlib           <not installed>
numpy                2.3.3
openpyxl             <not installed>
pandas               2.3.2
polars_cloud         <not installed>
pyarrow              21.0.0
pydantic             2.11.7
pyiceberg            <not installed>
sqlalchemy           <not installed>
torch                <not installed>
xlsx2csv             <not installed>
xlsxwriter           <not installed>

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingneeds triageAwaiting prioritization by a maintainerpythonRelated to Python Polars

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions