Search
⌃K
Links
🚀

Getting Started

API documentation

Overview

The Coherent API is a powerful tool that taps into the capabilities of the Snowflake API. Through this, users can seamlessly access and interact with data stored on the Coherent data shares dataset. The Coherent API supports the Snowflake SDK, which means you can utilize it with any programming language that Snowflake supports. Furthermore, the API allows you to execute any SQL query that is permissible on the Coherent data shares dataset.
One of the strengths of the Coherent API is its affordability. Users are billed at-cost, meaning you only pay for what you use. There are no hidden fees or extra charges, making it a cost-effective solution for your data needs.

Getting Started

Installation

Before starting, ensure that you have a Snowflake account. If you don't, you can sign up for a free trial. Snowflake is accessible via a browser-based web interface, the Snowflake command-line client (SnowSQL), and applications developed with Snowflake connectors and drivers​1​​2​.
To get started with Python, for example, you first need to install the Python Connector for Snowflake using pip:
Copy codepip install snowflake-connector-python
Please note that this requires Python version 3.7 or later​3​​4​.

Connection

Once installed, you can connect to Snowflake using the Python connector by providing your account details and credentials. An example of how to do this in Python is:
pythonCopy codeimport snowflake.connector
​
# Create a connection object
conn = snowflake.connector.connect(
user='<username>',
password='<password>',
account='<account_url>',
warehouse='<warehouse>',
database='<database>',
schema='<schema>'
)
​
# Create a cursor object
cur = conn.cursor()
​
# Execute a query
cur.execute('SELECT * FROM <table>')
​
# Fetch the results
results = cur.fetchall()
​
# Close the connection
conn.close()
In this script, replace <username>, <password>, <account_url>, <warehouse>, <database>, <schema>, and <table> with your actual Snowflake account details and the specific database and table you want to access.

Running Queries

The Coherent API allows you to run any SQL query that you can execute on the Coherent data shares dataset. This opens up a wide range of possibilities for data manipulation and retrieval. You can perform queries, manage your deployment (e.g., provision users and roles, create tables, etc.), submit SQL statements for execution, check the status of the execution of a statement, and even cancel the execution of a statement if necessary​5​.

Further Learning

This guide provides a basic introduction to the Coherent API. For more detailed information, please refer to the official Snowflake documentation, available here.
Remember, the potential of the Coherent API is vast and flexible. It's not just about accessing data; it's about leveraging the power of Snowflake to make your data work for you. With the Coherent API, the possibilities are nearly endless.