Snowflake Integration
Create a Snowflake integration account
Create a Snowflake integration account.
post/api/v2/integration-interfaces/snowflake/accounts
Request
- Base URLhttps://api.datadoghq.com
- Auth
- API key in header DD-API-KEY and API key in header DD-APPLICATION-KEY
- or OAuth 2Authorization code/oauth2/v1/authorizeToken URL/oauth2/v1/token
- TypeScriptA function with typed inputs. Its response is checked against the schema.
Request body
Example request
{
"data": {
"attributes": {
"authentication": {
"auth_type": "snowflake_private_key",
"private_key": "-----BEGIN PRIVATE KEY-----\nMIIE...\n-----END PRIVATE KEY-----",
"private_key_name": "my-rsa-key",
"private_key_passphrase": "your-private-key-passphrase"
},
"dataflows": {
"snowflake-account-usage-metrics": {
"enabled": true
},
"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
}
},
"snowflake-organization-usage-metrics": {
"enabled": true
},
"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"
}
},
"type": "integration-account"
}
}Response
Created
Example response
{
"data": {
"attributes": {
"authentication": {
"auth_type": "snowflake_private_key",
"private_key_name": "my-rsa-key"
},
"dataflows": {
"snowflake-account-usage-metrics": {
"enabled": true
},
"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
}
},
"snowflake-organization-usage-metrics": {
"enabled": true
},
"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"
}
}Changes
Changes to this operation have not been checked yet.