Skip to content
DataSquaresDocs
datasquares.aiSign inStart free

Connect DataDatabases

Apache Drill

You connect Apache Drill from the DataSquares connection wizard. Schema-free SQL over files/Hadoop/NoSQL — REST /query.json; INFORMATION_SCHEMA discovery.

  1. In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.

  2. Pick Apache Drill on that page (search or browse by category).

  3. Fill in the connection details below, then test the connection and save.

Connection details

Section titled “Connection details”
Field What to enter
Host The hostname or IP address of your Apache Drill server.
Port Prefilled with 8047 (the Apache Drill default) — change it if your server listens elsewhere.
Username / Password Optional — only if your Apache Drill server requires authentication.
TLS On by default: Use SSL/TLS encryption connects encrypted and verifies the server certificate. Tick Trust self-signed certificate for a private CA; turn TLS off only for a server that has none.

Grant the connection user read-only access — DataSquares only ever reads from your source.

Section titled “Related”