Optimize your data warehouse using your existing queries

Running a data team without an architect? We will help you optimize your data models for free.

Simply upload a CSV file of your query history to:

Save money by finding unused tables and columns

Surface high value business insights by identifying critical data sets

Improve your data model by understanding workload patterns and how the data flows across your system

Save money by finding unused tables and columns

Surface high value business insights by identifying critical data sets

Improve your data model by understanding workload patterns and how the data flows across your system

"Dan was great at architecting our data systems that delivered key business value while dealing with real world constraints, such as cost."

- Jaison Zachariah, SVP Engineering @ TripleLift

Screenshot of Twing Data highlighting unused tables and columns that can be removed

Find unused tables and columns

Your data warehouse started simple but has grown complex. Twing Data helps you clean it up.

Discover hidden data patterns

You've been democratizing data access but not all queries are the same. Twing Data identifies the top patterns so you can focus your time on the things that matter.

Screenshot of Twing Data showing off tables and queries that are similar to others

Screenshot of how Twing Data visualizes your query patterns and gives you a quick hovercard highlighting the key details

Improve your data model

You've been optimizing your queries but have you optimized your data model? The biggest impact comes from adapting your data model to support your queries.

Upload a CSV export of your query history to run an automated analysis of your database.
Once you upload your file, we will analyze your queries and send you an email with a link for you to access the results.

The file should have the following columns with headers: query or query_text, start or start_time, and end or end_time. If you're using Snowflake you can find this data in the snowflake.account_usage.query_history table.

Sample CSV file format

query_text	database_name	schema_name	execution_status	start_time	end_time
select id, name from a	DATABASE_A	SCHEMA_PROD	SUCCESS	2021-01-01 00:00:00 +00.00	2021-01-01 00:00:01 +00.00
select name, sum(vals) from a group by 1	DATABASE_A	SCHEMA_PROD	SUCCESS	2021-01-02 00:00:00 +00.00	2021-01-02 00:00:01 +00.00
select sum(revenue) from b	DATABASE_B	SCHEMA_SALES	SUCCESS	2021-01-03 00:00:00 +00.00	2021-01-03 00:00:01 +00.00

Upload your query history

Drag & Drop your file here
OR

By uploading a file for analysis, you agree to the Twing Data Terms of Service and Privacy Statement.

The audit is free for a limited time. You can also book time with our founder, Dan, to go over your results and help you optimize your data warehouse.