# Warehouse Destinations

<p>RudderStack supports integration with all leading data warehouses. Now you can set up these warehouses as destinations in RudderStack and send all your event data from your preferred sources.</p>
<!-- end-chunk -->
<!-- begin-chunk -->
<h2 id="warehouse-destinations">Warehouse destinations</h2>

<div class="source-cards">
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/azure-synapse/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/azure-synapse.svg" alt="Azure Synapse logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Azure Synapse
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/bigquery/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/bigquery.svg" alt="BigQuery logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                BigQuery
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/clickhouse/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/clickhouse.svg" alt="ClickHouse logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                ClickHouse
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/sql-server/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/sql-server.webp" alt="Microsoft SQL Server logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Microsoft SQL Server
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/postgresql/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/postgresql.svg" alt="Postgres logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Postgres
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/redshift/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/redshift.svg" alt="Redshift logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Redshift
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/snowflake/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/snowflake.svg" alt="Snowflake logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Snowflake
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/snowflake-streaming/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/snowflake.svg" alt="Snowflake Streaming logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Snowflake Streaming
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
</div>
<br />
<!-- end-chunk -->
<!-- begin-chunk -->
<h2 id="data-lake-destinations">Data lake destinations</h2>

<div class="source-cards">
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/azure-datalake/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/azure-datalake.svg" alt="Azure Datalake logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Azure Datalake
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/delta-lake/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/databricks.webp" alt="Databricks (Delta Lake) logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Databricks (Delta Lake)
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/gcs-datalake/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/gcs.svg" alt="Google Cloud Storage Datalake logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                Google Cloud Storage Datalake
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
    
    
    <a href="/docs/destinations/warehouse-destinations/s3-datalake/" class="source-card">
        
        <div class="source-logo">
            <img src="/docs/images/logos/destinations/s3-datalake.svg" alt="S3 Datalake logo" loading="lazy" decoding="async">
        </div>
        
        <div class="source-card__content">
            <h3>
                S3 Datalake
                
                
                
            </h3>
        </div>
    </a>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
</div>
<br />
<!-- end-chunk -->
<!-- begin-chunk -->
<h2 id="warehouse-schema">Warehouse schema</h2><p>When sending your events to a data warehouse via RudderStack, you don&rsquo;t need to define a schema for your event data - RudderStack automatically does that for you by following a predefined <a href="https://www.rudderstack.com/docs/destinations/warehouse-destinations/warehouse-schema/" >warehouse schema</a>.</p>
<!-- end-chunk -->
<!-- begin-chunk -->
<h2 id="required-permissions">Required permissions</h2><ul>
<li><a href="https://www.rudderstack.com/docs/access-management/member-management/#member-roles" >Admins</a> have full access to create and manage destinations.</li>
<li><a href="https://www.rudderstack.com/docs/access-management/member-management/#member-roles" >Members</a> can have the following <a href="https://www.rudderstack.com/docs/access-management/policies-overview/#resource-permissions" >permissions</a> depending on their workspace policy:</li>
</ul>
<table>
  <thead>
      <tr>
          <th>Permission</th>
          <th><div>Description</div></th>
      </tr>
  </thead>
  <tbody>
      <tr>
          <td>Edit</td>
          <td>Make changes to the configuration of destinations</td>
      </tr>
      <tr>
          <td>Connect</td>
          <td>Connect a destination to a source or transformation</td>
      </tr>
      <tr>
          <td>Create &amp; Delete</td>
          <td>Create or delete destinations</td>
      </tr>
      <tr>
          <td>Retry Syncs</td>
          <td>Retry syncs for a destination in case of failures</td>
      </tr>
  </tbody>
</table>

<blockquote class="warning">
  <div class="tip-quote">
    
    <div class="tip-text">To make a connection, that is, connect a source to a destination, the member must have both <strong>Edit</strong> and <strong>Connect</strong> permissions on both the resources.</div>
  </div>
</blockquote>
<!-- end-chunk -->
<!-- begin-chunk -->
<h4 id="permissions-for-legacy-rbac-system">Permissions for legacy RBAC system</h4><p>In the <a href="https://www.rudderstack.com/docs/archive/dashboard-guides/user-management/" >legacy Permissions Management (RBAC) system</a>:</p>
<ul>
<li><a href="https://www.rudderstack.com/docs/archive/dashboard-guides/user-management/#organization-roles" >Org Admins</a> and members with the <a href="https://www.rudderstack.com/docs/archive/dashboard-guides/user-management/#connections" ><strong>Connections Admin</strong> role</a> in their workspace policy can create and delete destinations, manage their configuration, and connect them to sources</li>
<li>Members with the <a href="https://www.rudderstack.com/docs/archive/dashboard-guides/user-management/#connections" ><strong>Connections Editor</strong> role</a> in their workspace policy can only edit the destination configuration and connect destinations to sources</li>
</ul>

<figure class="image--main "  >
    <a 
         href="/docs/images/access-management/data-catalog-permissions-legacy-framework.webp"
        
        >
        <img src="/docs/images/access-management/data-catalog-permissions-legacy-framework.webp" 
         alt="Destinations permissions in the legacy framework"  
         
         
        decoding="async" loading="lazy" class="img-shortcode"/>
    </a>
    
</figure>

<!-- end-chunk -->
<!-- begin-chunk -->
<h2 id="faq">FAQ</h2><p>Refer to the comprehensive <a href="https://www.rudderstack.com/docs/destinations/warehouse-destinations/faq/" >FAQ</a> guide for the solutions to some of the commonly-asked questions around the RudderStack warehouse integrations.</p>