How to Set Up Dakota Marketplace Data in Snowflake

How to Set Up Dakota Marketplace Data in Snowflake
4:27

Data sourced from Dakota Marketplace, the global LP and GP intelligence platform trusted by thousands of investment professionals. Learn More | Book a Demo

Getting Dakota Marketplace data into Snowflake takes two steps on your side and no code. Our 250,000+ allocator accounts and 386,000+ verified contacts arrive in your Snowflake account as a private share, installed in a few clicks and ready to query with the SQL your team already writes.

There’s no ETL pipeline to build, no files to transfer, and no developers to pull off other projects. You send us one identifier, we issue the share, and you install it.

In this article, we’ll walk through what to decide before you start, how to find and send your Data Sharing Account Identifier, what we do on our end, and how to install and query Dakota data once it’s live.

Before You Start

It helps to decide two things up front:

  • What data you need. We tailor every private share to your firm. If your team only cares about RIAs, for example, you can receive just RIA accounts and contacts, and nothing else.
  • Whether you want to test first. We can set up demo users in our own Snowflake instance, so your team can walk through the installation, see how the data appears, and test queries before connecting your production environment.

Step 1: Find and Send Your Data Sharing Account Identifier

Your Data Sharing Account Identifier is the only thing we need from you to set up the share.

To find it:

  1. Log in to your Snowflake account.

  2. Go to Account.

  3. Select View Account Details.

  4. Copy your Data Sharing Account Identifier.

  5. Send it securely to the Dakota team.

What We Do on Our End

Once we receive your Data Sharing Account Identifier, our team:

  • Scopes the dataset to the accounts and contacts your firm needs
  • Issues the Dakota application to your Snowflake account
  • Confirms with you when the share is ready to install

Want to talk through what your share should include before you send your identifier? Book a demo with our team.

Step 2: Install the Dakota Share

When we confirm your share is ready, installing it takes a few clicks:

  1. In Snowflake, go to Data Sharing, then Private Sharing.

  2. Under Direct Shares, find the Dakota application that has been shared to your account.

  3. Click Get data to install it.

  4. Once installed, you’ll have view access to the shared data and can query it directly in Snowflake.

After Setup: Putting the Data to Work

Once the share is installed, Dakota data appears in your Snowflake account as its own database. Your team queries it like any other table, using the same SQL, dashboards, and reports you already run.

The shared data is view-only, so the source stays exactly as we deliver it. The best practice is to join it to your own tables, such as your CRM records and fundraising history, and write any enriched results to databases your firm owns.

Want the bigger picture on how the integration works and who it’s built for? Read What Is a Snowflake Integration With Dakota Marketplace?

Frequently Asked Questions

What do I need to send Dakota to get started?

Just your Data Sharing Account Identifier. You’ll find it in Snowflake under Account, then View Account Details.

Do I need developers to set this up?

No. You send us your identifier and install the share through Private Sharing. Unlike our API, there’s no custom code involved.

Can I test Dakota data before connecting production?

Yes. We can create demo users in our own Snowflake instance so your team can experience the installation process, explore how the data appears, and test queries first.

Can I edit the Dakota data in my Snowflake account?

The shared data is view-only. Your team can query it, join it to your own tables, and write results to your own databases.

Is Dakota data available in Databricks too?

Yes. We offer the same private share model in Databricks, and many of the largest firms run both platforms.

Get Dakota Data Into Your Snowflake Account

Dakota Marketplace’s 250,000+ allocator accounts and 386,000+ verified contacts can be live in your Snowflake account in two steps. Scope your share to the allocator types, geographies, and contacts your team targets, then query it next to your own fundraising data.

Ready to set up Dakota data in Snowflake? Book a demo.

Morgan Holycross, Marketing Manager

Written By: Morgan Holycross, Marketing Manager

Morgan Holycross is a Marketing Manager at Dakota.