Snowflake Integration

Orbital shares data with your team using Snowflake Secure Data Sharing. This is the fastest, most secure way to access data—no ETL, no duplication.

We also support pushing data into your Snowflake account via a service account if needed.

Overview

Orbital securely shares data with customers in one of two strategies:

1. Secure data sharing

2. Service user access in a Tenant instance

Option 1: Secure Data Sharing (Recommended)

Orbital owns the data and shares it with your Snowflake account using native secure shares.

Steps:

1. Send us your Snowflake Account Locator

   Example: AB12345.us-west-2

   Find this in the Snowflake UI under your profile > "Account".

2. Orbital will create a share and grant your account access

3. Create a database from the share in your Snowflake instance:

   CREATE DATABASE orbital_data FROM SHARE orbital_account.orbital_share;
   

   Replace:

   • orbital_account with Orbital’s Snowflake account ID (we’ll provide it)

   • orbital_share with the share name (we’ll provide it)

4. Query the data:

   SELECT * FROM orbital_data.schema_name.table_name;
   

You now have live, real-time access to Orbital’s shared data. No syncing, no ETL, no data duplication

Option 2: Orbital Pushes Data into Your Snowflake

If you prefer that Orbital writes data directly into your Snowflake instance, we can use a service account with read/write + schema modification access to your designated schema

Steps:

1. Create a dedicated role and user for Orbital:

   CREATE ROLE orbital_writer;
   
   CREATE USER orbital_user
     PASSWORD = '<strong-password>'
     DEFAULT_ROLE = orbital_writer
     MUST_CHANGE_PASSWORD = FALSE;
   
   GRANT ROLE orbital_writer TO USER orbital_user;
   

2. Grant full access to the target schema:

   GRANT USAGE ON DATABASE your_db TO ROLE orbital_writer;
   GRANT USAGE ON SCHEMA your_db.your_schema TO ROLE orbital_writer;
   
   GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA your_db.your_schema TO ROLE orbital_writer;
   GRANT CREATE TABLE, CREATE VIEW, CREATE FUNCTION, MODIFY ON SCHEMA your_db.your_schema TO ROLE orbital_writer;
   
   -- Optional: Grant access to future tables/views
   GRANT SELECT, INSERT, UPDATE, DELETE ON FUTURE TABLES IN SCHEMA your_db.your_schema TO ROLE orbital_writer;
   

3. Send connection details to Orbital securely via the Orbital Console - We support both password and key-pair authentication.

Once configured, Orbital will be able to ingest, update, and manage schema objects within the specified scope