Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Clustering in BigQuery

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        Clustering in BigQuery

        We’re excited to announce the introduction of Clustering for BigQuery warehouses in Daton! This functionality is designed to optimize query costs and enhance performance when using BigQuery.

        What is Clustering?

        Clustering in BigQuery arranges rows with similar values closer together, based on one or more specified columns.

        • Benefit: Optimized query performance through data pruning, which scans only the relevant subsets of data based on filter criteria.
        • Target Column: Daton implements clustering on the _daton_batch_runtime column to maximize efficiency.

        How to Enable Clustering?

        New Destination setup

        • During destination creation, you can select TRUE for the enable clustering option.

        Existing Destination

        • Go to Destinations page
        • Click on Edit destination
        • Set the enable clustering drop-down to TRUE

        Note: Tables created or reloaded after this change will automatically be clustered on _daton_batch_runtime

         

        Impact on Queries

        Here's an example to compare the query cost difference before and after clustering

        Before Clustering:

        Here the query to get latest data pulled from Daton had to go through the entire data set costing 1.46 GB to process the data

        After Clustering:

        Once we enabled clustering, the same query is costing 10 MB providing efficiency of more than 99%.

         

        Start optimizing your BigQuery queries with clustering today!

        update notes bigquery updates

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Essential Attributes and Supported Tables for Amazon Sponsored Display
        • Essential Attributes and Supported Tables for Amazon Sponsored Products
        • Essential Attributes and Supported Tables for Amazon DSP

        Table of Contents

        What is Clustering? How to Enable Clustering? New Destination setup Existing Destination Impact on Queries

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand