Getting Started
Learn how to use our connectors in less than 5 minutes!
How to install a Connector Application
Sign in to your Snowflake account.
Head to the Marketplace section and look for a Nimbus Intelligence Connector Application.
Press on the Get button and wait for the installation to complete.
How to create a new Connection
Open the installed application (see How to install a Connector Application above). You will land in the
Home
pae.Head to the
Connections
page to create a newConnection
.Fill in the Form in the "Manage Connections" section.
Click on the blue button to generate the pre-filled script.
Copy and paste the script into a new Worksheet and execute it completely.
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
Head to the
Configurations
page to create a newConfiguration
.Select a previously created
Connection
(see How to create a new Connection above).Fill in the form, providing a configuration name of your choice, a target database/schema... (*)
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
Head to the
Schedules
page to craete a newSchedule
.Select a previously created
Connection
andConfiguration
(see How to create a new Connection/Configuration above).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.
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>;
Last updated