Community
Questions Library
Docs
Blog
Events
Swag
Github
Slack
JupiterOne
Discussions
Release Notes
Contact Us
Snowflake - AskJ1 Community
<main> <article class="userContent"> <h2 data-id="snowflake-jupiterone-integration-benefits">Snowflake + JupiterOne Integration Benefits</h2> <ul><li>Visualize Snowflake cloud resources in the JupiterOne graph.</li> <li>Map Snowflake users to employees in your JupiterOne account.</li> <li><p>Monitor visibility and governance of your Snowflake cloud environment by<br> leveraging hundreds of out of the box queries.</p></li> <li><p>Monitor changes to Snowflake cloud resources using JupiterOne alerts.</p></li> </ul><h2 data-id="how-it-works">How it Works</h2> <ul><li>JupiterOne periodically fetches Snowflake cloud resources to update the graph.</li> <li>Write JupiterOne queries to review and monitor updates to the graph.</li> <li>Configure alerts to take action when the JupiterOne graph changes.</li> </ul><h2 data-id="requirements">Requirements</h2> <ul><li><p>JupiterOne requires the full name of your Snowflake account. JupiterOne also<br> requires a user's username and password, and the default security role to<br> assume once connected to the session.</p></li> <li><p>You must have permission in JupiterOne to install new integrations.</p></li> </ul><h2 data-id="support">Support</h2> <p>If you need help with this integration, please contact<br><a rel="nofollow" href="https://support.jupiterone.io">JupiterOne Support</a>.</p> <h2 data-id="integration-walkthrough">Integration Walkthrough</h2> <h3 data-id="in-snowflake">In Snowflake</h3> <p>The integration ingests resources from tables in the Snowflake system using<br><code class="code codeInline" spellcheck="false" tabindex="0">SHOW</code> commands. The credentials provided to JupiterOne must be configured with<br> the<br><a rel="nofollow" href="https://docs.snowflake.com/en/user-guide/security-access-control-privileges.html#schema-privileges">read permissions required to perform these commands</a>.</p> <h3 data-id="in-jupiterone">In JupiterOne</h3> <ol><li>FFrom the top navigation of the J1 Search homepage, select <strong>Integrations</strong>.</li> <li>Scroll to the <strong>Snowflake</strong> integration tile and click it.</li> <li>Click the <strong>Add Configuration</strong> button and configure the following settings:</li> </ol><ul><li><p>Enter the <strong>Account Name</strong> by which you'd like to identify this Snowflake<br> account in JupiterOne. Ingested entities will have this value stored in<br><code class="code codeInline" spellcheck="false" tabindex="0">tag.AccountName</code> when <strong>Tag with Account Name</strong> is checked.</p></li> <li><p>Enter a <strong>Description</strong> that will further assist your team when identifying<br> the integration instance.</p></li> <li><p>Select a <strong>Polling Interval</strong> that you feel is sufficient for your monitoring<br> needs. You may leave this as <code class="code codeInline" spellcheck="false" tabindex="0">DISABLED</code> and manually execute the integration.</p></li> <li><p>Enter the <strong>Snowflake Account Name</strong> or full name of your account.</p></li> <li>Enter the <strong>Username</strong> of a user to authenticate with.</li> <li>Enter the <strong>Password</strong> of a user to authenticate with.</li> <li>Enter the <strong>Role</strong> or default security role to use for the session after you<br> authenticate.</li> </ul><ol start="4"><li>Click <strong>Create Configuration</strong> once all values are provided.</li> </ol><h2 data-id="how-to-uninstall">How to Uninstall</h2> <ol><li>From the top navigation of the J1 Search homepage, select <strong>Integrations</strong>.</li> <li>Scroll to the <strong>Snowflake</strong> integration tile and click it.</li> <li>Identify and click the <strong>integration to delete</strong>.</li> <li>Click the <strong>trash can</strong> icon.</li> <li>Click the <strong>Remove</strong> button to delete the integration.</li> </ol><h2 data-id="data-model">Data Model</h2> <h3 data-id="entities">Entities</h3> <p>The following entities are created:</p> <table><thead><tr><th>Resources</th> <th>Entity <code class="code codeInline" spellcheck="false" tabindex="0">_type</code></th> <th>Entity <code class="code codeInline" spellcheck="false" tabindex="0">_class</code></th> </tr></thead><tbody><tr><td>Database</td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_database</code></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">Datastore</code>, <code class="code codeInline" spellcheck="false" tabindex="0">Database</code></td> </tr><tr><td>Schema</td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_schema</code></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">Datastore</code>, <code class="code codeInline" spellcheck="false" tabindex="0">Database</code></td> </tr><tr><td>Table</td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_table</code></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">Datastore</code>, <code class="code codeInline" spellcheck="false" tabindex="0">Database</code></td> </tr><tr><td>User</td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_user</code></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">User</code></td> </tr><tr><td>Warehouse</td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_warehouse</code></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">Datastore</code>, <code class="code codeInline" spellcheck="false" tabindex="0">Database</code></td> </tr></tbody></table><h3 data-id="relationships">Relationships</h3> <p>The following relationships are created/mapped:</p> <table><thead><tr><th>Source Entity <code class="code codeInline" spellcheck="false" tabindex="0">_type</code></th> <th>Relationship <code class="code codeInline" spellcheck="false" tabindex="0">_class</code></th> <th>Target Entity <code class="code codeInline" spellcheck="false" tabindex="0">_type</code></th> </tr></thead><tbody><tr><td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_database</code></td> <td><strong>HAS</strong></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_schema</code></td> </tr><tr><td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_warehouse</code></td> <td><strong>HAS</strong></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_database</code></td> </tr><tr><td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_schema</code></td> <td><strong>HAS</strong></td> <td><code class="code codeInline" spellcheck="false" tabindex="0">snowflake_table</code></td> </tr></tbody></table> </article> </main>
.png)