Insights Direct Connect allows you to plug directly into our Snowflake Data Warehouse via an encrypted ODBC connection so you can directly query your Insights data together with other sources of your choosing.
Most of the popular Business Intelligence (BI) Tools on the market, such as Tableau, Microsoft Power BI, Qlik, and Looker allow you to connect to ODBC data sources like Insights Direct Connect.
- Connect using Insights Direct Connect from PowerBI to Snowflake
- Connect using Insights Direct Connect from Tableau to Snowflake
- Connect using Insights Direct Connect from Qlik to Snowflake
While Insights' ETL process refreshes data from SiQ at a minimum of once a day (hourly for time series data), Insights Direct Connect provides a connection to your data as it currently exists in the data warehouse, including historic records, so you can access your data via live queries and know that you are consistently seeing the latest available extract.
Your IT team might also want to make use of this ODBC connection to power integrations with your internal systems or to populate an internal data lake where you can combine your SiQ data with other data sources.
Note: When using Direct Connect you will need to define your own sets of joins and aggregations.