Data Transforms For Faster Optimized Querying

Holistics Data Transforms helps you to turn long running report queries into practically instant reports, by materializing a query result as a data table in your database.

Sometimes, even well built queries can take many minutes if not hours to run, depending on the results that you want to retrieve. With data transforms, you can avoid long query waiting times, and even schedule the transformation jobs to run ahead of time, so your fresh results are ready whenever you need.

What Should You Use This For?

Instantaneous reporting experience, with no long query waiting times. Data Transforms turns long running data queries into data tables inside your database, that can be queried instantly. Holistics can schedule Data Transform jobs to run ahead of time, so that reports and queries pointing to the materialized data table will have the most current information needed for analysis.

Optimize reporting performance for your data users, by reducing the complexity and run time of their SQL queries to straightforward select statements on the transformed tables.

Save time spent on data engineering tasks. The majority of time spent working with data is on data cleaning and preparation tasks. Let Holistics Data Transforms help automate this process for you, and empower your data users to perform data engineering tasks as well!

How It Works

Create a new Data Transform job: Ensure your database allows write access for a given data source; setting up separate schema that allows write access is recommended. Create a data transformation job, and specify the destination table settings and job schedule. Insert the long running query that you would like to materialize as a data table into the text box, and validate the query.

Data Transform job specifications

Set the column data types, and validate the destination table structure: If there is no query error, you can then preview the columns of your destination data table. The column definitions are automatically generated from the result of the query, and the data type of each column can be modified as you see fit. Once the table structure has been validated, you can save the Data Transform job.

Data Transform table validation

Experience lightning fast data reporting: Your Data Transform job is ready to go! You can wait for the job to run at the scheduled time, or alternatively, the transformation job can be executed manually by clicking on its ‘Execute’ link in the Transform List. You can refer to the Job History tab and refresh the page to check the status of the transformation job, the job log will provide you with detailed information on the individual steps and time taken. In the event that the Data Transform job fails, you will be notified immediately. Once the job has completed successfully, you can click on the link to the desination table under the ‘Destination’ column, to view your new database table.

Data Transform job log details

Simplify ETL, automate and optimize your data table preparations now!

Sign up for a free trial to add automated data preparation to your work capabilities now! Holistics Data Transforms is another example of how the Holistics Data Platform enables your team to easily and efficiently work with data, for fast-growing tech-driven companies.