Before enabling Crunchbase Data in Snowflake, please make sure you have requested access. To do so, please follow this guide: Snowflake Installation Guide
Crunchbase data is available in 4 different packages which correspond to our API/CSV offerings: Firmographic, Core Financials, Advanced Financials, and Predictions & Insights.
Snowflake now offers Crunchbase data equivalent to our CSVs. Customers can now access Crunchbase data directly from snowflake for analysis or to move data to their preferred location.
To install a new package
- Login to Snowflake
- Navigate to private sharing under data products on the left selection pane
- Find the Crunchbase offering (it's listed in: shared with you)
- Click on Get and add the offering as a new database for users with the correct permissions
- You should now be able to see the Crunchbase database with tables and secure views under data
Where to find the offering in Snowflake
The Crunchbase Snowflake offering consists of both tables and views, is read only, and is updated daily. For more information on tables and views see: Snowflake DB Overview
Tables Vs Views
For each package, Crunchbase provides both Tables and Secure Views. Each table contains an UUID and corresponding properties to that UUID that can be unpacked. For faster, more specified queries, users can also use views for each unpacked property in tables. This can be seen below:
Table
As you can see the column in this particular table's Address information in our core financials packages is broken into 2 columns UUID and a properties object containing all 11 additional fields. When querying this table a user would need to further unpack the properties object to find detailed information.
View
Inside views you can see the data is already unpacked into 12 columns, UUID and all the detailed properties of addresses.
How to make queries
Helpful tools to find fields or compare to legacy: Data Dictionary
SQL command to get queryable columns in a view:
Examples
If you want to find organizations that have between 251 and 500 employees that are still active and are in the AI space - The following query would generate a list of companies that match that criteria:
If you are looking to generate a list of firms that have received Series C funding since the start of 2024, you could use the following query:
If you are looking to find the companies who have the highest rank on Crunchbase and their funding the last 2 years, you can use the following query:
If you are looking for organizations with a high probability of IPO, you can use the following query:
Looking up field value labels
You can use a left join with the: field value labels table to translate some of our outputs into more legible responses: