FireDAC Components for Snowflake

Build 21.0.7958

Using OAuth Authentication

OAuth requires the authenticating user to interact with Snowflake using the browser. The component facilitates this in various ways as described below.

Custom Credentials

If you have an OAuth Integration, using SYSTEM$SHOW_OAUTH_CLIENT_SECRETS function to retrieve the ClientId and ClientSecret, such as "select system$show_oauth_client_secrets('MYINT');"

If not, You need to create an OAuth Integration to obtain the OAuthClientId and OAuthClientSecret

Creating a Custom OAuth Integration

See Creating a Custom OAuth App for the procedure.

Headless Machines

In the headless OAuth flow, users need to authenticate via a browser on another machine. You need to create a custom OAuth app. See Creating a Custom OAuth App for the procedure.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7958