https://community.databricks.com/t5/data-engineering/is-azure-database-for-mysql-flexible-server-supported-as/m-p/21698#M14829 <P>In the docs it's mention that <A href="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" alt="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" target="_blank">"if you use Azure Database for MySQL as an external metastore, you must change the value of the&nbsp;</A></P><P><A href="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" alt="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" target="_blank">lower_case_table_names</A></P><P><A href="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" alt="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" target="_blank">&nbsp;property from 1 (the default) to 2 in the server-side database configuration."</A></P><P></P><P>However <A href="https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations" alt="https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations" target="_blank">"lower_case_table_names value can only be set to 1 in Azure Database for MySQL - Flexible Server"</A></P><P></P><P>I just wanted to verify if this disqualifies the MySQL - Flexible Server as an external metastore. If so the docs should probably be updated as the MySQL single server is set to be retired September 16, 2024.</P><P></P> Fri, 18 Nov 2022 16:28:43 GMT jurbschat 2022-11-18T16:28:43Z https://community.databricks.com/t5/data-engineering/is-azure-database-for-mysql-flexible-server-supported-as/m-p/21698#M14829 <P>In the docs it's mention that <A href="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" alt="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" target="_blank">"if you use Azure Database for MySQL as an external metastore, you must change the value of the&nbsp;</A></P><P><A href="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" alt="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" target="_blank">lower_case_table_names</A></P><P><A href="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" alt="https://learn.microsoft.com/en-us/azure/databricks/data/metastores/external-hive-metastore" target="_blank">&nbsp;property from 1 (the default) to 2 in the server-side database configuration."</A></P><P></P><P>However <A href="https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations" alt="https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations" target="_blank">"lower_case_table_names value can only be set to 1 in Azure Database for MySQL - Flexible Server"</A></P><P></P><P>I just wanted to verify if this disqualifies the MySQL - Flexible Server as an external metastore. If so the docs should probably be updated as the MySQL single server is set to be retired September 16, 2024.</P><P></P> Fri, 18 Nov 2022 16:28:43 GMT https://community.databricks.com/t5/data-engineering/is-azure-database-for-mysql-flexible-server-supported-as/m-p/21698#M14829 jurbschat 2022-11-18T16:28:43Z