User Tools

Site Tools


snowflake

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
snowflake [2021/05/29 02:20]
windsor_ai
snowflake [2023/09/04 07:09] (current)
windsor_ai [Frequently asked questions]
Line 3: Line 3:
 Windsor.ai and Snowflake allow you to Windsor.ai and Snowflake allow you to
  
-  * Connect all your marketing, sales and CRM data (e.g. Facebook Ads, Google Ads, Google Analytics, Salesforce) +  * Connect all your marketing, salesand CRM data (e.g. Facebook Ads, Google Ads, Google Analytics, Salesforce) 
-  * Apply data driven attribution on the conversion journeys to understand the contribution each touchpoint has on a channel, campaign, ad level+  * Apply data-driven attribution on the conversion journeys to understand the contribution each touchpoint has on a channel, campaign, ad level
   * Join in the costs of all the connected channels to understand the cost per acquisition (CPA) or return on ad spend (ROAS)   * Join in the costs of all the connected channels to understand the cost per acquisition (CPA) or return on ad spend (ROAS)
   * Make decisions   * Make decisions
  
  
-=== Expected workflow ===+===== Expected workflow =====
  
 ==== Connect all your marketing, sales and CRM data ===== ==== Connect all your marketing, sales and CRM data =====
Line 25: Line 25:
  
  
-==== Frequently asked questions ====+===== Frequently asked questions =====
  
-  * How do I get my data into Snowflake?+=== How do I get my data into Snowflake ===
  
   - Create a [[https://onboard.windsor.ai|Windsor.ai]] account and connect all the sources which you would like to stream to Snowflake.   - Create a [[https://onboard.windsor.ai|Windsor.ai]] account and connect all the sources which you would like to stream to Snowflake.
 +  - Use this tutorial to grant access to your Snowflake account.  
 +    - Create the WINDOSR_UPLOAD role (name has no importance) {{::snowflake-tutorial-step-1.png?direct|}}
 +    - Create a user and add the previously created role to that user {{:snowflake-tutorial-step-2.png?direct|}}
 +    - Grant rights to the DATABASE to the created user {{:snowflake-tutorial-step-3.png?direct|}}
 +    - Get the required fields from Snowflake to use the Snowflake destination in [[https://onboard.windsor.ai/|Onboard Form]] 
 +      - Get the username {{:snowflake-tutorial-step-5.1.png?direct|}}
 +      - Get the password {{:snowflake-tutorial-step-5.2.png?direct|}}
 +      - Get the account {{:snowflake-tutorial-step-5.3.png?direct|}}
 +      - Get the warehouse {{:snowflake-tutorial-step-5.4.png?direct|}}
 +      - Get the database {{:snowflake-tutorial-step-5.5.png?direct|}}
 +      - Get the schema {{:snowflake-tutorial-step-5.6.png?direct|}}
   - In **2. Select Destination** select Snowflake as destination \\ {{ :snowflake_integration_1.png?nolink&800 |}}   - In **2. Select Destination** select Snowflake as destination \\ {{ :snowflake_integration_1.png?nolink&800 |}}
   - Enter all the credentials required and click **Save** \\ {{ :snowflake_integration_2.png?nolink&800 |}}   - Enter all the credentials required and click **Save** \\ {{ :snowflake_integration_2.png?nolink&800 |}}
   - Your data will now be streamed to Snowflake. In case there is an error you will be notified.   - Your data will now be streamed to Snowflake. In case there is an error you will be notified.
 + 
 +===What fields and data types are available?=== 
 +Check our [[https://windsor.ai/connector/attribution-connector/|connector documentation]] for all the fields available
 +
    
snowflake.1622251246.txt.gz · Last modified: 2021/05/29 02:20 by windsor_ai