article thumbnail

Capital One Offers Cost Controls for Cloud Data Warehouses

David Menninger's Analyst Perspectives

Capital One began its transition to a cloud-first company in 2016 and completed its migration away from on-premises data centers to the cloud in 2020. Along the way, it adopted Snowflake’s AI Data Cloud and became an investor in the company in 2017.

article thumbnail

The 2016 Crystal Ball – What’s Next in Data?

Alation

Considering what we’ve seen this year in industry trends and patterns, we have compiled some predictions for 2016 from our co-founders at Alation. Venky Ganti, CTO & Co-Founder: Data sprawl will finally hit its threshold. Data sprawl has been prevalent for several years. 2016 will be the year of the “logical data warehouse.”

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

A Few 2016 Technology Predictions

In(tegrate) the Clouds

I enjoy the end of the year technology predictions, even though it’s hard to argue with this tweet from Merv Adrian: By 2016, 99% of readers will be utterly sick of predictions. 2016 will be the year of the data lake. In 2016, which software company will be the biggest game-changer for the long term?

article thumbnail

8 Ways to Fine-tune your SQL Queries (for production databases)

Sisense

In organizations that operate without a data warehouse or separate analytical database for reporting, the only source of the latest and up-to-date data may be in the live production database. For example, let’s assume 200 sales have been made in the year 2016, and we want to query for the number of sales per customer in 2016.

Sales 111
article thumbnail

Build and manage your modern data stack using dbt and AWS Glue through dbt-glue, the new “trusted” dbt adapter

AWS Big Data

dbt is an open source, SQL-first templating engine that allows you to write repeatable and extensible data transforms in Python and SQL. dbt is predominantly used by data warehouses (such as Amazon Redshift ) customers who are looking to keep their data transform logic separate from storage and engine.

Data Lake 122
article thumbnail

The Increasing Importance of Open Table Formats

David Menninger's Analyst Perspectives

It was not until the addition of open table formats— specifically Apache Hudi, Apache Iceberg and Delta Lake—that data lakes truly became capable of supporting multiple business intelligence (BI) projects as well as data science and even operational applications and, in doing so, began to evolve into data lakehouses.

Data Lake 130
article thumbnail

When Data Warehousing Met the Events Industry

BizAcuity

billion US dollars in 2016, up from 29.3 The solution here is to consolidate all of this data, gathered from different points at different times along the course of the event and store it in one consolidated form in a Data Warehouse. One of the many things that data warehouses allow is the chronological sifting of data.