Databricks

Data Availability

Clients using Databricks 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

Databricks vs. API Coverage

Capability	Databricks	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 minutes of provisioning
No ETL Required: Data appears natively in your Databricks environment
ML/AI Ready: Direct integration with Databricks ML workflows, notebooks, and feature stores
Seamless Integration: Join Daloopa data with internal datasets without data movement
Scalable Access: Multiple teams can query without hitting API rate limits
Enterprise Security: Native Databricks access controls and Unity Catalog integration

How It Works

Daloopa distributes data via a private listing on the Databricks Marketplace using Delta Sharing. Once access is provisioned, you subscribe to the listing and can access data instantly in your Databricks 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. Verify Provider Access

-- List all available providers
SHOW PROVIDERS;

-- View Daloopa provider details
DESCRIBE PROVIDER daloopa;

-- List available shares
SHOW SHARES IN PROVIDER daloopa;

2. Create Catalog and Access Data

-- Create a catalog for Daloopa data
CREATE CATALOG IF NOT EXISTS daloopa USING SHARE daloopa.daloopa_share;

-- Query the companies table (fully available)
SELECT * FROM daloopa.shared.companies ORDER BY id ASC;

-- Query restricted tables (only shows data for subscribed companies)
SELECT * FROM daloopa.shared.series;

SELECT * FROM daloopa.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/databricks/company-subscription

Request Body:

{
  "company_id": <company_id>
}