Data Sources
Table of contents
Overview
We support the data sources listed below. If you are connecting to a database, we suggest you create a user profile specifically for Matik that only gives read access to the tables needed to create the dynamic content. If you need a data source that we currently don’t support, please let us know by emailing us.
You have the ability to force the end user to log into the data source with their credentials before being able to generate a presentation by clicking on the Require end user to log in to access this data source. They will only be able to generate the presentation if they have access to that data with their credentials.
Data Warehouses
Presto
Redshift
Athena
Google BigQuery
PostGres
MySQL
Snowflake
Databricks
Spreadsheets
Google Sheets
BI Tools
Looker
Tableau
Other APIs
Salesforce
Rest API
Best Practices
Having reliable data sources with strong data governance will improve the End User and Admin experiences. Below are the best practices for the types of data sources you might encounter:
- Data Warehouse: create a Matik user profile instead of connecting to an existing user to prevent having to re-enter credentials if user changes occur and to limit table ACLs to Matik specific content.
- Spreadsheet: ensure READ access of the spreadsheet is granted to Admins