Spark SQL
Spark SQL
Follow these steps to connect Spark SQL to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Spark SQL into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the host name or IP address of the Server hosting the Spark SQL database.
-
In the User field, enter the Spark SQL username for authentication.
-
Enterthe user password in the Password field.
-
Enterthe port for connecting to the Spark SQL server in the Port.
10000
is the default value. -
Enter the name of the SparkSQL Database.
-
In Spark SQL, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Spark SQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and Spark SQL, see this information page.