Access to a MariaDb (RDS) Database in v10

[mbopp]

I've seen other tickets related to this matter but I would like to confirm that it is not possible at this time to connect to MariaDB from ReDash v10 (on the AMI EC2 instance).
#5789

Updating to v10 resulted in an error whenever varchar fields are returned.

Error running query: 'Result' object has no attribute 'json_data'

The default AMI with v8 works as expected.

If there is a workaround to this issue, please let me know. I would be willing to set the RDS instance up another way if necessary. I am putting together a proof of concept at this time and have some flexibility to how this infrastructure is created.

Thank You so much.

[snickerjp]

@mbopp

Are you using MariaDB v11? Redash v10 does not officially support MariaDB v11.
As a workaround, we recommend using the latest Redash v25.1.0.

You can find the setup instructions in the following documentation:
📄 [Redash Open Source Setup](https://redash.io/help/open-source/setup/#docker)

The setup scripts can be found here:
🔗 [Redash Setup Scripts](https://github.com/getredash/setup)

However, the setup.sh script does not support version 25.1.0, so some manual changes are required:

1. After running setup.sh, edit the /opt/redash/compose.yaml file and update the image tag to 25.1.0.
2. Then, execute the following command:

   docker compose run --rm server manage db upgrade

Please try this approach and let us know if it works for you.

[jan-abel-inwt]

Hello,

We are encountering a similar issue as described here when trying to connect Redash to our database instance.

Our setup involves a MariaDB RDS version 11.4.5. We are experiencing the same 'Result' object has no attribute 'json_data' error, particularly when VARCHAR or timestamp fields seem to be involved, preventing us from querying the database effectively.

Could you please provide an update on whether there has been any progress on a fix or a confirmed workaround for this incompatibility?

Thank you for any information you can provide!