Experimental News Clipping Site

Tag: query execution

  • Cloud Blog: BigQuery under the hood: The power of the Column Metadata index aka CMETA

    —

    by

    Kurt Seifried
    in

    Source URL: https://cloud.google.com/blog/products/data-analytics/understanding-the-bigquery–column-metadata-cmeta-index/ Source: Cloud Blog Title: BigQuery under the hood: The power of the Column Metadata index aka CMETA Feedly Summary: While petabyte-scale data warehouses are becoming more common, getting the performance you need without escalating costs and effort remain key challenges, even in a modern cloud data warehouse. While many data warehouse platform…

  • AWS News Blog: New: Improve Apache Iceberg query performance in Amazon S3 with sort and z-order compaction

    —

    by

    Kurt Seifried
    in

    Source URL: https://aws.amazon.com/blogs/aws/new-improve-apache-iceberg-query-performance-in-amazon-s3-with-sort-and-z-order-compaction/ Source: AWS News Blog Title: New: Improve Apache Iceberg query performance in Amazon S3 with sort and z-order compaction Feedly Summary: Amazon S3 now enables improved Apache Iceberg query performance through two new compaction strategies—sort and z-order—available for both S3 Tables and general purpose S3 buckets, helping organize data more efficiently by…

  • Cloud Blog: From analytics to data management: New BigQuery transactional features

    —

    by

    Kurt Seifried
    in

    Source URL: https://cloud.google.com/blog/products/data-analytics/bigquery-features-for-transactional-data-management/ Source: Cloud Blog Title: From analytics to data management: New BigQuery transactional features Feedly Summary: For years, BigQuery has been synonymous with fully managed, fast, petabyte-scale analytics. Its columnar architecture and decoupled storage and compute have made it the go-to data warehouse for deriving insights from massive datasets.  But what about the…

  • Cloud Blog: Understand why your metrics moved with contribution analysis in BigQuery ML, now GA

    —

    by

    Kurt Seifried
    in

    Source URL: https://cloud.google.com/blog/products/data-analytics/bigquery-ml-contribution-analysis-models-now-ga/ Source: Cloud Blog Title: Understand why your metrics moved with contribution analysis in BigQuery ML, now GA Feedly Summary: The key to effective data-driven decision making is quickly processing and extracting insights from large amounts of data. However, doing this efficiently and at scale is a challenge.  Imagine a retail scenario where…

  • Cloud Blog: New column-granularity indexing in BigQuery offers a leap in query performance

    —

    by

    Kurt Seifried
    in

    Source URL: https://cloud.google.com/blog/products/data-analytics/search-indexes-with-column-granularity-in-bigquery/ Source: Cloud Blog Title: New column-granularity indexing in BigQuery offers a leap in query performance Feedly Summary: BigQuery delivers optimized search/lookup query performance by efficiently pruning irrelevant files. However, in some cases, additional column information is required for search indexes to further optimize query performance. To help, we recently announced indexing with…