Creating External Table AS (CETAS) on Azure Synapse Analytics

This is a continuation from a prior post that allows users leverage Peruvian voting data with Azure Synapse Serverless.

This post will show how to create an external table using Azure Synapse Analytics. The creation of an external table will place data inside a folder in the Data Lake Store, that has to be specified. The format can be plain text or parquet. Additional information can be found in the Microsoft documentation link.

Continue reading

Taking Assumptions with Peruvian Presidential Voting Data with Azure Synapse Serverless

Last week I published a post that allows users use Peruvian voting data to Azure Synapse Serverless.

This post will allow us take assumptions to visualize votes on the 1st round that aligned to either left or right, and compare them to the 2nd round, where Pedro Castillo (PerĂº Libre) represents the left, and Keiko Fujimori (Fuerza Popular) represents the right.

Continue reading

Peruvian Presidential Voting Data with Azure Synapse Serverless

It has been 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.

Continue reading

Amcrest DVR email trigger does not include attachment

I upgraded my security camera system from standard definition (960 x 480) to 4 MP (2560 x 1440). I had to change my original cables to a Siamese RG59 style, which I had to run again inside the attic, a process I wish not to repeat if I upgrade to 8MP (4K).

I got an Amcrest AMDV4M4-S5 DVR which stores HD footage from analog cameras. Excellent quality nonetheless. Found an issue that many are having, of triggering email attachments when motion is detected, which were not including attachments at all.

Following the standard procedure found on amcrest forums yielded no results. I had to perform trial and error steps within the main device, and this is what I found:

  1. Ensure that Motion Detect is enabled, to send email, and snapshot. You need to enable it for each Channel.
  2. Ensure that Recording is enabled under storage for both Main Stream and Snapshot.
  3. This one is the kicker. Under Storage, Schedule and Snapshot tab, ensure that MD has been marked (yellow) for all days.

You can see the 3 pictures below.

Motion Detection Enabled
Recording Enabled
Snapshot Recording

Hope this helps fixing the email triggering with snapshot issue.