Sql

A quick walkthrough of using these two open source projects together — In this post, we’re going to show you how easy it is to run Hamilton inside a DBT task. Making use of DBT’s exciting new python API, we can blend the two frameworks seamlessly. Hamilton is a declarative micro-framework to describe dataflows in python. For example, it’s excellent for expressing…

Learn how to create and change structures in BigQuery — Introduction In a modern database, data is no longer stored in simple scalar column formats. Often it’s stored in formats akin to JSON, where deep structures of arrays and mapped properties are nested within each other. This functionality is a great advance in data management and luckily a modern data platform…

Two Answers to Consider —

Group By should be done by cardinality Example: Consider a table containing the number of people in each US state. SELECT state, people FROM some_table GROUP BY people, state Since there are more people in the US than number of states, we reference people before state in the group by…

Relational databases have been the foundation of some of the world’s most critical applications for the last fifty years. While there are other databases available, such as Key Value, Document, and Graph databases, relational databases remain the most popular. …

Are You Tired of Writing SQL? SQL has been the lingua franca for data manipulation for over 40 years now. Today SQL is an institution, one that very few people can imagine could replace. There is no denying though that its limitations are starting to show. Every experienced data engineer has reached a point of desperation…

SQL Server stored procedures are used to group Transact-SQL statements into logical units that can be reused. When working on the SQL Server Database, the stored procedure is stored as a named object. Benefits of Stored Procedures There are lots of benefits to using stored procedures in your programs. Between them are: Stored procedures…