KartikeyaJain
New Contributor III

The official Databricks provider in Terraform only allows you to create SQL queries, not execute them. To actually run queries, you can either:

  1. Use the http provider to make API calls to the Databricks REST API to execute SQL queries.

  2. Alternatively, if you're using a Service Principal with a Client Secret, you can configure another http provider to obtain an access token via OIDC, which can then be used in place of a PAT token for authentication.