Getting Started

Learn how to use our connectors in less than 5 minutes!

Watch our tutorial video or read the directions below.

How to install a Connector Application

1. Sign in to your Snowflake account.

2. Head to the Marketplace section and look for a Nimbus Intelligence Connector Application.

3. Press on the Get button and wait for the installation to complete.

How to create a new Connection

1. Open the installed application (see How to install a Connector Application above). You will land in the Home pae.

2. Head to the Connections page to create a new Connection.

3. Fill in the Form in the "Manage Connections" section.

4. Click on the blue button to generate the pre-filled script.

5. Copy and paste the script into a new Worksheet and execute it completely.

6. Go back to the app and you will see the new connection appear under the "Current Connections" section.

You can select an endpoint and see if your new Connection has access to it. If you get an error on this point, it means one of the following:

• The credentials introduced are not valid. In this case, recreate the connection making sure there are no copy-paste errors or obtain a new set of credentials.

• The credentials introduced do not have access to this specific endpoint. This can probably be fixed by changing the scopes in the setting of the Connector (Personio, Hubspot...) Developer account.

How to create a new Configuration

1. Head to the Configurations page to create a new Configuration.

2. Select a previously created Connection (see How to create a new Connection above).

3. Fill in the form, providing a configuration name of your choice, a target database/schema... (*)

4. Press the Blue button and you will see the new Configuration appear in the "Current Configurations" section after a few seconds.

With a Configuration created you can already fetch data, although we recommend creating Schedules (see How to create a new Schedule below).

You can also edit Configurations selecting them and changing the form.

(*) If the target database/schema already exist, check the How to use pre-existing databases and schemas below.

How to create a new Schedule

1. Head to the Schedules page to craete a new Schedule.

2. Select a previously created Connection and Configuration (see How to create a new Connection/Configuration above).

3. Fill in the form, providing a schedule name of your choice, whether to use Full Refresh or Incremental jobs and the when to periodically run the job.

4. Press the Blue button and you will see the new Schedule appear in the "Current Schedules" section after a few seconds.

With a Schedule created, you data will periodically be fetched on the background. You can check the history of past jobs in the Job History page.

How to use pre-existing Databases and Schemas

When creating a Configuration you will have to provide where the fetched data has to be saved in the end. New tables have to be created on a Database and Schema of your choice. If either of these already exist, the application will need some privileges to be able to create tables in them.

Pre-existing Database

Execute the following command:

grant usage, create schema 
on database <db_to_use> 
to application <app_name>;

Pre-existing Schema

Execute the previous command and the following one:

grant usage, create table 
on schema <db_to_use>.<schema_to_use> 
to application <app_name>;