aleksandra_ch
Databricks Employee
Databricks Employee

Hi @vamsi_simbus ,

Databricks Apps don’t yet support installing OS-level packages (apt-get, pkg-config, native client libs).

Could you try to install a Python native MySQL client as a backend of ibis:

  1. Install the core framework only: ibis-framework
  2. Install the mysql connector: PyMySQL
  3.  When you connect, you must explicitly tell Ibis to use the pymysql driver by adding it to the connection URL. This prevents Ibis from looking for the default system-level drivers:
    import ibis
    
    # Format: mysql+pymysql://user:pass@host:port/database
    con = ibis.connect("mysql+pymysql://root:password@localhost:3306/my_db")​

Please let me know if it helps.

Best regards,  

View solution in original post