Format SQL in Sisense CDT

This is one of those posts that's here for my own benefit more than yours. I can never seem to google up the solution to this one so if I put it here with a title that matches what I was googling, maybe I'll be able to google my own article.

So, how do you automatically format the SQL query for a Sisense Cloud Data Teams chart?

It can only be done via a keyboard shortcut, (and it seems the only place this feature is documented is on the Sisense CDT keyboard shortcuts page)

If you highlight your SQL and press ⌘+Shift+L on a mac (or Ctrl+Shift+L on other keyboards) your code will be formatted!

That's it! You're a wizard!

Before...

After

By Phil Steffek

Phil Steffek is a professional sumo wrestler who is hoping to represent the U.S. in the next Olympics. During the off season Phil is a Data Architect working on transactional databases, data warehouse implementations, and all aspects of business intelligence. Also, Phil is not really a sumo wrestler. You can get to know a bit more about my non-sumo doings by checking out my LinkedIn Page

Leave a comment

Your email address will not be published. Required fields are marked *