The Universal API for Snowflake provides a standardized way to interact with Snowflake databases. It allows developers to securely authenticate using OAuth 2.0 and execute SQL queries, including SELECT, INSERT, UPDATE, and DELETE operations. By abstracting the underlying connection details, this API simplifies data retrieval, schema management, and reporting tasks, enabling teams to focus on analytics and business logic rather than database-specific configurations.
POST Token
{{base_url}}/token
This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with the various API endpoints.
Body (form-data)
- username: {{Username}}
- password: {{Password}}
POST – API for Snowflake Database
Endpoint:
{{base_url}}/universalAPI?db_name=Snowflake&db_version=All
This endpoint allows access to the Universal API of the BizData360 platform for interacting with a Snowflake database.
Authorization
OAuth 2.0
Query Parameters
- db_name: Snowflake
- db_version: All
Body (raw JSON)
{
"username": "{{username}}",
"password": "{{password}}",
"query": "{{SELECT/INSERT QUERY}}",
"schema_name": "{{schema_name}}",
"hostname": "{{host_name}}",
"portnumber": {{port_number}}
}
