Open lenahi opened 7 months ago
Lab Configuration: drill version: 1.21.1
drill postgres storage plugin configuration:
{ "type": "jdbc", "driver": "org.postgresql.Driver", "url": "jdbc:postgresql://<ip>:<port>/data", "credentialsProvider": { "credentialsProviderType": "VaultCredentialsProvider", "secretPath": "drill/test_postgres", "propertyNames": { "username": "usernameSecret", "password": "passwordSecret" } }, "authMode": "SHARED_USER", "writerBatchSize": 10000, "enabled": true }
Test on drill portal: http://:8047/query
show schemas output is something like below:
show schemas
<html> <body> <!--StartFragment--> SCHEMA_NAME -- sys <html> <body> <!--StartFragment--> test_postgres.information_schema test_postgres.public test_postgres.tiger test_postgres.tiger_data test_postgres.topology test_postgres.data test_postgres <!--EndFragment--> </body> </html>
Lab Configuration: drill version: 1.21.1
drill postgres storage plugin configuration:
Test on drill portal: http://:8047/query
show schemas
output is something like below: