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.
Azure Synapse Analytics¶
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 SYSTEM_USER"
The result is dependent on the authentication mechanism used by the Azure Synapse Analytics User.
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.