Connecting to remote Database
How to connect Atoti DirectQuery to a remote database, covering required permissions and connection methods for BigQuery, ClickHouse, Databricks, SQL Server, Redshift, Snowflake, and Synapse
When using DirectQuery, Atoti delegates various queries to the remote database.
In order to do that it requires a connection to this database and the permissions to access the data and run these queries.
This section describes various methods and best practices to connect to a remote database when using it in DirectQuery.