Data sources: query remote data sources
Overview
Zenskar's data-source connectors are convenient tools for transporting data from your data infrastructure to Zenskar's data infrastructure. However, transporting large amounts of data is costly. Querying your data sources remotely simplifies workflows.
Prerequisites
- You must set up a database user with read permissions.
- You must allow Zenskar appropriate network access.
🐕🦺 Set up guide
- Follow the instructions provided in the related documentation to set up a data-source connector that supports remote queries. Zenskar can query remotely the following data sources:
Supported data sources |
---|
Amazon Athena |
Databricks |
MySQL |
PostgreSQL |
RedShift |
- In the Source Access section of the Add New Data Source page, select Directly from Source:
Note
If you would like Zenskar to ingest your existing data and sync periodically, select the Sync to Zenskar option in the Source Access section of the Add New Data Source page.
👍 Pros and 👎 cons
👍 Pros | 👎 Cons |
---|---|
Data is always fresh because there is only one source of data and no sync latency. | Zenskar will depend on your data infrastructure to perform various actions, such as invoice generation and modifying journal entries. Therefore, a downtime in your data infrastructure will disrupt Zenskar's workflow. |
Ideal for large databases that contain more than 30 GB. | |
Since there is only one source of truth for data, the audit trail is simplified. | |
Real-time invoicing is possible. | |
Existing SQL queries will work without any modifications. |
Updated 3 days ago