search

elementary-data / elementary

The dbt-native data observability solution for data & analytics engineers. Monitor your data pipelines in minutes. Available as self-hosted or cloud service with premium features.
https://www.elementary-data.com/
Apache License 2.0
1.87k stars 158 forks source link

Mysql support #1651

Open lukmat86 opened 1 month ago

lukmat86 commented 1 month ago

Hi

Is MySQL supported?

I was trying instruction from quick start section https://docs.elementary-data.com/oss/quickstart/quickstart-cli-package I couldn't find anything related to MySQL in documentation.

I'm working with MySQL 8.0.35

When I'm running dbt run --select elementary I got errors:


08:08:37    Database Error in model data_monitoring_metrics (models/edr/data_monitoring/data_monitoring/data_monitoring_metrics.sql)
  1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(4096)) as id

  ,

          cast('dummy_string' as varchar(' at line 25
  compiled Code at target/run/elementary/models/edr/data_monitoring/data_monitoring/data_monitoring_metrics.sql
08:08:37  
08:08:37    Database Error in model dbt_columns (models/edr/dbt_artifacts/dbt_columns.sql)
  1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(4096)) as unique_id

  ,
```<!-- pylon-ticket-id: d28fe394-227f-471d-ab2a-f5e34054b32d -->
ellakz commented 1 month ago

Hi @lukmat86 , MySQL is currently not supported