> For the complete documentation index, see [llms.txt](https://docs.neonblue.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.neonblue.ai/connectors/snowflake.md).

# Snowflake

## Exporting Data From Neon Blue

### **Step 1: Find your Snowflake account Data Sharing Cccount Identifier.** 

Your **data sharing account identifier** uniquely names your Snowflake account in the form `ORGNAME.ACCOUNTNAME`.

You can get it from the Snowsight UI or with SQL.

#### Option A: Snowsight (UI)

1. Sign in to [Snowsight](https://app.snowflake.com/).
2. Open the **account selector** in the lower-left corner.
3. Find the account you use with Neon Blue and select **View account details**.
4. In the **Account Details** dialog, copy the **Data sharing account identifier**.

#### Option B: SQL

Run this in a worksheet while connected to the relevant account:

```sql
SELECT CURRENT_ORGANIZATION_NAME() AS org_name,
       CURRENT_ACCOUNT_NAME()      AS account_name,
       CURRENT_ORGANIZATION_NAME() || '.' || CURRENT_ACCOUNT_NAME() AS account_identifier;
```

* `CURRENT_ORGANIZATION_NAME()` returns your organization name.
* `CURRENT_ACCOUNT_NAME()` returns your account name.

The `account_identifier` column is what you'll provide to Neon Blue or enter in the portal.

### **Step 2:** Receiving data from Neon Blue (install the shared listing)

Use this when you want Neon Blue's datasets available in your own warehouse. Neon Blue publishes a **private listing** targeted directly at your account. For additional documentation see Snowflake's [documentation](https://docs.snowflake.com/en/collaboration/consumer-listings-access#access-a-private-listing).

#### Provide your account identifier

In the Neon Blue portal, register the account you want the data delivered.

1. In the sidebar, click **Integrations.**
2. Find the **Snowflake (Export)** integration and click **Connect**.
3. Paste the **account identifier** from Step 1 and click **Connect**.
4. Neon Blue will publish the private listing to your account and replicate it to your region.

#### Install the listing in Snowsight

1. Sign in to [Snowsight](https://docs.snowflake.com/user-guide/ui-snowsight-gs#label-snowsight-getting-started-sign-in).
2. In the navigation menu, select **Data sharing** » **External sharing**.
3. On the **Shared with you** page under **Privately shared listings**, select the listing you want to access.
4. Select **Get**.