Analytics

Strategies for optimizing your BigQuery queries.

Did you know that optimizing SQL queries can be cost efficient? In this episode of BigQuery Spotlight, we speak to some strategies for optimizing your BigQuery queries. We’ll walk through what happens behind the scenes for more complex queries, and show you specific tactics you can use to optimize your SQL. Watch to learn some great techniques on how to make your queries more performant!

BigQuery Admin reference guide: Query optimization

Last week in the BigQuery reference guide, we walked through query execution and how to leverage the query plan. This week, we’re going a bit deeper - covering more advanced queries and tactical optimization techniques. Here, we’ll walk through some query concepts and describe techniques for optimizing related SQL.

All That Hype: Iguazio Listed in 5 Gartner Hype Cycles for 2021

We are proud to announce that Iguazio has been named a sample vendor in five 2021 Gartner Hype Cycles, including the Hype Cycle for Data Science and Machine Learning, the Hype Cycle for Artificial intelligence, Analytics and Business Intelligence, Infrastructure Strategies and Hybrid Infrastructure Services, alongside industry leaders such as Google, IBM and Microsoft (who are also close partners of ours).

Run your jobs faster with Keboola's new feature: Dynamic Backend

Data transformations are the backbone of smooth-running data operations. Transformations are used in data replication between databases, data migration from cloud to on-premise, and data cleaning (aggregations, outlier removal, deduplication …) aka all the good stuff that goes into extracting insights from data. But as any data professional can attest, transformation can also be a painful bottleneck. Think scripts that run for an entire day and finish just before the next scheduled job.

Choosing Your Upgrade or Migration Path to Cloudera Data Platform

In our previous blog, we talked about the four paths to Cloudera Data Platform. If you haven’t read that yet, we invite you to take a moment and run through the scenarios in that blog. The four strategies will be relevant throughout the rest of this discussion. Today, we’ll discuss an example of how you might make this decision for a cluster using a “round of elimination” process based on our decision workflow.

ThoughtSpot for ServiceNow Analytics

With ThoughtSpot, you can deliver a modern, familiar search-driven analytics experience on all your ServiceNow data. Drill anywhere, and get granular insights instantly. ThoughtSpot for ServiceNow Analytics is compatible with the Snowflake Data Cloud and other cloud data warehouse platforms. It leverages the standard ServiceNow data model while remaining highly flexible and customizable. Stop living in canned reports.