--- title: Get a Snowflake integration account description: Datadog, the leading service for cloud-scale monitoring. breadcrumbs: Docs > API Reference > Snowflake Integration --- > For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt). # Get a Snowflake integration account{% #get-a-snowflake-integration-account %} Copy pageCopied {% tab title="v2" %} **Note**: This endpoint is in preview and is subject to change. If you have any feedback, contact [Datadog support](https://docs.datadoghq.com/help/). | Datadog site | API endpoint | | ----------------- | ----------------------------------------------------------------------------------------------- | | ap1.datadoghq.com | GET https://api.ap1.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | ap2.datadoghq.com | GET https://api.ap2.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | app.datadoghq.eu | GET https://api.datadoghq.eu/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | app.ddog-gov.com | GET https://api.ddog-gov.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | us2.ddog-gov.com | GET https://api.us2.ddog-gov.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | uk1.datadoghq.com | GET https://api.uk1.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | app.datadoghq.com | GET https://api.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | us3.datadoghq.com | GET https://api.us3.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | | us5.datadoghq.com | GET https://api.us5.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts/{account_id} | ### Overview Get a Snowflake integration account. This endpoint requires the `integrations_read` permission. ### Arguments #### Path Parameters | Name | Type | Description | | ---------------------------- | ------ | --------------------------------------------- | | account_id [*required*] | string | Unique identifier of the integration account. | ### Response {% tab title="200" %} OK {% tab title="Model" %} Response payload for a single Snowflake integration account. | Parent field | Field | Type | Description | | ----------------------------------------------- | ----------------------------------------------- | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | | data [*required*] | object | Data envelope of a Snowflake integration account, including server-assigned identity. | | data | attributes [*required*] | object | Attributes of a Snowflake integration account returned in responses. | | attributes | authentication | | Authentication configured on the Snowflake integration account. | | authentication | | object | The RSA key pair authentication method configured on the account. | | | auth_type [*required*] | enum | The authentication method type. Allowed enum values: `snowflake_private_key` | | | private_key_name [*required*] | string | Name that distinguishes this private key from other keys in Datadog. | | attributes | dataflows | object | Data Datadog collects from Snowflake, keyed by dataflow id. | | dataflows | snowflake-account-usage-metrics | object | Account-level usage metrics read from the Snowflake `ACCOUNT_USAGE` schema, covering storage usage, credit consumption, and query activity. | | snowflake-account-usage-metrics | enabled | boolean | Whether Datadog collects this data. | | snowflake-account-usage-metrics | settings | object | Settings of the account usage metrics dataflow. | | settings | account_usage_metrics_aggregate_last_24h | boolean | The period each metric aggregates over. When `true`, metrics aggregate the past 24 hours on a rolling basis; when `false`, they aggregate the current day so far. | | dataflows | snowflake-cloud-cost-metrics | object | Cost data aggregated from the Snowflake `ORGANIZATION_USAGE` schema. Requires [Cloud Cost Management](https://docs.datadoghq.com/cloud_cost_management.md) to be set up for your organization, and the ORGANIZATION_BILLING_VIEWER database role on the Snowflake role; without both this dataflow collects no data. | | snowflake-cloud-cost-metrics | enabled | boolean | Whether Datadog collects this data. | | snowflake-cloud-cost-metrics | settings | object | Settings of the Cloud Cost Management dataflow. | | settings | query_tags | string | Snowflake query tags ingested as a comma-separated list of tag names, so that cost data can be broken down by them in Cloud Cost Management. | | dataflows | snowflake-data-observability-quality-monitoring | object | Data Observability, which collects lineage and data quality information from your Snowflake databases so you can explore how data flows and detect and resolve quality issues. | | snowflake-data-observability-quality-monitoring | enabled | boolean | Whether Datadog collects this data. | | snowflake-data-observability-quality-monitoring | settings | object | Settings of the Data Observability dataflow. | | settings | do_table_crawler_cron | string | Cron expression setting how often Datadog crawls your Snowflake table metadata. | | settings | sync_snowflake_system_database | boolean | Whether metadata from the Snowflake `SNOWFLAKE` system database is included in Data Observability alongside your own databases. | | dataflows | snowflake-event-table-logs | object | Records from your Snowflake event tables, used to monitor application behavior and identify issues. `enabled` turns the dataflow on and off as a whole, and the per-record-type toggles in `settings` select which kinds of record it collects while it is on. The Snowflake role needs usage granted on the database, the schema, and the event table itself; without those grants this dataflow collects no data. | | snowflake-event-table-logs | enabled | boolean | Whether Datadog collects this data. | | snowflake-event-table-logs | settings | object | Settings of the event table dataflow. Each record type is collected independently so that you can control ingestion costs, and every record type is ingested into Datadog as logs tagged with its `record_type`. | | settings | event_table_events_enabled | boolean | Whether records with a `record_type` of `event` are collected. | | settings | event_table_logs_enabled | boolean | Whether records with a `record_type` of `log` are collected. | | settings | event_table_logs_interval_min | int64 | How often event table records are collected, in minutes. | | settings | event_table_span_events_enabled | boolean | Whether records with a `record_type` of `span_event` are collected. | | settings | event_table_spans_enabled | boolean | Whether records with a `record_type` of `span` are collected. | | dataflows | snowflake-organization-usage-metrics | object | Organization-level usage metrics read from the Snowflake `ORGANIZATION_USAGE` schema, covering the credit consumption of every account in the organization and the history of data transferred out of Snowflake. Reading that schema requires the ORGADMIN role; without it this dataflow collects no data. | | snowflake-organization-usage-metrics | enabled | boolean | Whether Datadog collects this data. | | snowflake-organization-usage-metrics | settings | object | Settings of the organization usage metrics dataflow. | | settings | organization_usage_metrics_aggregate_last_24h | boolean | The period each metric aggregates over. When `true`, metrics aggregate the past 24 hours on a rolling basis; when `false`, they aggregate the current day so far. | | dataflows | snowflake-query-history-logs | object | Per-query logs that let you identify long-running, poorly performing, and expensive queries. | | snowflake-query-history-logs | enabled | boolean | Whether Datadog collects this data. | | snowflake-query-history-logs | settings | object | Settings of the query history logs dataflow. | | settings | join_query_history_with_access_history_enabled | boolean | Whether query logs are joined with Snowflake access history, which adds the objects each query read and wrote so you can follow how data is used and where it came from. | | settings | query_history_logs_interval_min | int64 | How often query history logs are collected, in minutes. | | dataflows | snowflake-security-logs | object | Security logs from the Snowflake `ACCOUNT_USAGE` schema, for analyzing the security of your Snowflake account and running threat detection with [Cloud SIEM](https://docs.datadoghq.com/security/cloud_siem.md). | | snowflake-security-logs | enabled | boolean | Whether Datadog collects this data. | | snowflake-security-logs | settings | object | Settings of the security logs dataflow. | | settings | security_logs_interval_min | int64 | How often security logs are collected, in minutes. | | dataflows | snowflake-task-history-logs | object | Execution logs for your scheduled Snowflake tasks, covering start time, end time, status, and any error message. | | snowflake-task-history-logs | enabled | boolean | Whether Datadog collects this data. | | snowflake-task-history-logs | settings | object | Settings of the task history logs dataflow. | | settings | task_history_logs_interval_min | int64 | How often task history logs are collected, in minutes. | | attributes | name [*required*] | string | Human-readable name of the Snowflake integration account. | | attributes | settings [*required*] | object | Settings configured on the Snowflake integration account. | | settings | snowflake_account_identifier [*required*] | string | Identifier of the Snowflake account being monitored. | | settings | username [*required*] | string | Snowflake user Datadog authenticates as. | | data | id [*required*] | string | Server-generated unique identifier of the Snowflake integration account. | | data | type [*required*] | enum | The type of the integration account resource. Always `integration-account`. Allowed enum values: `integration-account` | {% /tab %} {% tab title="Example" %} ```json { "data": { "attributes": { "authentication": { "auth_type": "snowflake_private_key", "private_key_name": "my-rsa-key" }, "dataflows": { "snowflake-account-usage-metrics": { "enabled": true, "settings": { "account_usage_metrics_aggregate_last_24h": false } }, "snowflake-cloud-cost-metrics": { "enabled": true, "settings": { "query_tags": "env,team,cost_center" } }, "snowflake-data-observability-quality-monitoring": { "enabled": true, "settings": { "do_table_crawler_cron": "0 */6 * * *", "sync_snowflake_system_database": true } }, "snowflake-event-table-logs": { "enabled": true, "settings": { "event_table_events_enabled": true, "event_table_logs_enabled": true, "event_table_logs_interval_min": 15, "event_table_span_events_enabled": false, "event_table_spans_enabled": false } }, "snowflake-organization-usage-metrics": { "enabled": true, "settings": { "organization_usage_metrics_aggregate_last_24h": false } }, "snowflake-query-history-logs": { "enabled": true, "settings": { "join_query_history_with_access_history_enabled": true, "query_history_logs_interval_min": 15 } }, "snowflake-security-logs": { "enabled": true, "settings": { "security_logs_interval_min": 60 } }, "snowflake-task-history-logs": { "enabled": true, "settings": { "task_history_logs_interval_min": 30 } } }, "name": "prod-snowflake", "settings": { "snowflake_account_identifier": "myorg-myaccount", "username": "datadog_user" } }, "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890", "type": "integration-account" } } ``` {% /tab %} {% /tab %} {% tab title="400" %} Bad Request {% tab title="Model" %} API error response. | Field | Type | Description | | ------------------------ | -------- | ----------------- | | errors [*required*] | [string] | A list of errors. | {% /tab %} {% tab title="Example" %} ```json { "errors": [ "Bad Request" ] } ``` {% /tab %} {% /tab %} {% tab title="403" %} Forbidden {% tab title="Model" %} API error response. | Field | Type | Description | | ------------------------ | -------- | ----------------- | | errors [*required*] | [string] | A list of errors. | {% /tab %} {% tab title="Example" %} ```json { "errors": [ "Bad Request" ] } ``` {% /tab %} {% /tab %} {% tab title="404" %} Not Found {% tab title="Model" %} API error response. | Field | Type | Description | | ------------------------ | -------- | ----------------- | | errors [*required*] | [string] | A list of errors. | {% /tab %} {% tab title="Example" %} ```json { "errors": [ "Bad Request" ] } ``` {% /tab %} {% /tab %} {% tab title="429" %} Too many requests {% tab title="Model" %} API error response. | Field | Type | Description | | ------------------------ | -------- | ----------------- | | errors [*required*] | [string] | A list of errors. | {% /tab %} {% tab title="Example" %} ```json { "errors": [ "Bad Request" ] } ``` {% /tab %} {% /tab %} ### Code Example ##### \# Path parameters export account_id="CHANGE_ME" \# Curl command curl -X GET "https://api.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts/${account_id}" \ -H "Accept: application/json" \ -H "DD-API-KEY: ${DD_API_KEY}" \ -H "DD-APPLICATION-KEY: ${DD_APP_KEY}" {% /tab %}