The number of web APIs has grown exponentially over the past decade. Today, nearly every product in every sector exposes a public API, and organizations commonly deploy private APIs to share data internally.
With Precog, we connect directly to the source of the data. In this case the source is the FDA.gov Web API. This ensures that we are always working with the latest data including new records and corrections.
This article follows in Keshav’s footsteps, showing how to derive insights from JSON healthcare data using Snowflake and Precog.
When using Snowflake without Precog, the data must first be downloaded from the source. This immediately makes stale data more likely and introduces risks associated with incorrect or outdated results.
Now that the data has been tabulated, we can analyse it using software such as Microsoft Power BI.
Precog shows us that in the adverse events dataset, drug characterizations are denoted as numbers. These numbers represent whether or not the drug was suspected as causing the adverse reaction or interacting with a suspected drug.