Connection Management
Overview
This document provides a guide for effectively managing databases in QueryPie. It covers how to synchronize databases from a cloud provider using the Cloud Sync feature and how to manually register databases.
Access to Connection Management Guide
Supported Features
Access Control and Logging: Control database access permissions for users or groups and review audit logs of executed queries and other activities.
Privileges Control: Control commands for each SQL syntax and manage permissions for database tasks such as data export, import, and clipboard copying.
Data Policies: Control table/column visibility, apply data masking, and set sensitive information notification policies for each data source to ensure minimal data access.
Proxy Access: Support proxy access for external clients to the database via both Agent and Agentless methods.
DML Snapshot: Record before-and-after data changes in audit logs when executing INSERT, UPDATE, or DELETE queries.
Ledger Workflow: Manage important tables as ledgers and enforce approval processes, including query reasons, when executing DML queries.
Supported Features by Data Source
● Supported △ In Testing - Not Supported
Data | Access Control / Logging | Privileges Control (SQL) | Data Policies | Proxy Access | DML Snapshot | Ledger Workflow |
MySQL | ● | ● | ● | ● | ● | ● |
MongoDB | ● | ● | ● | ● | ● | ● |
Oracle | ● | ● | ● | ● | ● | ● |
MariaDB | ● | ● | ● | ● | ● | ● |
Athena | ● | ● | ● | ● | - | ● |
PostgreSQL | ● | ● | ● | ● | ● | - |
SQLServer | ● | ● | ● | ● | ● | - |
DocumentDB | ● | ● | ● | ● | ● | - |
Impala | ● | ● | ● | ● | ● | - |
Single Store | ● | ● | ● | ● | ● | - |
SAP Hana | ● | ● | ● | ● | ● | - |
Trino | ● | ● | ● | ● | - | - |
Redshift | ● | ● | ● | ● | - | - |
Redis | ● | ● | ● | ● | - | - |
ScyllaDB | ● | ● | ● | - | ● | - |
Cassandra | ● | ● | ● | - | ● | - |
DynamoDB | ● | ● | ● | - | ● | - |
MS SQL Azure | ● | ● | ● | - | - | - |
Hive | ● | ● | ● | - | - | - |
BigQuery | ● | ● | ● | - | - | - |
Snowflake | ● | ● | - | - | - | - |
Presto | ● | ● | - | - | - | - |
Tibero | ● | ● | - | - | - | - |
Vertica | ● | ● | - | - | - | - |
OpenSearch | ● | - | - | - | - | - |
Google Spanner | ● | - | - | - | - | - |
Dr.Sum | ● | - | - | - | - | - |