search

segmentio / segment-docs

Segment Documentation. Powered by Jekyll.
https://segment.com/docs/
Creative Commons Attribution 4.0 International
46 stars 324 forks source link

[Content]: Segment Data Lakes (Azure) #5391

Open jordanskole opened 9 months ago

jordanskole commented 9 months ago

What article on segment.com/docs is affected?

https://segment.com/docs/connections/storage/catalog/data-lakes/#set-up-segment-data-lakes-azure

What part(s) of the article would you like to see updated?

In Part 3 - Set up Azure MySQL Database it asks you to set the lower_case_table_names to 2.

Unfortunately this isn't possible in version 8.0 (the default option) of MySQL in Azure (Microsoft Docs)

So either this works without it on 8, or the docs should ask the user to use ~5.7

P.S. Azure is saying they are going to stop support of 5.7 in Sept 2025 -- plenty of time -- but eventually there will need to be a workaround.

Additional information

No response

jordanskole commented 9 months ago

Ugh, sorry going through this a bit more. Azure is also depriciating Single Servers and only allowing creation of "Flexible Servers" going forward. Flexible Servers don't let you modify the lower_case_table_names parameter even on 5.7.

However, azure does have some documentation on how to "set the parameter at the connection level using init_connect" Setting non-modifiable server parameters

Edit: and it does appear that this is possible in both 8.0 and 5.7

github-actions[bot] commented 7 months ago

This issue is stale because it has been open 60 days with no activity.