--- title: "List Snowflake integration accounts" method: GET path: "/api/v2/integration-interfaces/snowflake/accounts" tags: ["Snowflake Integration"] --- # List Snowflake integration accounts `GET /api/v2/integration-interfaces/snowflake/accounts` ## Request - Base URL: `https://api.datadoghq.com` - URL: `https://api.datadoghq.com/api/v2/integration-interfaces/snowflake/accounts` - Auth: one of: - API key in header `DD-API-KEY` and API key in header `DD-APPLICATION-KEY` - OAuth 2 - Authorization code: `/oauth2/v1/authorize` - Token URL: `/oauth2/v1/token` - TypeScript: (a function with typed inputs; its response is checked against the schema) List Snowflake integration accounts. ## Response `200` OK - SnowflakeIntegrationAccountsResponse: Response payload for a list of Snowflake integration accounts. - `data` SnowflakeIntegrationAccountResponseData[], required: List of Snowflake integration accounts. - `attributes` SnowflakeIntegrationAccountResponseAttributes, required: Attributes of a Snowflake integration account returned in responses. - `authentication` SnowflakeIntegrationAccountAuthenticationResponse: The RSA key pair authentication method configured on the account. - `auth_type` 'snowflake_private_key', required: The authentication method type. - `private_key_name` string, required: Name that distinguishes this private key from other keys in Datadog. - `dataflows` SnowflakeIntegrationDataflowsResponse: Data Datadog collects from Snowflake, keyed by dataflow id. - `snowflake-account-usage-metrics` SnowflakeAccountUsageMetricsIntegrationDataflowResponse: Account-level usage metrics read from the Snowflake `ACCOUNT_USAGE` schema, covering storage usage, credit consumption, and query activity. - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeAccountUsageMetricsIntegrationDataflowSettingsResponse: Settings of the account usage metrics dataflow. - `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. - `snowflake-cloud-cost-metrics` SnowflakeCloudCostMetricsIntegrationDataflowResponse: Cost data aggregated from the Snowflake `ORGANIZATION_USAGE` schema. Requires [Cloud Cost Management](https://docs.datadoghq.com/cloud_cost_management/) 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. - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeCloudCostMetricsIntegrationDataflowSettingsResponse: Settings of the Cloud Cost Management dataflow. - `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. - `snowflake-data-observability-quality-monitoring` SnowflakeDataObservabilityQualityMonitoringIntegrationDataflowResponse: 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. - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeDataObservabilityQualityMonitoringIntegrationDataflowSettingsResponse: Settings of the Data Observability dataflow. - `do_table_crawler_cron` string: Cron expression setting how often Datadog crawls your Snowflake table metadata. - `sync_snowflake_system_database` boolean: Whether metadata from the Snowflake `SNOWFLAKE` system database is included in Data Observability alongside your own databases. - `snowflake-event-table-logs` SnowflakeEventTableLogsIntegrationDataflowResponse: 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. - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeEventTableLogsIntegrationDataflowSettingsResponse: 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`. - `event_table_events_enabled` boolean: Whether records with a `record_type` of `event` are collected. - `event_table_logs_enabled` boolean: Whether records with a `record_type` of `log` are collected. - `event_table_logs_interval_min` integer: How often event table records are collected, in minutes. - `event_table_span_events_enabled` boolean: Whether records with a `record_type` of `span_event` are collected. - `event_table_spans_enabled` boolean: Whether records with a `record_type` of `span` are collected. - `snowflake-organization-usage-metrics` SnowflakeOrganizationUsageMetricsIntegrationDataflowResponse: 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. - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeOrganizationUsageMetricsIntegrationDataflowSettingsResponse: Settings of the organization usage metrics dataflow. - `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. - `snowflake-query-history-logs` SnowflakeQueryHistoryLogsIntegrationDataflowResponse: Per-query logs that let you identify long-running, poorly performing, and expensive queries. - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeQueryHistoryLogsIntegrationDataflowSettingsResponse: Settings of the query history logs dataflow. - `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. - `query_history_logs_interval_min` integer: How often query history logs are collected, in minutes. - `snowflake-security-logs` SnowflakeSecurityLogsIntegrationDataflowResponse: 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/). - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeSecurityLogsIntegrationDataflowSettingsResponse: Settings of the security logs dataflow. - `security_logs_interval_min` integer: How often security logs are collected, in minutes. - `snowflake-task-history-logs` SnowflakeTaskHistoryLogsIntegrationDataflowResponse: Execution logs for your scheduled Snowflake tasks, covering start time, end time, status, and any error message. - `enabled` boolean: Whether Datadog collects this data. - `settings` SnowflakeTaskHistoryLogsIntegrationDataflowSettingsResponse: Settings of the task history logs dataflow. - `task_history_logs_interval_min` integer: How often task history logs are collected, in minutes. - `name` string, required: Human-readable name of the Snowflake integration account. - `settings` SnowflakeIntegrationAccountSettingsResponse, required: Settings configured on the Snowflake integration account. - `snowflake_account_identifier` string, required: Identifier of the Snowflake account being monitored. - `username` string, required: Snowflake user Datadog authenticates as. - `id` string, required: Server-generated unique identifier of the Snowflake integration account. - `type` 'integration-account', required: The type of the integration account resource. Always `integration-account`. ## Other responses - `400`: Bad Request - `403`: Forbidden - `404`: Not Found - `429`: Too many requests --- [API](https://skmtc.dev/datadog/apis/datadog-api-v2-collection.md) - [All operations](https://skmtc.dev/datadog/apis/datadog-api-v2-collection/llms.txt) - [OpenAPI document](https://skmtc.dev/datadog/apis/datadog-api-v2-collection/revisions/3f70db624329?raw)