Snowflake

On this page

• Requirements
• Set up Snowflake as a data source
  • Customer Match
  • Offline conversion import
  • Apply a use case later
• Find your Snowflake account identifiers
  • Through the user menu
  • Using SQL commands
• Troubleshoot errors

---

Requirements

• You must have Snowflake account credentials (username and password).
• You must have a Snowflake account with access to the table containing the data you’d like to use. You can create an account that only has access to the data needed for your use case.

---

Set up Snowflake as a data source

Customer Match

Through the "Audience manager" page

Offline conversion import

Through the "Conversions" page

1. Sign in to your Search Ads 360  account.
2. Navigate to a sub-manager account .
3. Go to the Conversionsdropdown under “Tools & settings” and select Summary.
4. Select + Create conversion action.
5. Select Import.
6. Select CRMs, files, or other data sources.
7. Select a tracking method.
8. In the “Data source” card, select Connect a new data source.
   • If you previously linked a data source from the Data manager screen that you want to use, choose  Select an existing source.
9. Search and select Snowflakefrom the list of data sources.
10. Select Direct connection, then select Continue.
11. Read and accept the customer data policy, then select Continue.
12. Select a category from the conversion goal list, then select Set up.
13. Enter your Snowflake account identifier, username, and password, then select Connect.
14. Enter the Snowflake warehouse, database, schema, and table (or view) that you want to use, then select Next.
15. Optional: You can add filters to select the records you want to import. This is important especially if you have multiple different conversion goals in the file you will be importing. Learn more about using filters .
16. To map fields, select the data source fields from the dropdown lists that match the destination fields.
17. Optional: Apply transformations to your data.
18. Select Next.
19. Enter a name for this connection.
20. Optional: Edit connection details .
21. Select Finish.
22. Select Save and continue.

Apply a use case later

In this type of setup, you complete each part of the connection at different times. This can be useful when you are ready to link a data source, but you are not ready to set up your use case, for example, you aren’t ready to create a customer list.

Step 1. Initiate the connection to the data source

Set up a data source and create a connection to be associated with a use case later.

1. Sign in to your Search Ads 360  account.
2. Navigate to a sub-manager account .
3. In the page menu, select Setupdrop-down, and then select Data manager.
4. Select + Connect Product.
5. Under Data source, search and select a data source from the list of products.
6. If prompted, select Direct connection.
7. Select your use case, read and accept the customer data policy, then select Continue. If you select Audiences, you are prompted to select the data type at this step.
8. Enter your data source location and credentials*, then select Next.
9. To map fields, select the data source fields from the dropdown lists that match the destination fields.
10. Optional: Apply transformations to your data.
11. Select Next.
12. Enter a name for this connection.
13. Optional: Edit connection details .
14. Select Finish.

* Use the same credentials and location details for this data source as described in the first part of this article.

Step 2. Complete the connection by applying a use case

1. Open the destination you intend to use–for example, begin to create a new customer list or conversion goal using the steps from the previous sections. Return to these steps before completing the data source step.
2. Under Data source, choose Select an existing source.
3. Select the data source that was initiated in Step 1 from the list of data sources.
4. Continue to follow the remaining steps for your use case in the first part of this article. Note that you’ll need to re-enter your Snowflake account identifier, username, and password when connecting the existing data source to a new audience or conversion action.

---

Find your Snowflake account identifiers

Use Snowsight , Snowflake’s web interface, to find your Snowflake account identifier . You can find your Snowflake account identifiers through the user menu or by using SQL commands.

Through the user menu

1. Below the Snowsight navigation menu, click your user name to open the user menu.
2. Select Accountto open the account selector.
3. Hover over the account to view additional details, including the account identifier
4. Select the copy icon to copy the account identifier.

Using SQL commands

1. Below the Snowsight navigation menu, click your user name to open the user menu.
2. In the account selector, review the list of accounts that you previously signed in to.
3. Under your chosen account, select View account details.
4. Under “Account Details”, select the “SQL Commands” tab to find and copy the SQL statement that returns the account identifier.
5. To retrieve the organization of your current account, run this SQL command to get your organization’s name:

6. To retrieve the name of the current account, run this SQL command to get your account’s name:

7. Combine the organization and account names with a hyphen to get the account identifier for configuring a client, driver, or library to connect to Snowflake.

This will return the account identifier in the format “ orgname-account_name ”.

---

Troubleshoot errors

• Ensure that your conversion goal has successfully connected to the chosen connection. Otherwise, no data will come in.