StackQL queries can be run against a number of different cloud providers, including Google Cloud Platform, Amazon Web Services, Microsoft Azure, Digital Ocean, and more. StackQL provider specifications are pulled from the StackQL Provider Registry, this can be done using the
REGISTRY PULL StackQL command, or by using the
stackql registry command line utility.
Installing a Provider
To see the list of available providers, run the following command:
To install a provider, run the following command:
REGISTRY PULL okta;
To see providers installed on the current system, run the following command:
Authenticating to a Provider
Authenticating to a cloud provider is often the first step in an StackQL routine. Meta commands such as
DESCRIBE can be run against a provider without authenticating, but
EXEC commands generally require an authenticated session.
Authentication is performed using environment variables set on the system (or sourced as secrets in a CI system), each provider will have it's own default unique variables used for authentication, so consult the documentation for your provider using the StackQL Provider Registry documentation.
You can authenticate to multiple providers in the same interactive shell or non-interactive batch routine by supplying multiple authentication objects, for example:
This is especially useful when you are joining data between multiple providers in a single query.