prometheus.exporter.snowflake
The prometheus.exporter.snowflake
component embeds the snowflake_exporter
for collecting warehouse, database, table, and replication statistics from a Snowflake account via HTTP for Prometheus consumption.
Usage
You can use the prometheus.exporter.snowflake
component with password or RSA authentication.
Password Authentication
prometheus.exporter.snowflake "LABEL" {
account_name = "<SNOWFLAKE_ACCOUNT_NAME>"
username = "<USERNAME>"
password = "<PASSWORD>"
warehouse = "<VIRTUAL_WAREHOUSE>"
}
RSA Authentication
prometheus.exporter.snowflake "LABEL" {
account_name = "<SNOWFLAKE_ACCOUNT_NAME>"
username = "<USERNAME>"
private_key_path = "<RSA_PRIVATE_KEY_PATH>"
private_key_password = "<RSA_PRIVATE_KEY_PASSWORD>"
warehouse = "<VIRTUAL_WAREHOUSE>"
}
Arguments
You can use the following arguments with prometheus.exporter.snowflake
:
One of password
or private_key_path
must be specified to authenticate.
Users with an encrypted private key will also need to provide a private_key_password
.
Blocks
The prometheus.exporter.snowflake
component doesn’t support any blocks. You can configure this component with arguments.
Exported fields
The following fields are exported and can be referenced by other components.
For example, the targets
can either be passed to a discovery.relabel
component to rewrite the targets’ label sets or to a prometheus.scrape
component that collects the exposed metrics.
The exported targets use the configured in-memory traffic address specified by the run command.
Component health
prometheus.exporter.snowflake
is only reported as unhealthy if given an invalid configuration.
In those cases, exported fields retain their last healthy values.
Debug information
prometheus.exporter.snowflake
doesn’t expose any component-specific debug information.
Debug metrics
prometheus.exporter.snowflake
doesn’t expose any component-specific debug metrics.
Example
The following example uses a prometheus.scrape
component to collect metrics from prometheus.exporter.snowflake
:
prometheus.exporter.snowflake "example" {
account_name = "XXXXXXX-YYYYYYY"
username = "grafana"
password = "snowflake"
warehouse = "examples"
}
// Configure a prometheus.scrape component to collect snowflake metrics.
prometheus.scrape "demo" {
targets = prometheus.exporter.snowflake.example.targets
forward_to = [prometheus.remote_write.demo.receiver]
}
prometheus.remote_write "demo" {
endpoint {
url = "<PROMETHEUS_REMOTE_WRITE_URL>"
basic_auth {
username = "<USERNAME>"
password = "<PASSWORD>"
}
}
}
Replace the following:
<PROMETHEUS_REMOTE_WRITE_URL>
: The URL of the Prometheusremote_write
compatible server to send metrics to.<USERNAME>
: The username to use for authentication to theremote_write
API.<PASSWORD>
: The password to use for authentication to theremote_write
API.
Compatible components
prometheus.exporter.snowflake
has exports that can be consumed by the following components:
- Components that consume Targets
Note
Connecting some components may not be sensible or components may require further configuration to make the connection work correctly. Refer to the linked documentation for more details.