---
updatedAt: 2025-11-12T01:46:39.000Z
agentTools:
  projectIndex: https://docs.simondata.com/llms.txt
---

# Snowflake

> ✅ Snowflake Data Share is an optional premium feature.
>
> Contact your account manager to get started.

# Snowflake credential requirements

Snowflake allows for cross account data access via secure [data shares](https://docs.snowflake.net/manuals/user-guide/data-sharing-intro.html) and Simon takes advantage of this capability so you can share the required schemas, tables and fields directly into your Simon account.

Start by setting up a [secure data share in Snowflake](https://docs.snowflake.net/manuals/user-guide/data-sharing-gs.html), then:

1. Create a `share` using the `accountadmin` role:

```sql
Use role accountadmin;

Create share clientname_simondata;
```

2. Add `objects` to the share by granting privileges:

```sql
Grant usage on database {client prod_db_name} to share clientname_simondata;

Grant usage on schema {client schema_name} to share clientname_simondata;

Grant select on table {client table_name} to share clientname_simondata;
```

> 📘 Add each table explicitly
>
> You need to add each table explicitly to the share and make sure your ETL maintains access for the share.

3. Add Simon's Snowflake account to the newly created share:

```sql
alter share clientname_simondata add accounts=em41824;
```