Environment Verification (Smart Connector)¶
Table of Contents
Introduction¶
Smart Connector verification is backend-specific. Run the command from the relevant section below.
Important
Verification should be performed on all Oracle Database servers where Gluent Data Platform is installed.
Cloudera Data Hub¶
Verification of Smart Connector from an Oracle Database server can be performed as shown below:
$ . $OFFLOAD_HOME/conf/offload.env
$ $OFFLOAD_HOME/bin/smart_connector -iq "show databases"
The result should be a list of Impala databases.
Google BigQuery¶
Verification of Smart Connector from an Oracle Database server can be performed as shown below:
$ . $OFFLOAD_HOME/conf/offload.env
$ $OFFLOAD_HOME/bin/smart_connector -iq "SELECT SESSION_USER()"
The result should be the email address of the service account.