Skip to main content

Can Datasets be Merged in Auto Insights?

Yes, it is possible to merge, join, and combine datasets in Auto Insights. However, the option is only available to users who are connecting or have connected Auto Insights directly to a database.

Auto Insights' database connection functionality allows you to use SQL query statements to merge, join, or combine datasets to be ingested into Auto Insights, or include logic currently used in your reporting.

Using SQL query statements lets you control and specify the joining criteria (for example, INNER JOIN, FULL JOIN, LEFT JOIN, or RIGHT JOIN).

Dataset Merging Best Practices

If your query statement is particularly complicated or greater than 64,000 characters, it may be more practical for you to capture the logic in your database via a new table or view. You can then connect Auto Insights directly to this table.