SourceDay Data as a Service (DaaS) gives you secure, direct access to your SourceDay procurement and performance data through a managed Snowflake environment. This allows you to connect, explore, and analyze your organization’s purchase order, supplier, and item data using your preferred BI tools or SQL queries.
This article walks you through how to log in, explore your data, and connect programmatically through the Snowflake SQL REST API.
Step 1 – Log in
You’ll receive a Snowflake URL and temporary credentials.
Visit the URL, log in, and update your password.
Step 2 – Explore data
Click “+” → SQL Worksheet to start querying.
-
Use the left-hand pane to browse tables and schemas.
In the open space on the right side you can run SQL queries.
Snowflakes SQL command reference documentation can be a good place to start in understanding the syntax used to query tables. The specific type of account being provided is called a Managed reader account, which has restrictions on which types of commands can be used; in short, the instance is restricted to read only commands, so the user will not be able to create saved views or perform permanent changes to data in the tables.
Step 3 – Systematic access
Use provided key pairs for programmatic access through the Snowflake SQL Rest API or other online libraries.
Example (Python):
Along with a username and password you will be provided with private keys and an account id to access snowflake via the Snowflake SQL Rest API or through some other library.
Example: connecting to and querying the DaaS data in python using the unencrypted token provided:
import sqlalchemy as sa
import pandas as pd
from cryptography.hazmat.backends import default_backend
from cryptography.hazmat.primitives import serialization
def serialize_secret(key):
p_key = serialization.load_pem_private_key(
key.encode('utf-8'),
password=None,
backend=default_backend())
pkb = p_key.private_bytes(
encoding=serialization.Encoding.DER,
format=serialization.PrivateFormat.PKCS8,
encryption_algorithm=serialization.NoEncryption())
return pkb
def daas_connect():
user = 'username'
acct = 'account_id'
pk = serialize_secret('private_key')
engine = sa.create_engine(
f'snowflake://{user}:@{acct}/DAAS?warehouse=COMPUTE_DAAS',
connect_args={'private_key': pk})
return engine
def daas_query():
con = daas_connect()
sql = 'SELECT COUNT(*) FROM daas.primary_entities.po_lines'
df = pd.read_sql(sql=sql, con=con)
df.to_csv('po_line_count.csv')
print(df)
daas_query()Snowflake provides additional information about Key pair authentication.
Once your DaaS environment is provisioned, you can quickly access and analyze SourceDay data using either the Snowflake web interface or automated scripts. You’ll use your provided credentials and key pairs to securely connect, run read-only SQL queries, and export results into your own systems.
With this setup, your team can integrate SourceDay intelligence directly into internal dashboards, automate reporting, and unlock deeper insights into supplier and procurement performance.