In-DB Querying: A Brief Guide

Sep 25, 2020 | Article

Have you ever had trouble working with large datasets? Are you frustrated having to move large datasets from a data warehouse to the workstation that has your analytical tools? Are you still using slow ODBC/JDBC connectors? You need to consider using modern data analytics tools with in-database query capabilities.

What is In-DB querying?

Analytical tools with In-Database querying ability enable users to run queries or perform data transformations directly within the data warehouse, effectively using its parallel compute infrastructure.

data warehouse, alteryx, in-db, analytics

How does it benefit you?

  • Fully utilize the compute power of the modern data warehouses, i.e., faster workflows
  • Avoid data transfers and associated time/costs
  • Access other corporate datasets for your analytics workflows, e.g., sales may want to access marketing and customer service datasets

Best Practices (Alteryx specific)

If you are planning to use Alteryx IN-DB features for your analytics workflows, here are some best practices:

  • Filter your data in the “Connect In-DB” tool or as early as possible in the workflow
  • Try avoiding “select * from” a table or bringing the entire table
  • Limit the use of In-DB Browse or Data Stream Out tools
  • Use the cache feature to speed up development but remember to turn it off

Share This Post

You May Also Like:

SQL Cheatsheet for Business Users

Whether you’re a business user newly learning SQL or a Data Analyst who is already a pro, it never hurts to keep a handy reference guide for a quick peek the next time you’re writing an SQL query!

Read More »

Customer Support Dashboard

Built a support dashboard to visualize customer support metrics for the client’s end customers, enabling them to understand better the value of excellent support offered.

Read More »

Find out how We can help with your Analytics needs