Do you know what Custom transformation is? Here is an easy explanation

What is custom transformation?

Custom transformation in SQL is changing raw data into a more useful form by manipulating the values of the fields in a database table. This transformation is usually done using custom SQL queries or stored procedures. Custom transformation in SQL can be an effective way to prepare data for further analysis.

In simple words, it is a custom query that replaces the default query. A custom query overrides entries for a custom join or a source filter.

This is a unique feature, and DappLooker is the only company that provides it.

Benefits of custom transformation

• Enables faster and optimized queries
• Enables faster chart to reload
• Enables faster dashboard reload

Still confused? Don't worry. Here is an example

E.g., This is a snapshot of SQL query of Cohort analysis of user transaction. The query is complex and long. Because it is lengthy, it takes a lot of time to load