Administrative Boundaries USA

Uli Bethke December 20, 2021

Overview The dataset Administrative Boundaries USA contains border information as polygons about the following divisions of the fifty states, the District of Columbia, Puerto Rico, and the Island areas (American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, and the United States Virgin Islands) of the United States. States Counties Zip Code Tabulation Areas ...

Read More

Data Warehouse 3.0. A Reference Architecture for the Modern Data Warehouse.

Uli Bethke December 9, 2021

Reference data architecture for data management and analytics. An introduction. I frequently come across data architecture diagrams that are riddled with vendor names, tools, and technologies. Tools and technologies have a place in data architecture but it is not a primary role. It is more of a support act than the main act. First and ...

Read More

SQL Parser Use Cases.

Uli Bethke October 22, 2021

Benefits for Data Governance and Data Engineering 1. What is an SQL Parser? You are probably surprised to learn that SQL parsing underpins many data governance and data engineering use cases ranging from data lineage to performance tuning, data protection, productivity and many more. An SQL Parser deconstructs an SQL query into its individual components. ...

Read More

Snowflake vs. Redshift – Support for Handling JSON

Uli Bethke June 22, 2021

ANSI SQL 2016 introduced support for querying JSON data directly from SQL. This is a common use case nowadays. JSON is everywhere in web based applications, IOT, NoSQL databases, and when querying APIs. In this document we compare Amazon Redshift and Snowflake features to handle JSON documents. Loading JSON data In this section, we will ...

Read More
1 2 3 11