An ad-hoc query is a single-use query generally used to answer “on-the-fly” business questions for which there are no pre-written queries or standard procedures. Ad-hoc queries usually serve a single-use purpose and are not generally stored as procedures to be run again in the future.
Trifacta Makes it Easier to Run Ad-Hoc Queries
Trifacta empowers organizations to run more ad-hoc queries by greatly reducing the time and technical skills required to build functional data pipelines. Using Trifacta’s visual, intuitive interface, line of business personnel with limited technical expertise can perform self-service data engineering, quickly transform data, and answer on-the-fly business questions - all without having to rely on engineering or IT.