We had a great live presentation on November Friday 12th, 2021, at the Data Community Summit 2021. My colleague Gail Zhou, and I, presented a set of feature parities, capabilities and recommendations when migrating a Data Warehouse from SQL Server to Azure Synapse Analytics Provisioned Pool. We also went ahead and provided a hands-on demo on how to a assess the environment, as well as how to migrate objects and data from SQL Server.
It continues to be a controversial voting scenario for Peruvians, on the second round of voting between Pedro Castillo (far left) and Keiko Fujimori (far right). There have been allegations of fraud, though no tangible evidence has been provided yet.
ONPE, the National Office of Electoral Processes of Peru, has made the voting dataset public, for both 1st and 2nd rounds. That shows the level of transparency the entity is providing, to try mitigate disinformation.
As we continue working with Azure Synapse Analytics on Peruvian voting data, as I have posted before, we are extending to creating an external table from the ground up, that points to existing data in the Data Lake Store.
This post will show how to create an external table that will point to a folder hierarchy that contains data in plain text (CSV format). All files inside the folder will be considered for this example.