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 / Cloudera Data Platform¶
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.
Snowflake¶
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 CURRENT_USER()"
The result should be the name of the SNOWFLAKE_USER.