Snowflake

Data Availability

Clients using Snowflake have access to three core tables:

Companies: Company identifiers, metadata, and reference information
Series: Time-series financial data with period identifiers
Fundamentals: Core fundamental metrics and financial statement data

Snowflake vs. API Coverage

Capability	Snowflake	API
Companies	✓	✓
Series	✓	✓
Fundamentals	✓	✓
Download (company model)	—	✓
Export (CSV with series and datapoints)	—	✓
Industry Models	—	✓
Taxonomy (standardized metrics mapping)	✓	✓
Documents (download and keyword search)	—	✓

Future Data: Additional data sources will be added in future releases.

Important Details: Columns and fields for each table mirror our API responses with minor differences — clients familiar with our API will recognize the same structure.

Key Benefits

Zero Setup Time: Access data within 15 minutes of provisioning via the marketplace
No ETL Required: Data appears natively in your Snowflake account
Seamless Integration: Join Daloopa data with internal datasets without data movement
Scalable Access: Multiple teams can query without hitting API rate limits
Instant Updates: Data refreshes reflect immediately in your environment
Enterprise Security: Native Snowflake role-based access control

How It Works

Daloopa distributes data via a private listing on the Snowflake Marketplace. Once access is provisioned, you subscribe to the listing and can access data instantly in your Snowflake environment.

Schemas

Companies

Column	Type	Nullable
id	BIGINT	NOT NULL
name	STRING	YES
ticker	STRING	YES
industry	STRING	YES
sector	STRING	YES
company_identifiers	VARIANT	YES
model_updated_at	TIMESTAMP	YES
earliest_quarter	STRING	YES
latest_quarter	STRING	YES

Series

Column	Type	Nullable
id	BIGINT	NOT NULL
company_id	BIGINT	NOT NULL
full_series_name	STRING	YES

Fundamentals

Column	Type	Nullable
id	BIGINT	NOT NULL
company_id	BIGINT	NOT NULL
series_id	BIGINT	NOT NULL
label	STRING	YES
category	STRING	YES
title	STRING	YES
restated	BOOLEAN	YES
filing_type	STRING	YES
value_raw	DECIMAL(38,9)	YES
value_normalized	DECIMAL(38,9)	YES
unit	STRING	YES
calendar_period	STRING	YES
fiscal_period	STRING	YES
span	STRING	YES
fiscal_date	DATE	YES
document_id	BIGINT	YES
filing_date	DATE	YES
document_released_at	TIMESTAMP	YES
created_at	TIMESTAMP	YES
updated_at	TIMESTAMP	YES
is_incremental_update	BOOLEAN	YES

Taxonomy Metrics

Column	Type	Nullable
id	BIGINT	NOT NULL
name	STRING	NOT NULL
description	STRING	NOT NULL
global_metric	BOOLEAN	YES
fallback_metric_id	BIGINT	YES

Taxonomy Metric Series

Column	Type	Nullable
metric_id	BIGINT	NOT NULL
series_id	BIGINT	NOT NULL

Taxonomy Sub-Industries

Column	Type	Nullable
id	BIGINT	NOT NULL
name	STRING	NOT NULL
industry_name	STRING	NOT NULL
sub_sector_name	STRING	NOT NULL
sector_name	STRING	NOT NULL

Taxonomy Sub-Industry Companies

Column	Type	Nullable
sub_industry_id	BIGINT	NOT NULL
company_id	BIGINT	NOT NULL

Getting Started

1. Create Database from Listing

Install the Daloopa listing from the Snowflake Marketplace and create a database from it.

2. Access Data

-- Query the companies table (fully available)
SELECT * FROM <database_name>.SHARED.COMPANIES ORDER BY ID ASC;

-- Query restricted tables (only shows data for subscribed companies)
SELECT * FROM <database_name>.SHARED.SERIES;

SELECT * FROM <database_name>.SHARED.FUNDAMENTALS WHERE IS_INCREMENTAL_UPDATE;

The COMPANIES table is fully available, allowing you to browse all companies and decide which ones to subscribe to. The SERIES and FUNDAMENTALS tables are restricted and only return data for companies you are subscribed to. The FUNDAMENTALS table is further restricted — only users with a Daloopa Plus subscription are able to see fundamentals that are incremental.

3. Subscribe to Companies

To access data in SERIES and FUNDAMENTALS for a specific company, subscribe using the following endpoint with an API key:

Endpoint: POST https://app.daloopa.com/api/v2/snowflake/company-subscription

Request Body:

{
  "company_id": <company_id>
}