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.