Alation

SEPTEMBER 7, 2021

Now that you have empowered data scientists and analysts to access the Snowflake Data Cloud and speed their modeling and analysis, you need to bolster the effectiveness of your governance models. Governance influences how an organization’s objectives are set and achieved, how risk is monitored and addressed, and how performance is optimized.

Data Governance 59

Data Governance Risk Data Quality Dashboards 59

CIO Business Intelligence

JUNE 23, 2022

Warehouses are vertically integrated for SQL Analytics, whereas Lakes prioritize flexibility of analytic methods beyond SQL. The first generation of the Hive Metastore attempted to address the performance considerations to run SQL efficiently on a data lake. But with vastly different architectural worldviews.

Data Lake 98

Data Lake Data Warehouse Machine Learning Cost-Benefit 98

CIO Business Intelligence

APRIL 25, 2022

The data lakehouse is a relatively new data architecture concept, first championed by Cloudera, which offers both storage and analytics capabilities as part of the same solution, in contrast to the concepts for data lake and data warehouse which, respectively, store data in native format, and structured data, often in SQL format.

Recreation/Entertainment 119

Recreation/Entertainment Data Lake Data Warehouse Unstructured Data 119

Cloudera

JUNE 18, 2022

Warehouses are vertically integrated for SQL Analytics, whereas Lakes prioritize flexibility of analytic methods beyond SQL. The first generation of the Hive Metastore attempted to address the performance considerations to run SQL efficiently on a data lake. But with vastly different architectural worldviews.

Data Lake 89

Data Lake Data Warehouse Machine Learning Cost-Benefit 89

Sisense

DECEMBER 16, 2020

For every query, Sisense translates live widget information into SQL data. This quarter, we released a new translator service to reduce the time and cost for these queries on your Snowflake live connection, with other live connections in beta. Reduce data query time by up to 70% and give your live widgets up to a 15% performance boost!

Slice and Dice 98

Slice and Dice Analytics Data-driven Reporting 98

Sisense

APRIL 2, 2020

Tools of the Trade is your destination for data and analytics skill building: From dashboards and reports to embedding analytics and building custom analytic apps to SQL secrets and data deep-dives, whatever you need to know to be better at your job, you can find it here. 4 Ways to Join Only The First Row in SQL.

Data Warehouse 83

Data Warehouse Big Data Testing Software 83

DataRobot Blog

MARCH 17, 2022

With Continuous AI, every production model is optimized for performance, trust, and ethics, even as markets, customers, and standards evolve. DataRobot Scoring Code can also now execute directly inside Snowflake, removing the need to extract and load, resulting in a significantly faster route to scoring your large datasets.

Forecasting 52

Forecasting Machine Learning Data-driven Uncertainty 52

Sisense

JULY 7, 2020

In-Warehouse Data Prep provides builders with the advanced functionality they need to rapidly transform and optimize raw data creating materialized views on cloud data warehouses. In-Warehouse Data Prep supports both AWS Redshift and Snowflake data warehouses.

Slice and Dice 92

Slice and Dice Data Warehouse Analytics Dashboards 92

Cloudera

JUNE 2, 2021

In the most common scenario, data is ingested into object stores in the cloud from myriad sources and then curated (formated, corrected, transformed), optimized (structured for specific needs), and orchestrated (sequenced, managed) in a timely manner to feed the downstream LOB use cases.

Data Warehouse 88

Data Warehouse Machine Learning Data-driven Enterprise 88

DataKitchen

NOVEMBER 4, 2021

The DataKitchen Platform is a “ process hub” that masters and optimizes those processes. DataOps works on top of your existing data, allowing you to use your favorite tools , whether you prefer SQL, Alteryx, Tableau, Looker or whatever else. The DataOps process hub does not replace a data lake or the data hub.

Data Processing 246

Data Processing Data Lake Cost-Benefit Testing 246

Octopai

APRIL 23, 2022

Are you leaving behind Oracle for Azure Data Factory, SQL Server for Snowflake or SSRS for Power BI? The planning: a key stage of data migration planning is getting an accurate picture of your current data environment and data flow – and then optimizing it. You’re planning a data system migration.

Visualization 89

Visualization Metrics Reporting Software 89

AWS Big Data

NOVEMBER 16, 2023

As with all AWS services, Amazon Redshift is a customer-obsessed service that recognizes there isn’t a one-size-fits-all for customers when it comes to data models, which is why Amazon Redshift supports multiple data models such as Star Schemas, Snowflake Schemas and Data Vault. String-optimized compression The Data Vault 2.0

Enterprise 80

Enterprise Data Warehouse Snapshot Cost-Benefit 80

AWS Big Data

OCTOBER 31, 2023

This blog post is co-written with James Sun from Snowflake. Customers rely on data from different sources such as mobile applications, clickstream events from websites, historical data, and more to deduce meaningful patterns to optimize their products, services, and processes. A Snowflake account with admin credentials.

Data Processing 86

Data Processing Management Publishing Testing 86

Cloudera

JUNE 1, 2021

Everyone from Snowflake and DataBricks to Google and Microsoft claim to have one, but the truth is that we are leading the way in the hybrid data cloud space. We must integrate and optimize the end-to-end data lifecycle for our customers, empowering them to focus on what really matters – extracting value from their data.

Uncertainty 144

Uncertainty Cost-Benefit Risk Strategy 144

AWS Big Data

OCTOBER 17, 2023

With Amazon Redshift, you can use standard SQL to query data across your data warehouse, operational data stores, and data lake. AWS Schema Conversion Tool (AWS SCT) could help you with initial bulk load from Azure Synapse Analytics, BigQuery, Greenplum Database, IBM Netezza, Microsoft SQL Server, Oracle, Snowflake, Teradata and Vertica.

Data Warehouse 82

Data Warehouse Data Processing Data Lake Management 82

Sisense

MAY 27, 2019

Engineers seek to dig out the data from all the sources available to your organization, then integrate, manage, and optimize it. They also use data pipelines and workflow management tools such as Azkaban, Luigi, and Airflow and with relational SQL and NoSQL databases like Postgres and Cassandra.

Statistics 75

Statistics Machine Learning Visualization Big Data 75

Insight

MAY 20, 2020

If you are using Python (again, stick with Python unless you know Scala or Java or absolutely need APIs that are not available with Python), you’ll want to learn about Spark’s DataFrame API, which can be used interchangeably with Spark SQL calls. Those optimizations are a big reason why you’d want to use this newer API.

Data Warehouse 106

Data Warehouse Optimization Interactive Cost-Benefit 106

CDW Research Hub

JANUARY 24, 2022

Snowflake is the data cloud that boasts instant elasticity, secure data sharing, and per-second pricing across multiple clouds. Its ability to natively load and use SQL to query semi-structured and structured data within a single system simplifies your data engineering. These tasks include: Navigating to the table view.

Structured Data 87

Structured Data Consulting Strategy Data Strategy 87

Cloudera

JUNE 9, 2022

Companies use CDF-PC for diverse data distribution use cases ranging from cybersecurity analytics and SIEM optimization via streaming data collection from hundreds of thousands of edge devices, to self-service analytics workspace provisioning and hydrating data into lakehouses (e.g: Release : Supports the latest Apache NiFi Release 1.16

Data Collection 88

Data Collection IoT Data Lake Unstructured Data 88

DataKitchen

APRIL 13, 2021

DataOps.Live — DataOps for Snowflake. Observe, optimize, and scale enterprise data pipelines. . Redgate — SQL tools to help users implement DataOps, monitor database performance, and provision of new databases. . DataOps.Live — DataOps for Snowflake: 100% of your DataOps needs in one end-to-end platform. Data breaks.

Testing 307

Testing Machine Learning Consulting Data Quality 307

CIO Business Intelligence

AUGUST 18, 2022

To that, the lakehouse adds layers of optimization to make the data more broadly consumable for gathering insights. Moonfare selected Dremio in a proof-of-concept runoff with AWS Athena, an interactive query service that enables SQL queries on S3 data. The new query acceleration platforms aren’t standing still.

Data Lake 140

Data Lake Data Warehouse Unstructured Data Business Intelligence 140

Cloudera

NOVEMBER 13, 2020

Impala Optimizations for Small Queries. We’ll discuss the various phases Impala takes a query through and how small query optimizations are incorporated into the design of each phase. For a more in-depth description of these phases please refer to Impala: A Modern, Open-Source SQL Engine for Hadoop. Query Planner Design.

Optimization 142

Optimization Metadata Statistics Cost-Benefit 142

Data Virtualization

MAY 5, 2020

Bring any data to any data consumer, simply and easily: that’s the goal of data virtualization. Yet contrary to what may first come to mind, data consumers are more than simply BI, analytics, or data science applications. Just about every.

Data Science 52

Data Science Analytics OLAP Optimization 52

Sisense

DECEMBER 3, 2019

Optimize raw data using materialized views. In-Warehouse Data Prep delivers builders advanced functionality to rapidly transform and optimize raw data using materialized views on cloud data warehouses. Data teams can look forward to more innovative tools that will enable them to drive value from raw data in their cloud data warehouses.

Data Warehouse 90

Data Warehouse Analytics Digital Transformation Forecasting 90

Alation

APRIL 4, 2023

Compose , Alation’s intelligent SQL editor, enables users to browse data sources as they query, with real-time warnings for untrusted or ungoverned data; Compose lowers the barrier to entry for nontechnical users with features like autocomplete, which generates suggestions as users write queries.

Metadata 52

Metadata Cost-Benefit Data Transformation Predictive Modeling 52

Alation

JANUARY 25, 2022

Just like Gartner, we’re confident building out this capability will optimize productivity, business optimization, and user experience. These are practical examples of the active use of metadata to optimize the data fabric and reduce the volume of mundane repetitive tasks. Valuable metadata is the invisible architecture.

Metadata 52

Metadata IT Metrics Data-driven 52

AWS Big Data

JULY 25, 2023

You can load your data and start querying in your favorite business intelligence (BI) tools, build machine learning (ML) models in SQL, or combine your data with third-party data for new insights because Redshift Serverless seamlessly integrates with your data landscape.

Data Analytics 52

Data Analytics Data Warehouse Analytics Data Processing 52

IBM Big Data Hub

JANUARY 18, 2023

A read-optimized platform that can integrate data from multiple applications emerged. It can include technologies that range from Oracle, Teradata and Apache Hadoop to Snowflake on Azure, RedShift on AWS or MS SQL in the on-premises data center, to name just a few. It was Datawarehouse.

Data Lake 52

Data Lake Data Warehouse Data-driven Metadata 52

Sisense

FEBRUARY 24, 2021

Sophisticated technical talent who are querying data and building models with languages like SQL, R, and Python need a solution that will empower them to dive deep. Platforms like Sisense enable these teams to quickly explore data through code, visualize the results, or convert them to models written back to AWS Redshift or Snowflake.

Data Warehouse 69

Data Warehouse Big Data Metrics Visualization 69

Cloudera

DECEMBER 12, 2018

Greg Rahn: I first got introduced to SQL relational database systems while I was in undergrad. So, that’s kind of how I got introduced to databases and SQL systems. So, I think the prominent engines at the time for data processing on top of data residing in HDFS was Hive, and Hive was basically a SQL to MapReduce program.

Data Warehouse 41

Data Warehouse Marketing Big Data Data Lake 41

Sisense

JUNE 26, 2019

For an enterprise company , that can mean building and maintaining data pipelines or optimizing database queries and anything in between. The aged statistic still stands that 80% of your time will be spent preparing and optimizing data. The combinations are endless, That’s what’s so great about SQL.

Enterprise 75

Enterprise Data Warehouse Dashboards Modeling 75

Alation

JUNE 1, 2023

So it’s fitting that Snowflake Summit , the premier event for data cloud strategy, will occur at Caesars Forum in Las Vegas on June 26–29 (togas not required). As a 2-time Snowflake Data Governance Partner of the Year , Alation knows how important this event is to the Snowflake community. Key to guiding that mission is metadata.

Metadata 52

Metadata Data Governance Data-driven Recreation/Entertainment 52

Octopai

SEPTEMBER 27, 2023

Octopai’s real-time capabilities provide a transparent, up-to-the-moment view of data integrations across platforms like Airflow, Azure Data Factory, Snowflake, Redshift, and Azure Synapse. In the world of data science and computing, Databricks stands out because it can handle languages like Scala, Python, and SQL very well.

Metadata 52

Metadata Visualization Data Integration Data-driven 52

Cloudera

APRIL 1, 2024

With the integration of Apache Iceberg table format, we allow any compute engine to access data from Cloudera’s data lakehouse including engines outside of our platform like Snowflake, Google Big Query, AWS Redshift, and more. We have embedded LLMs in our Hue interface so you can write SQL queries in English or any other language.

Unstructured Data 100

Unstructured Data Cost-Benefit Metadata Machine Learning 100

Jet Global

AUGUST 24, 2023

Optimized Resource Allocation: Finance teams can strategically allocate resources in a hybrid ERP environment. This optimization leads to improved efficiency, reduced operational costs, and better resource utilization. Cost Optimization: The hybrid model allows finance teams to balance their expenses effectively.

Finance 52

Finance Reporting Data Integration Risk 52

Jet Global

NOVEMBER 7, 2023

It is considered the optimal approach for deeper analytical insights, as it minimizes strain on the transactional database and improves overall performance. A simple drag-and-drop interface automates SQL code for you, eliminating the need for cumbersome IT projects to cleanse, transform and structure data.

Enterprise 52

Enterprise Data Warehouse Operational Reporting Reporting 52

Jet Global

SEPTEMBER 19, 2023

Angles is also built for today’s cloud-first IT, with support for hybrid deployments that offload processing from the primary database to a Microsoft Azure or Snowflake data warehouse. Leverage the power of Snowflake or SQL Server RDS to build a cloud data warehouse from Oracle ERP data.

Cost-Benefit 52

Cost-Benefit Data Warehouse Reporting Enterprise 52