This article provides an overview of the Materialized views setting that enables integrating data into external tools such as Tableau.
Each time a query is run, whether within Slate or via direct SQL access, significant processing power is required in order to execute the query. The more records and the more database tables are involved, the more time and computational resources this takes. Depending on the type and complexity of the query, this may also result in performance implications felt throughout the database.
Materialized views in Slate are an effective way to make Slate data available to external tools like Tableau over a direct SQL connection, without impacting system-wide performance during normal operational hours.
Last Updated on