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.

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:

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.

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.

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.