Generic Service Account Authentication
This feature enables you to authenticate with supported database technologies using service accounts and the OAuth client credential flow. By implementing token-based authentication, you can securely access data sources without requiring individual user credentials, improving security and simplifying access management.
Supported Technologies
The following ODBC data sources support Generic OAuth authentication:
Amazon Redshift
Amazon Redshift Spectrum
Apache Spark
Azure Synapse Analytics (Azure SQL Data Warehouse)
Databricks
Databricks Unity Catalog
Denodo
Exasol
Google BigQuery
Microsoft Analytics Platform System
Microsoft Azure SQL Database
MS SQL Server
NetSuite
SAP HANA
Snowflake
Setting Up a Connection
To set up the connection for input, output, bulk, and In-DB tools:
Open Alteryx Designer and drop the tool onto the canvas.
Select Add Connection and choose Generic OAuth as the authentication method.
Enter the required service account credentials:
Grant Type: Client credentials.
Token Endpoint: URL of the OAuth token provider.
Scope: Defines the level of access for the authentication.
Client ID: Unique identifier for the OAuth application.
Client Secret: Secret key associated with the OAuth client.
Select Save Connection.
Optionally, you can test the connection to verify authentication.
Once connected, you can read and write data securely using the service account authentication method.