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/06/17 09:33]
windsor_ai Added Snowflake tutorial: how to setup an account
snowflake [2023/09/04 07:09] (current)
windsor_ai [Frequently asked questions]
Line 27: Line 27:
 ===== 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.     - Use this tutorial to grant access to your Snowflake account.  
-    - Add all the columns that are returned by your connector's URL. {{:snowflake-tutorial-step-1.png?direct|}} 
     - Create the WINDOSR_UPLOAD role (name has no importance) {{::snowflake-tutorial-step-1.png?direct|}}     - 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|}}     - 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|}}     - Grant rights to the DATABASE to the created user {{:snowflake-tutorial-step-3.png?direct|}}
-    - Grand the rights to the destination table {{:snowflake-tutorial-step-4.png?direct|}} +    - Get the required fields from Snowflake to use the Snowflake destination in [[https://onboard.windsor.ai/|Onboard Form]] 
-    - Get the rerquired 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 username {{:snowflake-tutorial-step-5.1.png?direct|}}
       - Get the password {{:snowflake-tutorial-step-5.2.png?direct|}}       - Get the password {{:snowflake-tutorial-step-5.2.png?direct|}}
Line 43: Line 41:
       - Get the database {{:snowflake-tutorial-step-5.5.png?direct|}}       - Get the database {{:snowflake-tutorial-step-5.5.png?direct|}}
       - Get the schema {{:snowflake-tutorial-step-5.6.png?direct|}}       - Get the schema {{:snowflake-tutorial-step-5.6.png?direct|}}
-      - Get the table name {{:snowflake-tutorial-step-5.7.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.1623918800.txt.gz · Last modified: 2021/06/17 09:33 by windsor_ai