2.10 - Spark SQL Target Connector Security Guidelines - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

General

When setting parameters for Spark SQL target connectors in NVP link pairings, make sure the setting of the Conf File Paths property has the correct pathname correct value. QueryGrid heavily depends on this setting when processing data transfers. See Spark SQL Connector and Link Properties.

Kerberos

You can set up QueryGrid to use Kerberos authentication with a Spark SQL target connector. It uses two forms of authentication with Kerberos:

Username/Password
The Spark SQL target connector authenticates the username and password against Kerberos before sending the query to the data source.
Kerberos Keytab
Spark SQL can be configured to enable Kerberos Keytab authentication.
If you are using a Spark SQL target connector in an NVP link pairing to access a Kerberized Hadoop cluster:
  • Select Kerberos for the Authentication Mechanism property.
  • Verify that the Teradata QueryGrid user has permission to run kinit. See Verifying Permission to Run kinit.