Choosing the right Data Warehouse SQL Engine: Apache Hive LLAP vs Apache Impala
Some of the most powerful results come from combining complementary superpowers, and the “dynamic duo” of Apache Hive LLAP and Apache Impala, both included in Cloudera Data Warehouse, is further evidence of this. Both Impala and Hive can operate at an unprecedented and massive scale, with many petabytes of data. Both are 100% Open source, so you can avoid vendor lock-in while you use your favorite BI tools, and benefit from community-driven innovation.
ETL Testing: What, Why, and How to Get Started
Companies use their data to accelerate business growth and overtake their competitors. To achieve this, they invest a lot in their ETL (extract-transform-load) operations, which take raw data and transform it into actionable information. It’s no wonder, then, that ETL testing is a crucial part of a well-functioning ETL process, since the ETL process generates mission-critical data.
How Arxus Makes Performance Data More Accessible & Now Hits 85% of Its Goals
Before Databox, Arxus struggled with accessing data & creating clear visuals. Now, they’re able to streamline their data with ease, save time and spot trends 80% faster.
Operational Database Security - Part 2
In this blogpost, we are going to take a look at some of the OpDB related security features of a CDP Private Cloud Base deployment. We are going to talk about auditing, different security levels, security features of Data Catalog, and Client Considerations.
2020 Cloud Data Warehouse Benchmark: Redshift, Snowflake, Presto and BigQuery
The Fivetran data warehousing benchmark compares price, performance and differentiated features for BigQuery, Presto, Redshift and Snowflake.
Introducing Fivetran dbt Transformations
Fivetran introduces our native integration with dbt to run your transformation models hosted in Github directly from our application!
Ziff Davis Analyzes Ad & Website Data
With a modern data stack, Ziff Davis centralizes Google Analytics 360 and ad data to gain insights into paid search performance.
Databases Demystified Lesson 10: Query Planning and Optimization
In this lesson, we talk about what a query planner is and does in the database. We talk about the difference between declarative and imperative programming languages, and we wrap up with a discussion of some common strategies for database optimization to improve query speed.