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.
You can set up QueryGrid to use Kerberos authentication with a Spark SQL target connector. It uses two forms of authentication with Kerberos:
- 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.
- Select Kerberos for the Authentication Mechanism property.
- Verify that the Teradata QueryGrid user has permission to run kinit. See Verifying Permission to Run kinit.