Video: Enriching International Phone Numbers Within PostgreSQL - All Automated, No Coding.

Posted on April 28th, 2021

In this step-by-step walkthrough example, a database is created and populated with sample data using Postgres version 13.2 (works the same with previous versions). Then, Interzoid’s Cloud Data Connect Product is used to append and enrich the international telephone sample data by directly connecting to PostgreSQL and calling Interzoid's Global Telephone Information API sequentially for each record in a batch-like process. This includes geographic data such as country, region, and city. It also provides data points such as language spoken, is it a mobile phone, and estimated wealth category. The data is inserted into a PostgreSQL table to make it easy to use within any database application, for queries, joins, exporting, etc. - all automated and without any coding. The end result is better and more valuable data assets via the bridging of Cloud database platforms and APIs, providing a better data foundation for analytics, data science, artificial intelligence, machine learning, marketing, CRM, and any other data-driven initiative.